Issue 86049

Summary: Column limitation in SpreadSheet (enhance to > 16k)
Product: Calc Reporter: bettlerthomas <bettlertho>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: gbpacheco, issues, kami911, kyoshida, ooo, openoffice, pagalmes.lists
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 15522    

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 6 craketech 2008-04-05 13:00:15 UTC
*** Issue 86049 has been confirmed by votes. ***
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 requirements@openoffice.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.
Comment 12 Marcus 2015-09-06 11:10:30 UTC
*** Issue 126506 has been marked as a duplicate of this issue. ***