Page 1 of 1

In Row (sheet.xml) can F24 appear before B24.

PostPosted: Mon Nov 18, 2019 2:06 am
by ashanaik
In Row (sheet.xml) can F24 appear before B24.

My Excel is getting corrupted. Is this the reason?

<row r="24" ht="14.88188976377953" customHeight="true">
<c r="F24" s="3" t="s">
<v>1</v>
</c>
<c r="B24" s="1" t="s">
<v>2</v>
</c>
</row>

Re: In Row (sheet.xml) can F24 appear before B24.

PostPosted: Wed Dec 04, 2019 5:13 pm
by ashanaik
Fixed the issue.

Rows and columns must always be sorted.
Using comparator sort methods :
.getRow().sort();
row.getC().sort();