Ask Your Question
0

Unable to open .xls file in LO Calc

asked 2016-07-27 11:59:47 +0200

w0r0n gravatar image

I have a xls file 35mb. Calc 5.0.6 and 5.1.4 can't open it. Microsoft Excel can open and save it. I opened this file in MS Excel and saved it in ODS format. LO Calc not able to open this ODS file.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2016-07-29 09:07:47 +0200

w0r0n gravatar image

I removed the image columns and the file is opened. LO Calc can't display many rows with pictures. 1000 rows displays slowly, 1500 lines displays very slowly, and 2000 lines for a very long time but displays. 2500 lines already does not display. Something wrong with the mechanism of output rows with pictures.

edit flag offensive delete link more
0

answered 2016-07-29 17:05:44 +0200

petermau gravatar image

If you have a very large spreadsheet with images, you may not have enough memory. On a Linux system TOOLS > OPTIONS > Memory. Memory is a software balancing act between most users with their simpler requirements and performance. It is the memory in working storage you need to consider, not the saved compressed file.

edit flag offensive delete link more

Comments

If you'll notice in the thread, Excel 2007 opens the file when LO Calc 5.1.4.2 does not. While I agree with your observations related to memory, I'm not sure they are relevant here. My 64-bit Win7 machine has an Intel i7 2.4GHz processor with 16GB of RAM. Besides, one would expect LO Calc to open the file if Excel 2007 can -- wouldn't you agree?

LKeithJordan gravatar imageLKeithJordan ( 2016-07-30 00:49:29 +0200 )edit

Have you tried increasing the allocated memory? This is a standard option to try with performance issues. We are considering software memory allocation not the physical hardware. Anyway, if you were me I would give it a try.

petermau gravatar imagepetermau ( 2016-07-30 11:44:33 +0200 )edit
0

answered 2016-07-27 15:04:20 +0200

LKeithJordan gravatar image

updated 2016-07-29 16:16:39 +0200

2016.0729 UPDATE

I just reported the issue to Bugzilla. See https://bugs.documentfoundation.org/s....

==========================
2016.0728 UPDATE

Because of character limits in comments, I am revising my original response to reply to your comments.

No, you are correct -- saving to CSV doesn't make any sense when the file includes images. You failed to mention that fact in your original post.

I'm running LO Calc Version: 5.1.4.2 and MS Excel 2007 (12.0.6750.5000). The laptop used in my test is an older model, MSI gaming laptop I originally had custom built for business use. The laptop is running Windows 7.

Excel opened your file fairly quickly, albeit with a short delay to display all of the images. LO Calc, on the other hand, tried to open the file but became non-responsive. I had to close the application through Windows Task Manager.

While preparing a file to attach to a bug report, I found the answer -- at least for now. Since this is a very large file, I deleted a substantial number of rows, leaving the first two or three primary groups and the last primary group. I then saved the file to xls file format, ignoring the feature compatibility fidelity loss warning. The resulting file opened quickly in both Excel and LO Calc.

I do not have time to determine how many rows are necessary before Calc fails. I suggest you begin removing one primary group at a time to determine when LO Calc is no longer able to open the file. When you find that point, I also suggest you test just the last group deleted (deleting all primary groups before and after) to see if there is a problem with that group.

If you do find a problem with a particular group, you should continue surgical deletions until you find the specific row causing the problem. Then go back to the original file, delete just that specific row, and see if you can open the saved copy results. If so, there may be a corruption of some sort in an image -- but I doubt this since Excel opens the file.

If, on the other hand, the number of image rows appears to be the problem, you need to find the break point where opening the file fails. This needs to be reported as a bug. Unfortunately, the file attachment size for reporting bugs is limited to 10MB and your file is 35MB, so separate arrangements may have to be made for getting a test file to The Documents Foundation.

The Top Level Domain (TLD) in your link indicates you are from Russia. I do not read Cyrillic, but the format of your spreadsheet seems to suggest you are trying to create some sort of e-commerce shopping page.

If so, I strongly suggest you use HTML, CSS, and MySQL (or other web-based database manager) for this purpose. If, instead, your work is to be housed on the local computer, I strongly ... (more)

edit flag offensive delete link more

Comments

In my file a lot of pictures - save to CSV it doesn't make any sense. I failed to attach the file here. I can provide a link - http://rkb1c.ru/soft/35mb.xls

w0r0n gravatar imagew0r0n ( 2016-07-28 07:57:04 +0200 )edit

Because of character limits in comments, I am revising my original response to reply to your comments.

LKeithJordan gravatar imageLKeithJordan ( 2016-07-28 15:15:09 +0200 )edit

Ok. I'll try to find the cell which causes it to hang LO Calc and cut the file up to the limit in 10MB. Original file created not by me but by our supplier. I know to shove a bunch of pictures in the file .xls is not very productive.

w0r0n gravatar imagew0r0n ( 2016-07-29 07:57:16 +0200 )edit

I removed the image columns and the file is opened. LO Calc can't display many rows with pictures. 1000 rows displays slowly, 1500 lines displays very slowly, and 2000 lines for a very long time but displays. 2500 lines already does not display. Something wrong with the mechanism of output rows with pictures.

w0r0n gravatar imagew0r0n ( 2016-07-29 09:06:19 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-07-27 11:59:47 +0200

Seen: 313 times

Last updated: Jul 29 '16