Created attachment 95072 [details] Example file obtained by following the steps Problem description: Sometimes when I delete one or more columns in a spreadsheet, LO adds blank cells at the end (near column number 1024) This is happening when editing xlsx files, but it may not be limited to this format. I first noticed the problem with the 4.1.3.2 version, and the same thing is happening in 4.1.4.2 Steps to reproduce: 1. Create a new spreadsheet, and type something in cell A1 (such as "hi") 2. Select row 1, and change the formatting (e.g. font size) 3. Delete column B (select column, right-click, delete selected) 4. Save as xlsx 5. Check the number of cells in the first row (I used Apache POI) Current behavior: Two cells are found - 0 and 1023 (counting cells from 0). Cell 1023 (corresponding to AMJ1) is blank. If you deleted columns B and C, then cells 1022 and 1023 would be blank. Expected behavior: Only one cell should be found (A1) Operating System: Linux (Other) Version: 4.1.3.2 release
I did the following test with your file under LibreOffice 4.2.5.0.0+ : 1/ select cell A1 2/ hit the End key -> nothing happens 3/ select cell C1 4/ hit the End key -> cell A1 is selected. 5/ right click on the header of column C, then choose delete selected column 6/ select cell E1 4/ hit the End key -> cell A1 is selected. Where is the bug ? If Apache POI says something unexpected, perhaps the problem is in Apache POI. Best regards. JBF
LibreOffice may not jump to the last blank cell when pressing End, but if you extract the file (as a zip archive) and open xl/worksheets/sheet1.xml, you can find this row definition: <row collapsed="false" customFormat="true" customHeight="false" hidden="false" ht="14.5" outlineLevel="0" r="1" s="1"><c r="A1" s="1" t="s"><v>0</v></c><c r="AMJ1" s="0"/></row> The AMJ1 cell should not be there. One way to notice the problem in LibreOffice itself is to check the formatting. At least on my computer, the AMJ1 cell has font size 10 but all the other cells on row 1 have font size 12. After deleting column B, both AMI1 and AMJ1 have font size 10 (and previous cells have font size 12).
NEW is incorrect as it's not confirmed by an independent triagers. Marking as UNCONFIRMED
I just did a test with master and no problem, below is my xml output: <worksheet><sheetPr filterMode="false"><tabColor rgb="00FFFFFF"/><pageSetUpPr fitToPage="false"/></sheetPr><dimension ref="A1"/><sheetViews><sheetView windowProtection="false" showFormulas="false" showGridLines="true" showRowColHeaders="true" showZeros="true" rightToLeft="false" tabSelected="true" showOutlineSymbols="true" defaultGridColor="true" view="normal" topLeftCell="A1" colorId="64" zoomScale="100" zoomScaleNormal="100" zoomScalePageLayoutView="100" workbookViewId="0"><selection pane="topLeft" activeCell="B1" activeCellId="0" sqref="B1"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="12.8"/><cols><col collapsed="false" hidden="false" max="1025" min="1" style="0" width="11.5204081632653"/></cols><sheetData><row r="1" customFormat="false" ht="12.8" hidden="false" customHeight="false" outlineLevel="0" collapsed="false"><c r="A1" s="0" t="s"><v>0</v></c></row></sheetData><printOptions headings="false" gridLines="false" gridLinesSet="true" horizontalCentered="false" verticalCentered="false"/><pageMargins left="0.7875" right="0.7875" top="1.05277777777778" bottom="1.05277777777778" header="0.7875" footer="0.7875"/><pageSetup paperSize="1" scale="100" firstPageNumber="1" fitToWidth="1" fitToHeight="1" pageOrder="downThenOver" orientation="portrait" usePrinterDefaults="false" blackAndWhite="false" draft="false" cellComments="none" useFirstPageNumber="true" horizontalDpi="300" verticalDpi="300" copies="1"/><headerFooter differentFirst="false" differentOddEven="false"><oddHeader>&C&"Times New Roman,Regular"&12&A</oddHeader><oddFooter>&C&"Times New Roman,Regular"&12Page &P</oddFooter></headerFooter></worksheet> I don't see any reference to another cell other than A1. Attached is my xlsx file. Marking as WFM - to test against master you can get a daily build here: http://dev-builds.libreoffice.org/daily/master/ If you reproduce with daily build please try with a fresh profile. If you still experience the problem mark the bug as UNCONFIRMED (NOT NEW) Thanks
Created attachment 98305 [details] 4.3 XLXS working file
Hi again, I just reproduced the bug using LO Version: 4.3.5.2.0+ (Build ID: Gentoo official package)
Aaand... I reproduced it with a fresh profile too.
I also made a screen recording: http://youtu.be/SzJSOmLyh1I
Please do not change the version number which shows the oldest version in which the has been observed. Before reopening, please test with the most recent version. This bug report has been marked resolved because it works as expected with the current master. Set back to WorksForMe. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #9) > Please do not change the version number Ok > Before reopening, please test with the most recent version. I tested with the most recent version I got. I spent enough time on this, I'm not going to install unreleased development versions too. > This bug report > has been marked resolved because it works as expected with the current > master. False. It has been marked resolved because you failed to reproduce it with the "master" as of 2014-05-01. I'm pretty sure 4.3.5.2 is newer than that, and I also suspect you didn't follow the steps correctly.
Please stop messing with the status without following instructions. Test against 4.4.1.2 or newer. Closing again as WFM - please do not reopen until you have tested against 4.4.1.2 or newer. This is not a developer version - it is the latest released version.