On 04/08/09 09:21 AM, Padmavyuha wrote:
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)
It's not deprecated, it's just not finished (issue 72191), and that
option has never been in the builds from download.openoffice.org.
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.
That's a different problem, see issues 94261 and 96018.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
