The following attachment contain several files 1. data_not_shown1.png is a screenshot to show the problem. You can see there that the Cluster column data is not shown but this case is not a problem for ms excel 2007. 2. shown_in_excel.png is a screenshot to show the problem on ms excel 2007. This does properly showing all cluster datas column. 3. export_data__020517053412197.xlsx is a file that to reproduce the bug. you can compare the result between libreoffice 5 and ms excel 2007. 4. libreversion.png is a screenshot that showing the complete libreoffice version number I hope this could make any clearance in my bug report. thank you.
Created attachment 132997 [details] the zip attachment file, please extract it firstly the zip attachment file, please extract it firstly
Seems an issue with the automatic row heigh with some xls files. You can select the whole sheet, righ-click on a row number and apply Optimal height. *** This bug has been marked as a duplicate of bug 32950 ***
Created attachment 133000 [details] Default format cell is number rather than text while it's actual data is string Thanks for the fast response, but I think this is libreoffice calc bug. If I right click and choose format cells, it does defaulting to number type instead of text. But if I change to text format then all data is properly shown. Why didnt libreoffice think this type of string as text rather than detect as number format?
The second attachment is an image that showing incorrect defaulting data types in libreoffice calc.
This is an XLSX document - assign as duplicate to XLSX version instead of XLS version of the bug. *** This bug has been marked as a duplicate of bug 123026 ***