Bug 130938 - FILESAVE number of columns can't exceed 256.
Summary: FILESAVE number of columns can't exceed 256.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-25 21:21 UTC by Alex G.
Modified: 2020-02-25 21:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alex G. 2020-02-25 21:21:38 UTC 
FILESAVE:  My spreadsheet extends to column IV. I have entries in every column that precedes this one (that is, from A to Z, AA to AZ, etc.) When I enter values into column IW and IX, everything appears okay. But after closing the file and opening it again, the new entries have disappeared!!! It's like the Calc program can't handle a spreadsheet greater than IV columns wide (ie., 256 columns). Or, when it saves a spreadsheet of this size, it destroys the entries at the far "right end".

Note, I always save in Excel '97-2003  ".xls" format.

all the best
Al Gabis
Fairfield, Iowa
agabisjr@yahoo.com
Comment 1 m_a_riosv 2020-02-25 21:28:49 UTC 
That it's a file format limitation, using the native format (ods) for LibreOffice the limit is 1024 columns.

Please don't expose your email in the comments, this is a public site.

In any case it is not a bug.