Hi
I'm using XlsIO for 2 days and i was already capable to do some amazing things with it. Great component.
However I found some strange behavior ...or better say bug
I'm using XlsIO to generate workbook from hand crafted template file. In the sheet I have first few rows marked as "freezed panes". Same rows are configured as "print titles" in page setup. So they are always visible in Excel UI and on each printed page. As I understand it "print titles" is the same for printing as "freezed paines" for UI.
During my "templating" logic, there is some condition (data dependent) which can lead to deletion of some of these rows (using IWorksheet.DeleteRow()). Result of this operation is that "freezed panes" area is not shrinked so some rows from below "overflow" into it (and become freezed). On the other hand, "printed titles" area is shrinked accordingly. I don't like this inconsistency.
What is worst is that XlsIO is not consistent with Excel itself (tested with Excel 2013). If you remove\insert whole rows from\to freezed range (right clicking row number and choosing Delete\Insert from menu), freezed area is updated (shrinked or expanded) accordingly and consistently with "printed titles" area.
TL;DR: Freezed panes area should be shrinked\expanded when rows\columns are deleted from or inserted into it same way "printed titles" are (and the same way Excel itself works)
Michal
Fell fee to move the thread if its not in the right forum. I couldn't find forum dedicated to XlsIO...
