On 8 Apr 2009, at 10:55, Niklas Nebel 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.
My apologies - I was looking at the 2.xx and 3.xx Novell oo-build
versions (instead of the official build), which do have R1C1 user
choice implemented already.
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.
96018 was mine. I now note that in the interim between me posting that
issue and the release of 3.0.1, the issue I was seeing has been
resolved, though there's no mention of that in the issue itself. Now,
regardless of whether 1.0/1.1 or 1.2 ODF is selected in Load/
Save::General, the XML exports/imports correctly - though using ODF
1.2 results in a Table error on import into MS Excel, the formulae
still appear correctly in the opened doc. I have updated 96018
accordingly.
- padmavyuha
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
