Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Column limitation in SpreadSheet (enhance to > 16k)|
|Component:||ui||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||gbpacheco, issues, kami911, kyoshida, ooo, openoffice, pagalmes.lists|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
|Issue Depends on:|
Description bettlerthomas 2008-02-12 21:14:53 UTC
Please increase the column limit to match at least the limit of MS Excel (which is currently at 16k). btw: KSpread supports 32k. The objective must be the compatibility between all those office solutions. Another important question: Why is the limit statically implemented [hardcoded] on application level? Wouldn't it be smarter to define it per spreadsheet [or even omit an explicit limit] say have a dynamic solution? This is the logical sequence of Bug 31612, [which had been in pipe already 4 years]
Comment 1 pmike 2008-02-13 07:33:09 UTC
this issue is dup for issue 19440 please transfer your votes
Comment 2 oc 2008-02-13 10:03:49 UTC
Reassign to owner requirements
Comment 3 bettlerthomas 2008-02-13 14:47:52 UTC
Nope, read correctly, it isn't dup. The other issue is about number of rows and sheets but not about nr of cols!
Comment 4 mestech 2008-02-15 15:50:34 UTC
This issue is related to the increase in the number of rows to compete/surpass other applications. http://www.openoffice.org/issues/show_bug.cgi?id=30215
Comment 5 bettlerthomas 2008-02-17 18:19:02 UTC
So what was then about bug 31612? Honestly, I don't get your logic...
Comment 7 kslays 2008-05-17 18:16:15 UTC
From nsaa on Issue 30215 (further thoughts on row limits) To manually hack an increase to the number of columns: http://wiki.services.openoffice.org/wiki/Calc/hacks/number_of_rows Change MAXCOLCOUNT_DEFINE in sc/inc/address.hxx to a multiple of 16.
Comment 8 bettlerthomas 2008-05-19 18:55:24 UTC
Of course this workaround exists. But I'd like to send these the large docs to anyone using OO.o. So this isn't the right way.
Comment 9 mestech 2008-05-23 16:13:53 UTC
Now that the row limit <http://www.openoffice.org/issues/show_bug.cgi?id=30215> is being targeted for 3.0, maybe this should be as well to ensure compatibility for Microsoft's planned support for ODF in 2007.
Comment 10 oc 2008-07-15 10:43:54 UTC
reassigning features and enhancements to user firstname.lastname@example.org which will be the default owner for those tasks (was introduced some time ago)
Comment 11 davidsarmstrong 2009-06-01 10:02:22 UTC
I agree that this is an issue that may not happen often but when it does it is a show-stopper. Even more important is the row count limitation.