Support named references

[Cafebabe]

Salut!

OpenOffice supports named references (http://plan-b-for-openoffice.org/
glossary/term/cell-reference-name).

Sad that jOpenDocument don’t support them and a call like

sheet.getCellAt( "addressline1" ).setValue( value );

just gives a (funny) exception.

Exception in thread "main" java.lang.IndexOutOfBoundsException: Index:
883191396, Size: 1024

Named references (like my addressline1) are a big advantage in
processing documents because absolute references are just clumsy.

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" Thanks
god we have range checks in Java :)

[Sylvain Cuaz]

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