I have a file, see attachment. Its CSV representation is: "15.06.2020";"QWERTYUIOPQWERTYUIOP";;"ASDFGHJKLASDFGHJKLASDFGHJKL" I see two display artifacts: 1) unknown single quote symbol in the cell (see first screenshot); 2) the contents of cells are displayed on top of each other (see second screenshot) Is it intended behavior? Thanks!
Created attachment 162211 [details] Original file
Created attachment 162212 [details] CSV representation
Created attachment 162213 [details] First screenshot 1) unknown single quote symbol in the cell (see first screenshot)
Created attachment 162214 [details] Second screenshot 2) the contents of cells are displayed on top of each other (see second screenshot)
Thank you for reporting the bug. I can confirm the bug present in Version: 6.4.0.0.alpha1+ (x86) Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30 Locale: en-US (en_US); UI-Language: en-US Calc: threaded and in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Created attachment 162220 [details] Import window configuration screenshot. Not a bug, it's only a matter of a proper import configuration. See attached screenshot.
(In reply to m.a.riosv from comment #6) > Created attachment 162220 [details] > Import window configuration screenshot. > > Not a bug, it's only a matter of a proper import configuration. > See attached screenshot. I didn't import it. The XLSX file is original. I show you CSV representation for understanding it's real content.
The single quote tic just shows the numerical cell value is being handled as text on import. And, that is the way to enter numerical data as text via the Formula bar. Without the original OOXML document to judge its column formatting the filter import of the sheet is not incorrect. And as noted, the CSV import filters would need to match if you had exported the OOXML to CSV with semicolon column separators and quote mark text delimiter.
(In reply to V Stuart Foote from comment #8) > The single quote tic just shows the numerical cell value is being handled as > text on import. And, that is the way to enter numerical data as text via the > Formula bar. > > Without the original OOXML document to judge its column formatting the > filter import of the sheet is not incorrect. > > And as noted, the CSV import filters would need to match if you had exported > the OOXML to CSV with semicolon column separators and quote mark text > delimiter. Thanks! > Without the original OOXML document to judge its column formatting the > filter import of the sheet is not incorrect. Do you mean, XLSX saved my Microsoft Excel not LibreOffice? And am I correct that you talk about the second issue, too?