Hi Regina, On Thursday, 2010-06-03 16:56:56 +0200, Regina Henschel wrote:
>> I have now changed the entries to the form, for example
>> { "IMCOT", "IMCOT", false, "IMCOT", "IMCOT" },
>>
>> Now I can use setting "ODF 1.2" or "ODF 1.0/1.1", file format ods, sxc,
>> or sdc, reopen directly or round trip through SO8 with keeping file
>> format. All cases work well. So I thing, that the OOo import/export part
>> is solved.
>
> I have to take back the "solved". In the file format the attribute then is
> table:formula="of:=COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT(z)"
> but it should be
> table:formula="of:=IMCOT(z)"
> because IMCOT is defined in ODFF. So Gnumeric cannot open the file
> correctly although Gnumeric knows the function IMCOT.
>
> Using in odffmap.cxx the entry
> { "IMCOT", "IMCOT", false,
> "com.sun.star.sheet.addin.Analysis.getImcot",
> "COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT" },
> results in the correct attribute in the file.
Thanks for clarifying, I already started to wonder ;-)
> That the round trip though OOo2.4.3 does not work for sxc file format
> can be solved be forcing OOo3 to setting "ODF 1.0/1.1" when saving in
> sxc, as already suggested in issue 95312. So the remaining problem would
> be the round trip of an ods document produced with "ODF 1.2" setting. Do
> you can give me a hint, how I can tell OOo3 to translate
> "oooc:=IMCOT(z)" to a valid function call when opening such document
> coming from OOo2.4.3? Or do you know a way to get the correct attribute
> in the file format, when using the "IMCOT" entry in odffmap.cxx?
Off-head, as pre-3.0 doesn't implement that function and the (upper)
programmatical name is not expected to be encountered in documents
originating from ODF 1.1 and earlier, does
{ "IMCOT", "IMCOT", false, "com.sun.star.sheet.addin.Analysis.getImcot",
"IMCOT" },
already help?
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
Please don't send personal mail to the [email protected] account, which I use for
mailing lists only and don't read from outside Sun. Use [email protected] Thanks.
pgpWQwGdJn7RK.pgp
Description: PGP signature
