Ask Your Question

"Warning" when loading file in to Calc.

asked 2020-02-14 14:08:45 +0100

StuartB gravatar image

updated 2020-02-14 14:51:00 +0100

ebot gravatar image

This is the (error) warning, but I've never used a spreadsheet before so don't know how to fix it. If I click OK the spreadsheet loads and works correctly. I think I've uploaded the file here if anyone wants to have a look. Any help would be appreciated.

image description


edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2020-02-14 14:47:49 +0100

keme gravatar image

Excel currently supports 16384 columns while Calc can only handle 1024 columns. However, there does not seem to be any content present outside of the first screenful or so.

It looks like your file has been "touched" in column 16141. Possibly some formatting applied to the range. If you save a copy from Calc, the error message should disappear. Make sure to keep the original intact, just in case...

edit flag offensive delete link more

answered 2020-02-14 14:49:36 +0100

Opaque gravatar image

updated 2020-02-14 14:52:24 +0100


LibreOffice calc supports 1024 (2^10) columns only, while MS Excel supports 16384 (2^14) columns. Therefore you get that error.

See also #tdf50916

edit flag offensive delete link more

answered 2020-02-15 14:12:18 +0100

StuartB gravatar image

Thanks very much for the replies. As sugessted, saving a copy from within Calc has stopped it happening. Appreciate the help. :)

edit flag offensive delete link more

answered 2020-02-14 14:52:00 +0100

ebot gravatar image

updated 2020-02-14 15:20:40 +0100

It is'nt an error! It's a Warning!

Excel and Calc have different numbers of columns.

Normally it should still work if the data in the sheet does not exceed it.

Try it!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-14 14:08:45 +0100

Seen: 40 times

Last updated: Feb 15