Launchpad has imported 18 comments from the remote bug at
http://qa.openoffice.org/issues/show_bug.cgi?id=86049.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2008-02-12T21:14:53+00:00 tho wrote:

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]

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/0

------------------------------------------------------------------------
On 2008-02-13T07:33:09+00:00 Www-openoffice-org wrote:

this issue is dup for issue 19440
please transfer your votes

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/1

------------------------------------------------------------------------
On 2008-02-13T10:03:49+00:00 Oc-n wrote:

Reassign to owner requirements

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/2

------------------------------------------------------------------------
On 2008-02-13T14:47:52+00:00 tho wrote:

Nope, read correctly, it isn't dup.

The other issue is about number of rows and sheets but not about nr of
cols!

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/3

------------------------------------------------------------------------
On 2008-02-15T15:50:34+00:00 Robin-laing wrote:

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


Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/4

------------------------------------------------------------------------
On 2008-02-17T18:19:02+00:00 tho wrote:

So what was then about bug 31612?

Honestly, I don't get your logic...

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/5

------------------------------------------------------------------------
On 2008-04-05T13:00:15+00:00 Crake wrote:

*** Issue 86049 has been confirmed by votes. ***

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/6

------------------------------------------------------------------------
On 2008-05-17T18:16:15+00:00 Kayleflap wrote:

>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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/7

------------------------------------------------------------------------
On 2008-05-19T18:55:24+00:00 tho wrote:

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/8

------------------------------------------------------------------------
On 2008-05-23T16:13:53+00:00 Robin-laing wrote:

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.


Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/9

------------------------------------------------------------------------
On 2008-07-15T10:43:54+00:00 Oc-n wrote:

reassigning features and enhancements to user requireme...@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/15

------------------------------------------------------------------------
On 2009-06-01T10:02:22+00:00 Davidsarmstrong wrote:

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/20

------------------------------------------------------------------------
On 2015-09-06T11:10:30+00:00 Mkrcds wrote:

*** Issue 126506 has been marked as a duplicate of this issue. ***

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/26

------------------------------------------------------------------------
On 2022-08-18T22:40:34+00:00 Agnostos88 wrote:

For anyone interested, LibreOffice 7.4 was released today with support
for 16384 columns in Calc: https://llunak.blogspot.com/2022/03/enabling-
calc-support-for-16384-columns.html

Technical details blogpost from 2017:
https://niocs.github.io/LOBook/misc/16kcols.html

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/27

------------------------------------------------------------------------
On 2022-08-19T16:54:13+00:00 Petko-p wrote:

Other alternatives are gnumneric with 16,384 columns (http://www.gnumeric.org/) 
as LO.
And Caligra Sheets with 32,767 Columns (https://calligra.org/) as max value.
Both have this feature for years.

So other Open Source Spreadsheet apps are much more powerfull in this respect, 
or have the feature for longer time, but they do not feel the need to advertise 
their product in other projects bug tracker like spammers do.
I hope you understand that bug trackers are a development tool and not a 
evaluation platform for the best tooling. Use other channels if you feel the 
need for your dvertisements.

Thank you!

All the best
Peter

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/28

------------------------------------------------------------------------
On 2022-08-19T17:23:51+00:00 Mseidel-k wrote:

He may not be aware that LO license does not allow us to take code from
them...

But maybe reading the technical blogpost can give us some hints?

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/29

------------------------------------------------------------------------
On 2022-08-19T21:43:56+00:00 Petko-p wrote:

Ohh no. I did not consider that. It seems I am to frustrated on some
statements, to even consider this. :( This is of course wrong and not
what I want.

I am sorry. Please take my apologies.

yes we should look into this too.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/30

------------------------------------------------------------------------
On 2022-08-24T21:25:24+00:00 Petko-p wrote:

Okay, in order to add morte columens we need to change the way lots of
fields are processed. Currently SC moves through all fields in order for
update. This is very slow, anmd becomes slower if there are more fields.

LO did move to a vector array, enhanced the formula of processing and
they are now confident to increase the field amount.

I am not sure this is the right track. It depends on the way the table is build 
and I am not sure the container type is the best decision that has been taken.
Especially if you think that a table might not be uniform. I have an Idea how 
to solve this issue, but I need to experiment a bit. Also more research is 
needed.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/240895/comments/31


** Changed in: openoffice
       Status: Confirmed => Unknown

** Changed in: openoffice
   Importance: Unknown => Low

** Bug watch added: OpenOffice.org Issue Tracker #30215
   http://qa.openoffice.org/issues/show_bug.cgi?id=30215

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/240895

Title:
  OpenOffice.org Calc does not have enough columns

Status in OpenOffice:
  Unknown
Status in libreoffice package in Ubuntu:
  Invalid
Status in openoffice.org package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org

  I opened the attached Excel 1997-2003 spreadsheet that has a lot of
  columns (one for every day of the year, plus a few more).  However
  OpenOffice.org Calc will only display the columns up until "IV".  That
  means that the last 3 months of the year are not visible.

  Please fix this.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openoffice/+bug/240895/+subscriptions


-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to     : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp

Reply via email to