This code produces a workbook that can be successfully opened by both Excel
and OpenOffice Calc;
public static void main(String[] args) {
File file = null;
FileOutputStream fos = null;
Workbook workbook = null;
Sheet sheet1 = null;
Sheet sheet2 = null;
Have just checked with Excel and it does allow such formulae but with one
very interesting exception - when I wrote '+ c!$A$1' Excel insisted on
inserting inverted commas so that it became 'c'!$A$1 jus as if the sheet
name had an embedded space. Will try with POI this evening - assuming I do
not g
Hello Marc,
I have just had a look at the bug you linked to and wanted to say that is a
slightly different issue. There, the problem occurs trying to reference a
cell on a sheet within a different workbook, not on a sheet within the same
workbook.
Have you tried using either Excel of OpenOffice
