ClosedXML Sort(3); does not work

Home › Forums › Open-Xml-Sdk › ClosedXML Sort(3); does not work

Tagged: 

This topic contains 3 replies, has 2 voices, and was last updated by  rogersb 8 years, 9 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 14, 2016 at 7:39 pm #3786

    rogersb
    Participant

    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.
    September 15, 2016 at 12:01 pm #3791

    Eric White
    Keymaster

    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

    September 15, 2016 at 2:17 pm #3795

    rogersb
    Participant

    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
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.