some sheets in excel workbook is blank when opened in libreoffice calc

asked 2015-07-24 12:03:09 +0200

Ajit Nair gravatar image

updated 2015-08-24 09:25:31 +0200

Alex Kemp gravatar image

Using Libreoffice 4.4.4.3. Workbook having 10 sheets of which atleast five are blank Sheet has data when opened in Excel.

edit retag flag offensive close merge delete

Comments

Can you share some sample file?

m.a.riosv gravatar imagem.a.riosv ( 2015-07-24 13:57:27 +0200 )edit

Apparently this happens if the file is opened from the network drive. I am opening it from a windows mapped drive. I tried opening the file after copying to local disk & it works fine. Any idea why this happens?

Ajit Nair gravatar imageAjit Nair ( 2015-07-24 15:07:28 +0200 )edit

Daily I open files in that way and don't remember an issue like that, with any version of LibreOffice.

m.a.riosv gravatar imagem.a.riosv ( 2015-07-24 22:18:36 +0200 )edit

Can you download this file from the link and test for me? I am using this in a windows domain network. I am trying to open this file on a windows 8.1 64 bit machine.

https://onedrive.live.com/redir?resid...

Ajit Nair gravatar imageAjit Nair ( 2015-07-25 07:08:13 +0200 )edit

I can see data in sheets from 1999-2000 up 2014-2015 and the last "LIST OF COMPUTERS & PERIPHERALS" all with data. Sounds strange that LIbreOffice doesn't give an error if not the whole file is loaded. Maybe is neede to wait a bit giving time to a some process to finish?

m.a.riosv gravatar imagem.a.riosv ( 2015-07-25 11:35:36 +0200 )edit

any suggestions how we can find that particular process which is causing this?

Ajit Nair gravatar imageAjit Nair ( 2015-07-25 17:50:37 +0200 )edit

Test resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/U...

m.a.riosv gravatar imagem.a.riosv ( 2015-07-25 19:17:03 +0200 )edit
cornouws gravatar imagecornouws ( 2016-02-05 16:27:46 +0200 )edit