Bug 158403 - Generated document not showing correctly values in LibreOffice Calc
Summary: Generated document not showing correctly values in LibreOffice Calc
Status: REOPENED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency tree / graph
 
Reported: 2023-11-27 15:37 UTC by itc_it
Modified: 2023-11-29 19:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Generated .xlsx (35.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-11-27 15:40 UTC, itc_it 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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