Cafebabe a écrit :
Salut!
Salut,
OpenOffice supports named references (http://plan-b-for-openoffice.org/ glossary/term/cell-reference-name). Sad that jOpenDocument don’t support them
It does in Spreadsheet (since a named cell can be in any sheet) but only for getting the value : public Object getValueAt(String ref)
We will add a method like getCellAt(String ref) in the next version
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 883191396, Size: 1024 And if the value is "out of range" maybe not to throw an IndexOutOfBoundsException but an IllegalArgumentException with a message like: "Named references are not supported right now"
Actually it does, it checks if the string conforms to ([\p{Alpha}]+)([\p{Digit}]+) Sadly "addressline1" does :-)
Cheers, Sylvain
