Bug 121027 - missing apostrophe in xlsx import
Summary: missing apostrophe in xlsx import
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: x86-64 (AMD64) All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2018-10-29 15:29 UTC by Elie Roux
Modified: 2024-03-28 16:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test file (working in Excel, no apostrophe in LO) (8.19 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-10-29 15:29 UTC, Elie Roux
Details
result in Excel after double clicking (50.22 KB, image/png)
2018-10-29 15:30 UTC, Elie Roux
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Elie Roux 2018-10-29 15:29:46 UTC
Created attachment 146142 [details]
test file (working in Excel, no apostrophe in LO)

The attached file displays an apostrophe as the first characters of the two cells in Excel, while the apostrophe disappears in LO. In Excel, a double click is required to see the apostrophe though, see attached screenshot.
Comment 1 Elie Roux 2018-10-29 15:30:48 UTC
Created attachment 146143 [details]
result in Excel after double clicking
Comment 2 raal 2018-10-29 22:15:15 UTC
Confirm with Version: 6.2.0.0.alpha1+
Build ID: a50f845957fff66ca7f459da4878be4597e0bae3
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: x11; and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

Cells are imported as Number type, not General
Comment 3 QA Administrators 2019-12-10 03:59:57 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2019-12-30 08:42:32 UTC
still repro in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 42a1a1c6b91907f81e15066ffab219411f18c4db
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 5 QA Administrators 2021-12-30 03:47:22 UTC Comment hidden (obsolete)
Comment 6 Timur 2024-03-28 14:03:38 UTC
Repro 24.8+. 
Issue is that General from MSO is imported as Number-General in LO. See no reason that this is a number.
Comment 7 ady 2024-03-28 16:53:03 UTC
(In reply to Timur from comment #6)
> Repro 24.8+. 
> Issue is that General from MSO is imported as Number-General in LO. See no
> reason that this is a number.

I don't understand what you mean. In 24.8 alpha, this is imported as General/Standard. What type of format would you have expected?

Additionally, the apostrophe is not relevant; it is not part of the content of the cell in this case – not in Calc, neither in Excel.

The len() of these cells will still be the same for Calc and for Excel (152 for A1, 31 for A2).

There is nothing to do here as of 24.8.