I am using Libreoffice

In Calc (the spreadsheet), I am trying to build an appointment book. Since this is designed a bit like a calendar, I have rows and columns that I want to be able to group.

If there is a public holiday we are closed and no appointments. So I want to be able to click once, and close a bunch of columns. Otherwise these columns are just blank because we have no appointments written down on that day.

I can group the rows without issue. (Actually learned how to do this from another Superuser post!)

I can also group the columns. But unlike for the rows, I cannot save my groupings. IE when the worksheet is open, I can group and manipulate the cell appearances. But once I save and close and open again, the groupings for columns vanish. Which defeats the purpose of having an appointment book that can't save changes, at least for this specific grouping thing.

Rows and Columns Q

Rows and Columns Q2

Rows and Columns Q3

(click on image for larger view)


You must save in ODF format for column groupings to be saved.

warning when saving as .xlsx

Excel can read ODF format, or you can export a copy as PDF. But saving as XLSX from Calc or saving as ODF from Excel is going to result in problems.

| improve this answer | |

Answer is correct! Thank you!

(I couldn't find any option to lock this thread, so this post is made to say that the answer worked and my question has been answered. Thank you again!)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.