Issue 31612 - Column limitation in SpreadSheet
Summary: Column limitation in SpreadSheet
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 16 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2004-07-16 17:59 UTC by moseby_nt
Modified: 2013-08-07 15:15 UTC (History)
5 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description moseby_nt 2004-07-16 17:59:15 UTC
Please increase the column limit in calc from 256.  I find most of my problems
with DataPilot failing to generate, involve running out of columns.  The lack of
error message detail when that happens confounds.  If there must be a maximum, I
don't know what it should be.  Just today I could use double (512), but more
would be welcome.

I've searched the website and found a doc talking about increasing the 32000 row
limit, but nothing on the column limit.  Sorry if this is a dupe.
Comment 1 frank 2004-07-19 10:52:36 UTC
Hi Bettina,

one for your department.

Comment 2 bettlerthomas 2006-12-14 17:41:28 UTC
So, any news here?
Is it still on the To-Do list? (didn´t find it there)
Are there any plans for OO.o 2.2 ?

I'like to ask, weather ODF/ISO 26300 proposes this limit, or is it a tecnical
limitation? - I just heard rumors, that Excel 2007 will break it and reach behind.
Other products already support more than 256 cols (i.e. KSpreak which reaches to
32k [and has of course support for csv files])

As I currently work with a 300x300 matrix, this limit is not handful in my
special case and I had to go for an other software.

Comment 3 ooo 2006-12-15 18:25:34 UTC
No plans for 2.x, also not an ODF file format limitation, "just" technical
challenges. See also

However, implementation of slightly more columns (say 512 or so) may be easier
to cleanup, mostly work to be done in preventing export to binary file formats,
than going up to 16k columns or increasing rows to 1M.
Comment 4 bettlerthomas 2006-12-17 18:15:41 UTC
But we should introduce this, as Excel 2007 will handle bigger Spreadsheets than we do right now. 
IMHO, we won't gain nothing just waiting for the future to solve the troubles.Therefore I would be 
glad to see things changing.

Let's handle the limits per document type, but not as a feature of the application.
Comment 5 flaamwing 2007-02-22 21:00:28 UTC
I often work with 640 x 480 arrays, and it would be especially handy to drop
them into a spreadsheet to test various things on them.  Right now, I have to
break them into pieces to drop them in - then recombine afterwards.  Its a real
pain.  More columns would be incredibly helpful.
Comment 6 kpalagin 2007-03-25 16:23:59 UTC
Seems to be dup of

Please transfer votes to 30215.

*** This issue has been marked as a duplicate of 30215 ***
Comment 7 kpalagin 2007-03-25 16:24:30 UTC
and closing.
Comment 8 ooo 2007-03-27 16:04:42 UTC
This is _not_ a duplicate of issue 30215, which is about the row limit whereas
this issue here is about the column limit. The issues are kept separate for
technical reasons because different problems have to be solved. It would
probably be easier to quadruple the number of columns first than to increase the
number of rows to a million or so.
Comment 9 mestech 2007-07-30 20:53:29 UTC
As with rows, the amount of data that scientists are getting is surpassing the
limitations of OOo spreadsheets.  I routinily get data sets that use 300 or 400
columns to work with now.  Yea, this is a limit in Excell, at least until 2007
came out.

I just voted for this issue.

I would suggest that the limit be higher than what is available in Office 2007
or even plan for an easy path to increase the number of columns.
Comment 10 Regina Henschel 2007-07-30 22:29:05 UTC
Excel 2007 has 16384 columns.
Comment 11 bettina.haberer 2007-09-26 15:56:59 UTC
Hi Niklas, these RFEs are in your ownership.
Comment 12 machaven 2007-10-04 09:43:59 UTC
Please consider this.
Comment 13 craketech 2008-01-03 10:57:11 UTC
This along with increasing the row limit should be worked on. I want to move to
using Open Office but these limits prevent it.
Comment 14 niklas.nebel 2008-01-23 13:24:05 UTC
Plan is to have 1024 columns in 3.0.
Comment 15 kpalagin 2008-01-23 13:47:24 UTC
thanks a lot for bringing this up.
Is there a technical reason to set limit so low?

