Apache OpenOffice (AOO) Bugzilla – Issue 6763
"easy" 32000 row limitation workaround
Last modified: 2003-09-08 16:55:29 UTC
How about: when one row or column limit is reached, the last row or column is marked as "continued in ..." and the rows or columns of the next sheet are used. When sheets are used up, a new Calc document is created where the sheets continue. This can be done "behind the back" ie it's not visible to the user but only internally and the user is presented with infinte rows, columns and sheets - displaying should be no problem, but "data processing" is executed on new sheets or documents as said. Implementing this "workaround" should be more easy and fast and therefore be a good way in the meantime while you work on "really" removing the limitation. And when you reimplement the "table" model - you should go the way of infinite rows etc. Lars
Don't know what gave you the impression but implementing this workaround wouldn't be in no way easier than working on the row-limit plan already lined out.
closing
And, we consired to stop working around. If somethings done it should be done neat. Regards, Peter +1 closed
just an explanation: i thought of it working like "verkettete listen" (data management) where one can wrap those containers by an overloaded C++ operator [], so access is the same as an array even though the underlying storage is "spread". Now as a user can manually use x*32000 rows by using several sheets, this can as well be "executed" automatically by the software. Of course it needs some code written but it should be "doable" within 2 days especially if one knows the spreadsheet table sourcecode. And "If somethings done it should be done neat" : I aggree! But as a intermediate solution... it's good (actually really) and one doesn't have to wait 5+ months.