https://bugs.documentfoundation.org/show_bug.cgi?id=149185
Bug ID: 149185
Summary: Load CSV into LibreOffice Calc 6: TWO Strange
Anomalies
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LINUX (see systen info below)
=====
LibreOffice Calc
Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.1
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Blessings Team!
I am a public library support services volunteer and I just started working
with a nursing home. I am trying to copy a book list from my account on the
library web site into a spread sheet.
I did a 'cut & paste' of the desired information from the web page into an open
text file in "xed 3.0.2". I manually edited (search/cut/paste) the original
file to condense multi-line records to single-line records. As far as I can
tell, the fields in the file are TAB separated. I opened the CSV file in
LibreOffice 6 "Text Import" selecting only "Tab" and it does load, but with
**TWO** very strange anomalies:
1) Column A is INCREDIBLY wide! It reports a Column Width of 20.12, but it is
wider than my screen page. I have to set the Zoom % way down to see the entire
column. This may have something to do with ...
2) From the beginning of the file, 42 records load 4 columns as expected
(except for Column A width). HOWEVER - the last 3 records in their entirety
load into the single cell A43.
**EDIT:** I just noticed that there is a LEADING QUOTATION MARK - " - that
gets stripped off of the first character position of RECORD 43 and is evidently
somehow 'escaping' the entire rest of the file ???
When I look at the file in the 'xed' editor and select and copy any of the
"tab" (? multi-space, but not space characters) elements, and then paste the
copied element into the 'search' tool, I can see what appears to be 'tab'
characters throughout the file, in EVERY line of the file. Thus, I can't
understand either of the above anomalies.
SOURCE CSV file and ODS file
Thank you for any and all comments, suggestions, and assistance with this
issue.
Blessings in abundance,
Art in Carlisle, PA USA
=======================================================================================
System: ROM USB LiveMedia system
System: Host: mint Kernel: 5.4.0-74-generic x86_64 bits: 64 Desktop: MATE
1.24.0 Distro: Linux Mint 20.2 Uma
Machine: Type: Desktop System: Hewlett-Packard product: HP Compaq 6200 Pro MT
PC v: N/A
serial: <superuser/root required>
Mobo: Hewlett-Packard model: 1497 serial: <superuser/root required>
UEFI: Hewlett-Packard v: J01 v02.15
date: 11/10/2011
CPU: Topology: Quad Core model: Intel Core i5-2500 bits: 64 type: MCP L2
cache: 6144 KiB
Speed: 1596 MHz min/max: 1600/3700 MHz Core speeds (MHz): 1: 1596 2:
1596 3: 1596 4: 1596
Steps to Reproduce:
1. see description
2.
3.
Actual Results:
see description
Expected Results:
see description
Reproducible: Always
User Profile Reset: No
Additional Info:
I have 2 files, but can NOT figure out how to attach them ???
--
You are receiving this mail because:
You are the assignee for the bug.
