Hello there
I'm wondering whether there has been a decision in OpenOffice v3.xx to
remove support for the R1C1 formula schema in spreadsheets? Two
observations that prompt this question:
i) in v3.xx, the Format::Sheet::Use R1C1 option has been removed (I
notice that the Novell oo-build project has re-implemented this
globally in the OpenOffice Calc::Calculate prefs pane in their
OpenOffice v3.xx builds)
ii) in v3.xx, the MS Excel 03 XML import/export functionality has been
broken (it worked beautifully in v2.xx). When you choose that save-as
option, OpenOffice now exports using its own ODFF [.a1] schema instead
of the R1C1 schema that Excel XML requires, making it unreadable in
Excel (and other apps that support that doctype). And as of v3.xx,
Excel 03 XML docs do not import properly into Calc if they contain
cell references in their formulae.
Does anyone know the reason for the changes here? Will R1C1/XML
support be returning to OpenOffice?
- Padmavyuha
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
