Dimension loses column characters. Does not retain spreadsheet dimension information (column characters) after: -reading in excel produced .xlsx -deleting the first sheet -saving as .xlsx again Trying to read in with in2csv the LibreOFfice (LO) .xlsx output is fine, even after making various edits. Data from the first sheet shows: tag: {http://schemas.openxmlformats.org/spreadsheetml/2006/main}dimension dim: A1:AA2033 After deleting the first sheet and saving to .xlsx format from LO, the new first sheet dimension loses the column specification(numbers are right for the sheet): tag: {http://schemas.openxmlformats.org/spreadsheetml/2006/main}dimension dim: 1:8578 If the new first sheet is modified by inserting a first column and deleting it, the save to .xlsx then includes the column letters. When doing the same thing using just excel, the column letters are not lost when a different sheet moves to the first position. On OSX 10.9, LibreOffice 4.4.2.2
Please attach an example .xlsx produced by Excel (which version?). Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 115635 [details] excel data file to test using : in2csv --sheet Sheet2 works with given file. open LO, delete first column, save, run in2csv and the dimension loses the column letters (being reported by print tracing in openpyxl-2.2.0_b1-py2.7.egg/openpyxl/worksheet/iter_worksheet.py before line 37 I have also found the same problem when deleting last rows of sheets but this simple column removal is easily reproduced. Excel file is from OSX, MS Office 2011 version: 14.4.9 (150325)
I tried to install csvkit on Ubuntu 15.04 using these instructions, but none of the commands (like in2csv) run after an otherwise successful install (tried installing several times) : https://csvkit.readthedocs.org/en/0.9.1/install.html We have to find someone, who can install csvkit or ping the csvkit devs to confirm this.
I was informed that this is a duplicate of a known bug, but I could not locate an existing bug. In any case, we can forget about csvkit for now.
don't need in2csv, it was just the tool being used that brought this to light. If you perform the same 'delete first sheet and save' action, and then unzip the file, you will see that Sheet1.xml's contents includes the line with the missing columuun identifies: <dimension ref="1:16"/> I aslo could not find a similar bug. If you find out which bug this is a duplicate of, let me know and I will zoom in on the bug thread.
Created attachment 116502 [details] Execution of in2csv before column removal
Created attachment 116503 [details] Execution of in2csv after column removal Following instructions to install csvkit on Debian Jessie 8 as root: apt-get install python3-pip pip3 install csvkit And executing (not as root) before and after first column removal (Mount) through LibO: in2csv --sheet Sheet2 test3.xlsx Please note that the attached file is "test3.xlsx-3" and you have to rename it to "test3.xlsx" I'm not sure if this dumps from "in2csv" are as expected. I can see some different way to show the data (despite of the column removal). In that case, I can confirm this bug on: Versión: 4.3.7.2 Id. de compilación: 8a35821d8636a03b8bf4e15b48f59794652c68ba Versión: 4.4.3.2 Id. de compilación: 88805f81e9fe61362df02b9941de8e38a9b5fd16 Configuración regional: es_ES Version: 4.4.5.0.0+ Build ID: e37cf07d5fc9aaa7143cb98a71ee3c2662cfc263 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-06-12_11:50:46 Locale: es_ES.UTF-8 Version: 5.0.0.0.beta3+ Build ID: c9be3ebba438d202906ddb9da05a27a7fb5c1ab6 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-5-0, Time: 2015-06-12_23:27:58 Locale: es-ES (es_ES.UTF-8) Version: 5.1.0.0.alpha1+ Build ID: a9286c302e96258f32d13fb66aced25750e82cd3 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-06-13_00:03:04 Locale: es-ES (es_ES.UTF-8)
Daniel: can you comment on Carlos's findings? You can set this to NEW, if they match your issue.
>I'm not sure if this dumps from "in2csv" are as expected. I can see some >different way to show the data (despite of the column removal). In that case, I >can confirm this bug on: It appears that Carlos has verified the bug. Setting to new as requested. Note that in2csv is not needed as mentioned in Comment 5.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
as requested by the old bug checking notification, tested with LibreOffice 5.2.1.2 OSX 10.10.5 Did the simple ';comment 5' test and it no longer exjoibits a problem.
Thanks. Setting to WFM.