Issue 65038 - Calc - 2.4MB file with miniscule amount of data in the file.
Summary: Calc - 2.4MB file with miniscule amount of data in the file.
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 680m164
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2006-05-03 13:33 UTC by kpalagin
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

testcase (508.85 KB, application/x-compressed)
2006-05-03 13:33 UTC, kpalagin
no flags Details
zip file with testcase (14.97 KB, application/x-compressed)
2006-07-11 15:52 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2006-05-03 13:33:06 UTC
When I save attached file with Calc it has size of 2.4MB, which seems to be
wrong for just bunch of cells. When I save the same file with Excel fiel size is
reduced to 8 kbytes, which is much better.
Comment 1 kpalagin 2006-05-03 13:33:50 UTC
Created attachment 36232 [details]
Comment 2 dridgway 2006-05-24 06:09:30 UTC
The .xls file in the attached zip does indeed get much smaller after being
opened and resaved by Excel, so there's something funny with the file. How did
the file get generated? With Calc? Can you find a procedure for reproducibly
generating such problematic files?

Possibly related or dupe of issue 59220.
Comment 3 kpalagin 2006-05-24 11:29:39 UTC
The file was generated by inhouse app, then second file was generated by the 
same app, Vlookup from one to another was added, lines below 11 were removed 
and first file was saved. 
Comment 4 dridgway 2006-05-30 06:08:21 UTC
I'm guessing that you used OO Calc to do the editing, but there's still not enough information to 
reproduce the behavior and determine if OO is at fault, rather than Excel or your inhouse app. Please see and for tips. It might help to attach the 
file before editing with OO, give a procedure for reproducing what you see, and say explicitly how it differs 
from what you expected.
Comment 5 dridgway 2006-07-10 05:02:22 UTC
No clear reproducible procedure, no followup for > 2 wks: I'll resolve this
issue for the time being. It can be reopened if the requested information is
Comment 6 frank 2006-07-11 11:06:18 UTC

the document has this big size due to the also saved vlookup sheet from the
linked file. This is necessary as you want the data given from the vlookup to
appear in an unupdated document. Excel doesn't show these values as I've seen.

So we have possibly the choice to shorten the place needed in the file according
to DR by using another method of storing the data in the Excel file.

Comment 7 frank 2006-07-11 11:07:01 UTC
re-opened and targeted 
Comment 8 frank 2006-07-11 11:07:28 UTC
enhancement and new
Comment 9 kpalagin 2006-07-11 15:51:31 UTC
I have better testcase (see attached .zip).
testcase.txt is original file,
xls.xls is produced by importing original into Excel and saving it from Excel 
(size 15KB),
xls-ooo.xls is produced by opening xls.xls with Calc and saving it in .xls 
format (note its size - 76KB).

Of further interest
000.xls - produced by importing original file into OOO and saving it in .xls 
format (75KB),
ooo-xls.xls - produced by opening ooo.xls with Excel and saving it in .xls 
format (9KB).
Comment 10 kpalagin 2006-07-11 15:52:25 UTC
Created attachment 37667 [details]
zip file with testcase