Based on Yegor Kozlov BigGridDemo I made some changes for my own needs but
I'm having trouble writing formulas.
Actually I created this method:
public void createFormula(int columnIndex, String formula, int styleIndex)
throws IOException {
String ref = new CellReference(_rownum,
columnIndex).formatAsString();
_out.write("<c r=\""+ref+"\" t=\"n\"");
if(styleIndex != -1) _out.write(" s=\""+styleIndex+"\"");
_out.write("><f>"+formula+"</f><v>0</v></c>");
}
The formula gets written into the xlsx file but it is not evaluated.
I have to press Ctrl+Alt+Shift+F9 in MS Excel in order to evaluate all the
formulas.
What can be done to MS Excel evaluate the formulas when it opens the sheet?
Do you have any ideas?
Is there any effort for creating a solution for those Big Grids? Let me know
if I can help on that.
Thanks.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Big-Grid-writing-formulas-tp3242446p3242446.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
