File sizes when saving in .xls format

answered 2012-12-24 13:26:27 +0200

ROSt52
1779 ● 30 ● 30

This is not the answers but I made a test with the file provided

1. saved the file as it opens on my desktop: size 31.5 kB
2. added my name into a cell and saved: 31.6 kB
3. added numbers from 1111 to 5275 with increment 1, thus 4164 4 digit figures and saved: 56.8

Hope this information helps to find the solution.

LibO 5.6.4.3 on XP/SP3

answered 2012-08-14 23:52:01 +0200

Fernando
1

I guess LO Calc 3.5 is considering the blank lines of all the spreadsheets as non blank lines. I had this problem with Excel and had to delet all unused lines after the last used line. I opened with Excel the xls file saved in Calc and did it, then the file size decreased.

answered 2013-03-20 19:17:42 +0200

Hendy
1

I recently experienced this (assuming I understand the queston properly) and think I have an idea about what's going on. Information:

$ uname -a Linux hostname 3.8.3-2-ARCH #1 SMP PREEMPT Sun Mar 17 13:04:22 CET 2013 x86_64 GNU/Linux

$ libreoffice --version LibreOffice 4.0.1.2

I believe that for some reason, some cell in distant rows/columns gets registered as containing a value, despite being blank. When exporting to xlsx, I think Libreoffice is storing some sort of value in all columns/rows up to that distant cell. Alternatively LO is potentially storing some sort of data in all blank rows/columns instead of just leaving them absent when exporting.

I suspect this, as on a hunch I selected the first blank column of my data and did Ctrl + Shift + Right Arrow. This selects all columns up to AMJ. Then right click and choose "Delete columns."

Repeat for rows and do Ctrl + Shift + Down Arrow and delete all blank rows.

I then did "Save as..." from .ods -> .xlsx successfully.

• Before doing this: ~20kb .ods saves as 3.4mb .xlsx
• After deleting blank rows/columns as described above, I get a ~21kb .xlsx instead.

answered 2012-07-26 05:42:32 +0200

qubit
5693 ● 3 ● 48 ● 41

To clarify: You're saying that a file you created in LO 3.4 of size 30K has turned into a 9MB file by opening and then saving in LO 3.5?

It would be very helpful if you could attach the original 30K file to this question do that we can try to reproduce your problem locally. If you can't share the original file, you could try to create a modified version of the file (or a wholly new file) that demonstrates the same bug.

answered 2013-01-24 05:12:31 +0200

ROSt52
1779 ● 30 ● 30

I don't have yet the solution but I downloaded the file linked with ".Keswick 2012 Week 3.ods" and saved it on my desktop and the file size is 32 KB. I can see 5tabs (Day 1-5) 1 tab Event Weekly Shop Report. All sheets look OK to me.

However, I don't know yet why the file gets so big at your PC.

I using XP/SP3 on LibO 3.6.4.3