Formulas broken

[AndreiCherniaev]

example generates file demo1.xlsx with formula, but formula doesn't work:

How fix? In LibreOffice Calc I should replace = to = (yes, the same symbol) and press Enter...

Formula feature in QXlsx totally broken?

I use last git QXlsx version 11bafef, Qt 6.8, GCC 13

[AndreiCherniaev]

I found where the formula feature in QXlsx is broken and where it can works. If you use CellFormula::NormalType then the formula feature is broken (Recalculate Hard need), but if you use CellFormula::SharedType then the formula feature works...

int A2= 1;
int B2= 3;
xlsxW.write(2, 1, A2);
xlsxW.write(2, 2, B2);
sheet->writeFormula("E2", CellFormula("A2+B2")); //problem because of not CellFormula::SharedType
//sheet->writeFormula("E2", CellFormula("A2+B2", "E2", CellFormula::SharedType)); //but this will work
xlsxW.save();