ClosedXML Sort(3); does not work

[rogersbParticipant]

right… so deleting closedXML on nuget and re installing? I took the latest build. could be the problem

• This reply was modified 8 years, 9 months ago by  rogersb.

[Eric WhiteKeymaster]

Hi,

I have no experience about the closedXML library, although I have heard good things about it. Maybe someone else has an answer…

Cheers, Eric

[rogersbParticipant]

its so incredibly easy to make an Excel file, and it will accept the variables that come right out of the database

but I found out the indexing for the Sort() was 0th based not 1-based, so doing ws.Sort(5) had it sort on column F not column E; and col. F was just Y or N, so looking at the dates being out of order it seemed not to sort, plus its got colored rows that are mixed.

But it has another problem where it sorts good now using ws.Sort(4) gets sorting on col “E”

then it goes back and sorts col. 1 on those values splitting up the row data, which to me seems like its never supposed to do because now the row data is corrupt.

[Author]

Posts