Comment 16 niklas.nebel 2008-01-23 13:52:40 UTC
We're mostly keeping the fixed-size structure, and don't want to run into
performance problems.
Comment 17 Regina Henschel 2008-01-23 16:03:52 UTC
For my personal way of using it, 1024 columns are enough. But it might not be
enough to import Excel 2007 spreadsheets. In Excel 2007 you can use 1.048.576
rows and 16.384 columns.
Comment 18 kpalagin 2008-01-23 17:29:20 UTC
I guess you have considered introducing in "calc.xcu" an option that will set 
this limit? Those with specific need and fast CPUs can have 16K columns, 
everybody else will get default of 1024.
Comment 19 mestech 2008-01-23 18:19:40 UTC
If OpenOffice is going to compete, the features have to be as good or better
than MS's product.

I don't see any issue with 1024 columns today but it could be an issue tomorrow
which would limit me.  

To me, if the number of columns can be dynamic, only created as necessary, the
performance won't be that big of a hit.  Also if it is dynamic, (Only the number
needed), there could be a performance improvement.  If you only need 10 columns,
then only 10 are saved.  Maybe a default 2^6 columns with the ability to create
upto 2^15 columns if required.  This is one bit better than MS.  :)

I prefer the dynamic way of creating columns (and rows) over a static need.

If there is going to be modifications for the number of columns, then why impose
another small limit.  I hate to say it but MS has set the bar and OOo has to at
least make that level to remain competitive.
Comment 20 niklas.nebel 2008-01-28 17:59:43 UTC
The change to 1024 columns is on CWS "calccolumns".

The "used area" logic for automatic print ranges, HTML/RTF export, and the
Ctrl-End keyboard shortcut has changed:
If there are at least 30 equal-formatted columns somewhere behind the last
column that has cell contents, the attributes in these and the following columns
are ignored in determining the used area.
Comment 21 niklas.nebel 2008-01-29 14:29:23 UTC
back to QA for verification
Comment 22 oc 2008-02-08 10:48:17 UTC
verified in cws_calccolumns
Comment 23 bettlerthomas 2008-02-08 23:50:57 UTC
So the 1024 columns are now in. Anyway, that's not enough - it's just a temporary enhanced limit.

How shall we proceed to ask for at least 16k rows ?
- reopen this bug
- file a new issue

I propose to reuse this issue. Please consider reopening it, as it has only been fulfilled partly.
Comment 24 mestech 2008-02-12 16:33:11 UTC
bettlerthomas, I sort of agree with you but in real terms of the OP's comment,
the issue has been fixed.  The request was for 1024 or more, not to compete with
MS Office 2007.

I suppose that an issue should be created to increase the column count to equal
or surpass that of MS Office 2007 to remain competitive in todays market.

The new issue should reference this issue and the number should also be posted
into this issue.

My issue is rows, not columns at this time.

But I have said it before, has to meet the MS Office latest
specifications or be better.  This is a marketing issue that MS can use against
OOo.  They may even use this in their push for OOXML as an ISO standard as an
indication that OOXML can meet higher standards.

Comment 25 bettlerthomas 2008-02-12 21:01:22 UTC
Well, to insist on the initial request would mean to just ignore all those propositions added by voters 
and watchers!

Seriously, if I had filed a such bug 4 years ago it would had been closed as a DUP, wouldn't it?
So by now I should reintroduce a new bug - simply with the same content, except for the initial 
request for 16k? - Honestly, I can't follow your logic.

Therefore I propose to reopen THIS very issue, because it's just the same one...
Comment 26 bettlerthomas 2008-02-12 21:16:17 UTC
OK, ok, just to give you the choice....

reopen this one ...

or treat its successor issue 86049
Comment 27 thackert 2008-08-05 17:30:33 UTC
As there are 1.024 columns in m28 possible, I will close this issue.