On 10/29/2010 9:39 PM, dmouraneto wrote:
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.
Can you create two files, one using BigGrid and the other in Excel and diff them? This should help you to figure out the missing xml bits.
org.apache.poi.xssf.dev.XSSFDump can be of help, it dumps the contents of a .xlsx file into file system and formats xml into human-readable form.
Yegor --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
