Ask Your Question
0

Missing Row in XLSX Spreadsheet [closed]

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

whbecker4799 gravatar image

updated 2020-09-24 12:40:54 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-24 12:42:06.406481

2 Answers

Sort by » oldest newest most voted
0

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

whbecker4799 gravatar image

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

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 +0100

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

Question Tools

1 follower

Stats

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

Seen: 370 times

Last updated: Feb 09 '17