Hi,
I've a litte problem using the setFormula()-method.
See the following code:
import java.io.File;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.nio.file.*;
import org.jopendocument.dom.spreadsheet.MutableCell;
import org.jopendocument.dom.spreadsheet.SpreadSheet;
public class SheetTest {
private String path;
private File classlist;
public SheetTest(String path) {
this.path = path;
try {
// Save the data to an ODS file and open it.
this. classlist = new File(path);
SpreadSheet temp = SpreadSheet.createFromFile( classlist );
temp.getSheet(0).getCellAt(1, 1).setFormula("=IF(C8<8;5;9)");
temp.saveAs(new File(path));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
SheetTest sheettest = new SheetTest(
"path to the *.ods-file");
}
}
Everything works fine execpt the formula as it is written in small letters
"if" and not, as proposed, in capital IF.
The content of cell (1,1) is =if(C8<8;5;9) and OO 4.1 displays an error
"#name?"
This seems to be very strange as the "C8" is set correctly in capital
letters...
Any ideas?
--
---
You received this message because you are subscribed to the Google Groups
"jOpenDocument" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
