Issue 86049 - Column limitation in SpreadSheet (enhance to > 16k)
Summary: Column limitation in SpreadSheet (enhance to > 16k)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial with 21 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 126506 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
 
Reported: 2008-02-12 21:14 UTC by bettlerthomas
Modified: 2015-09-06 11:10 UTC (History)
7 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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. ***