Parsing of rich text inside inline string fails

[1omg]

Hello. Try to read xlsx file, problem with multiline cell. My code:

            var workbook = new XLWorkbook(path);
            var ws1 = workbook.Worksheet(3);
            workbook.SaveAs("tmp.xlsx");
            
            int rowCount = 20; //example
            //first row headers
            for(int i = 1 ;i<rowCount;i++)
            {
                var row = ws1.Row(i);
                IXLCell cell = row.Cell("E");     //.Cell(5); 
                bool isEmpty = cell.IsEmpty();      //always empty on this column, but in original have 6 lines
                var val = cell.Value;   //cell.
                //vals += val + Environment.NewLine;
            }

Values at file:

If i open workbook and resave it from code (.SaveAs) - values not lost. But in code (.Value , .GetString etc) it seens like empty cell.
What i do wrong?

[igitur]

Would you mind attaching the workbook?

[1omg]

tmp.xlsx
3rd worksheet / column E

[igitur]

I see there is a bug in ClosedXML. Your workbook contains a rare combination of rich text inside an inline string. The normal way to save an Excel file is to use shared strings. I will add a fix.

But how are you generating this workbook? Is it also programmatically?

[1omg]

Workbook generating on external services, cant change it.
When i can wait a fix? Or what I can do to fix it?

[igitur]

You can check my PR in #97 for the fix.

[1omg]

Thank you so much! I will try in the evening.