Ask Your Question
0

Blank columns created when saving [closed]

asked 2013-06-28 13:20:48 +0200

Fury556 gravatar image

updated 2015-11-07 12:40:41 +0200

Alex Kemp gravatar image

Hi all,

A spreadsheet we use for work purposes (Created and saved in XLSX 2010 format) does not save correctly when used in LibreOffice/Calc. You can edit and save the file fine, but if you reopen it or try to upload it to the file processer it reports thousands of additional columns. If you reopen the file in Excel, you can see it is expecting data in additional columns, the uploader sees these blank columns and it breaks the processor. Any suggestions for preventing Calc from creating or filling these extra columns?

Thanks in advance!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 12:40:51.435799

2 Answers

Sort by » oldest newest most voted
0

answered 2013-09-03 19:45:32 +0200

brownsr gravatar image

I also have this problem. In my case I have a template .xlsx from a marketplace site that needs to be filled in to load details. It has sixteen columns as I recollect. All I do is fill it in in Libreoffice (on linux mint), save it back in .xlsx format, and upload it, and the validation then complains it has around a thousand columns rather than the expected number

edit flag offensive delete link more
0

answered 2013-06-29 01:48:51 +0200

m.a.riosv gravatar image

Maybe you have set up some style or column width different from default.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-06-28 13:20:48 +0200

Seen: 183 times

Last updated: Sep 03 '13