Ask Your Question
0

Missing Row in XLSX Spreadsheet

asked 2017-02-05 22:38:02 +0200

whbecker4799 gravatar image

I have a very simple spreadsheet that I download in xlsx format from a financial web site. When opened in Excel, it is fine. When opened in LibreOffice

Version: 5.3.0.3 (x64) Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1 Windows 10 (x64)

one row appears to be missing. In fact, it is there, but it has zero height. A careful row height adjustment will expand it to visibility.

Here is a link to the sample file: https://www.dropbox.com/s/b4qtvxj7b6x...

Is this a known bug? If not, how should I report it? Needless to say, it's easy to miss this in a download with many rows and it can really foul up calculations if one does not notice and expand the invisible row.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-02-05 23:55:34 +0200

whbecker4799 gravatar image

updated 2017-02-09 21:22:46 +0200

Thanks for the link to the existing bug. I suspect that this is different, but I will investigate.

After investigation, determined that this is a problem with the formatting of the file. Strangely, the document opens with row 4 at a proper height in Office 2010, Google Docs, and DropBox. In contrast, row 4 shows up with a one-pixel height in Excel 2007, Calc, and with Microsoft's latest Excel viewer. In any event, it's not a problem with Calc.

edit flag offensive delete link more
0

answered 2017-02-05 22:55:27 +0200

m.a.riosv gravatar image

Looks like a possible duplicate of https://bugs.documentfoundation.org/s...

If you want report a new one http://www.libreoffice.org/get-help/f...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-05 22:38:02 +0200

Seen: 205 times

Last updated: Feb 09 '17