Bug 158403

Summary: Generated document not showing correctly values in LibreOffice Calc
Product: LibreOffice Reporter: itc_it
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: REOPENED ---    
Severity: enhancement CC: buzea.bogdan, itc_it
Priority: medium    
Version: 7.6.2.1 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108252    
Attachments: Generated .xlsx

Description itc_it 2023-11-27 15:37:15 UTC 
Description:
When I generate a .xlsx report in an online platform and open with LibreOffice Calc all the fields where should I see values are 0, the cells dont have formulas only values. If I open with Office Excel the document has values. If I upload it to Google Drive and open it I see the values. If I continue to edit in Drive just one field and download it, LibreOffice shows the cells populated with values.

Considering that its hard to reproduce because the platform is private I can share a generated .xlsx document or any other info.

Thank you

Steps to Reproduce:
1. .xlsx report generated on fleet.trackgps.ro
2. When open the .xlsx file doesn't show correct values, it shows 0 on each cell where a value should be.
3. 

Actual Results:
Cells populated with 0

Expected Results:
Cells populated with values.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: CL threaded
Comment 1 itc_it 2023-11-27 15:40:48 UTC 
Created attachment 191064 [details]
Generated .xlsx
Comment 2 Eike Rathke 2023-11-27 16:30:36 UTC 
It would help to generate _correct_ numeric values as cell content..
The document contains loads of value cells like

      <c r="b18" s="16">
        <v>1
                            </v>
      </c>

i.e. with line feed followed by a bunch of blanks. That should be

      <c r="b18" s="16">
        <v>1</v>
      </c>

instead. Get that generator to produce valid documents.
Comment 3 Eike Rathke 2023-11-27 18:03:07 UTC 
It's even worse.. the actual content is

<c r="b18" s="16"><v>
                                1
                            </v>
</c>

so line feed, blanks, number, line feed, blanks.
Comment 4 itc_it 2023-11-28 09:02:43 UTC 
I don't have access to that function that generates the document. I know its not a bug but its a limitation, considering that Office Excel and Google Drive open the document without a problem. Can it be included in future updates as a enhancement.

Thank you