Download it now!
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)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2018-10-29 15:29 UTC by Elie Roux
Modified: 2019-12-30 08:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

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
result in Excel after double clicking (50.22 KB, image/png)
2018-10-29 15:30 UTC, Elie Roux

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:
Build ID: a50f845957fff66ca7f459da4878be4597e0bae3
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: x11; and Version (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: (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