Bug 107552

Summary:	Data table is not shown in calc
Product:	LibreOffice	Reporter:	joni yang <kangjoni76>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv
Priority:	medium	Keywords:	filter:xlsx
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	the zip attachment file, please extract it firstly Default format cell is number rather than text while it's actual data is string

Description joni yang 2017-05-01 22:55:28 UTC

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.

Comment 1 joni yang 2017-05-01 22:57:37 UTC

Created attachment 132997 [details]
the zip attachment file, please extract it firstly

the zip attachment file, please extract it firstly

Comment 2 m_a_riosv 2017-05-02 01:00:32 UTC

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 ***

Comment 3 joni yang 2017-05-02 05:42:59 UTC Comment hidden (off-topic)

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?

Comment 4 joni yang 2017-05-02 05:45:34 UTC Comment hidden (off-topic)

The second attachment is an image that showing incorrect defaulting data types in libreoffice calc.

Comment 5 Justin L 2022-09-17 15:10:36 UTC

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 ***