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 ???
Created attachment 180228 [details] Source Text File for CSV
Created attachment 180229 [details] ODS spread sheet created from "books.cvs" (not modified)
Hi Art, thanks for reporting this issue. As for problem (1), opening the CSV file in LibreOffice Calc 7.3 worked just fine and column width is as expected. In recent versions many improvements have been made to CSV file handling, so I recommend you update to the most recent version: https://www.libreoffice.org/download/download/ Moreover, beware that LO 6.4 has already reached end-of-life (see https://wiki.documentfoundation.org/ReleasePlan/6.4), so it won't be receiving any more fixes. Regarding problem (2) you just need to remove the text delimiter so that there is no character in that option. Simply click and delete it. This way the file opened fine for me, with all 45 rows. If you wish to attach another file to this bug report, just click "Add an attachment" after you finished reporting the bug. When you are creating the bug report you can only attach a single file. Subsequent files can be added after you published the bug report.
Blessings Rafael! Thank you for your most prompt and gracious response. I am mostly a very experienced "appliance user". Calc 6.4.7.2 is the default for the Linux Mint 20.2 Mate distro ISO file. It is the most recent STABLE version "deb" file that I have found so I can't upgrade. (?) I have only ever been successful with "dpkg -i" deb files for upgrades. I have just downloaded 7.2.7 (semi-stable?) and extracted the debs and did a "dpkg" on it. The process didn't complain about it but it evidently didn't prep any of the 'triggers' and so when I open loCalc from the menu it only loads the OLD version, not the new version ??? That's about as far as I am able to go. Blessings in abundance, Art in Carlisle, PA USA (In reply to Rafael Lima from comment #3) > Hi Art, thanks for reporting this issue. > > As for problem (1), opening the CSV file in LibreOffice Calc 7.3 worked just > fine and column width is as expected. In recent versions many improvements > have been made to CSV file handling, so I recommend you update to the most > recent version: > > https://www.libreoffice.org/download/download/ > > ...
Blessings Art Report is not clear. It needs simple repro steps like: open CSV attachment 180228 [details] which has (what?) as a separator see that... I expect... When I open CSV as text in text editor like Gedit or Xed, I see no separator nor this looks like CSV. As for upgrade, easiest is to add PPA and then just update: sudo add-apt-repository ppa:libreoffice/libreoffice-still 7.2.7 is as stable as it can be, called Still, and I put that in PPA so that you only have stable versions.
Note: Rafael gave some specific advice, please write a single issue if something remains now.
(In reply to Timur from comment #5) > When I open CSV as text in text editor like Gedit or Xed, I see no separator > nor this looks like CSV. This is actually a simple text file that uses Tabs as field separators. This happens when you copy and paste tables from web pages. Despite that, LO handle this file properly given the correct delimiter settings. IMO the original complaint by the user (the excessive width of the column after import) has been fixed after 6.4, so I guess this is WFM.
Right, thanks. Problem was there in 6.4.7 but resolved during LO development in LO 7.3. So I close the bug as WorksForMe which is a proper status per https://bugs.documentfoundation.org/page.cgi?id=fields.html#bug_status. Unfortunately, LO 7.2.7 has the problem and 7.2 will not get further fixes. If you use sudo add-apt-repository ppa:libreoffice/libreoffice-still you will get 7.2.7 now and 7.3.7 with the fix sometimes in the winter.