[Solved] Maximum Number of Sheets?

[TexasTwister]

Hi folks,

I have a Calc document that was created 1/25/15. It has 256 sheets, 44853 cells, and 1139 pages (whatever that is). It is 361,537 bytes in size.

It seems I am no longer able to "Move/Copy Sheet" which is the process I used to add additional sheets by right clicking on a sheet and using the resulting pop-up menu. The document contains many sheets of similar data separated by date, one date per sheet.

As an OLD school Windows guy, I recognize that "256" is a magic number in the programming world (8, 16, 32, 64, 128, 256, etc.)

Is my Calc document maxed out at 256 sheets, but only 353K in size? I've searched the forum, but the results seemed inconclusive to me.

Thanks for your replies!

[FJCC]

The limit does seem to be 256 sheets. It is not a matter of the file size. You cannot exceed that limit even if the sheets are empty.
Spreading data across so many sheets is probably not the best way to layout the data. Someone might be able to suggest a better approach if you explain what you are trying to do.

[robleyd]

You've reached the limit of sheets - see this article in the AOO Wiki.

LibreOffice has a maximum of 10000 sheets if you really need that many

[TexasTwister]

Thank you everyone. When I started this document, it only had a couple of sheets. It was established to keep track of items I bought through various auction houses...one sheet for every auction house purchase and it's date. I guess I've reached the limit of OpenOffice Calc.

I know in my old Excel days, I could convert sheets and rows to an Access database format (if my memory serves me right). Maybe I'll look at LibreOffice?

Best regards everyone. Thank you for your input!

[Villeroy]

Appliation hopping will not solve your problem. No matter if LibreOffice Calc, OpenOffice Calc, Excel, LibreOffice Base, OpenOffice Base or MS Access, using multiple tables for equally structured data is a big mistake -- always, no exception whatsoever.

Run this macro to merge 255 of your 256 into the 256th without losing information: viewtopic.php?f=21&t=93099