fastexcel icon indicating copy to clipboard operation
fastexcel copied to clipboard

Fixing row and column tracking when there are blank cells

Open lsergio opened this issue 3 weeks ago • 1 comments

Fixed cell row and column index tracking when there are blank cells at the beginning of the row, like:

<row>
			<c r="B2" t="s">
				<v>136316</v>
			</c>
			<c t="s">
				<v>136317</v>
			</c>
			<c t="b">
				<v>1</v>
			</c>
			<c t="b">
				<v>1</v>
			</c>
			<c t="s">
				<v>136318</v>
			</c>
			<c t="s">
				<v>265</v>
			</c>
			<c t="s">
				<v>136319</v>
			</c>
			<c r="J2" s="2">
				<v>45411.095648645831</v>
			</c>
		</row>

The A2 cells is blank the the lib loses track of the indexes.

lsergio avatar Dec 03 '25 19:12 lsergio

Thank you! Could you add a test that would verify the fix (that is it would fail before your changes)?

rzymek avatar Dec 04 '25 10:12 rzymek

Thank you! Could you add a test that would verify the fix (that is it would fail before your changes)?

I added a new test case for the RowSpliterator class. I could not create a test that processes the spreadsheet where I found the issue because it contains customer sensitive data, and I didn't manage to create another one - in all my attempts all cells had explicit addresses in the xml content.

lsergio avatar Dec 18 '25 18:12 lsergio