Hi Regina,
On Thursday, 2010-06-17 01:11:40 +0200, Regina Henschel wrote:
>> { "IMCOT", "IMCOT", false, "com.sun.star.sheet.addin.Analysis.getImcot",
>> "IMCOT" }
>>
> The round trip ODF1.2 -> OOo2.4.3 -> ODF1.2 for sxc file format is OK
> with that setting, but now sxc files fail both for reop
Hi Eike,
Regina Henschel schrieb:
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
That's odd. I'd have to take a deeper look at that. I expected that with
{ "IMCOT", "IMCOT", false,
"com.sun.star.sheet.addin.Analysis.getImcot", "IMCOT" },
the last IMCOT would had setup the map for FormulaGrammar:
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
That's odd. I'd have to take a deeper look at that. I expected that with
{ "IMCOT", "IMCOT", false, "com.sun.star.sheet.addin.Analysis.getImcot",
"IMCOT" },
the last IMCOT would had setup the map for FormulaGrammar::GRAM_PODF to
be used in 'oooc:' na
Hi Regina,
On Thursday, 2010-06-10 00:25:00 +0200, Regina Henschel wrote:
> I have now looked at ScCompiler::IsOpCode. You have added a comment
> (line 2520)
> // If that isn't found we might continue with rName lookup as a
> // last resort by just falling through to FindFunction(), but
> // it
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Thursday, 2010-06-03 16:56:56 +0200, Regina Henschel wrote:
[..]
Using in odffmap.cxx the entry
{ "IMCOT", "IMCOT", false,
"com.sun.star.sheet.addin.Analysis.getImcot",
"COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT" },
re
Hi,
Regina Henschel schrieb:
I have now used in analysis_deffuncnames.src an entry:
StringArray ANALYSIS_DEFFUNCNAME_Imcot
{
ItemList =
{
< "_xlfnodf.IMCOT"; >;
< "_xlfnodf.IMCOT"; >;
};
};
And for comparison an entry
StringArray A
Hi Daniel,
Daniel Rentz schrieb:
Hi Regina,
Regina Henschel schrieb:
If I use ocExternal the prefix is set, but the functions are not
distinct, only one name is written and on import the whole function
name is stripped, so only =(z) remains from =_xlfnodf.IMSECH(z).
I see no way to add the i
Hi Eike,
same additional information:
I use the odffmap entry
{ "IMCOT", "IMCOT", false,
"com.sun.star.sheet.addin.Analysis.getImcot",
"COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT" }
(1) Save document in setting "ODF 1.2".
(2) Open it in OOo2.4.3 and save there. That results in document v
Hi Eike,
Eike Rathke schrieb:
[..]
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
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
Hi Eike,
Regina Henschel schrieb:
HI Eike,
Regina Henschel schrieb:
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
HI Eike,
Regina Henschel schrieb:
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Sunday, 2010-05-30 22:44:06 +0200, Regina Henschel wrote:
In the cases
'ODF 1.0' with ods and
'ODF 1.2 extended' with sxc and ods,
the new functions are reloaded with #NAME?, but the cells contain the
formulas lik
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Sunday, 2010-05-30 22:44:06 +0200, Regina Henschel wrote:
In the cases
'ODF 1.0' with ods and
'ODF 1.2 extended' with sxc and ods,
the new functions are reloaded with #NAME?, but the cells contain the
formulas like '=imsech(z)'.
In contrast to i
Hi Regina,
On Sunday, 2010-05-30 22:44:06 +0200, Regina Henschel wrote:
> In the cases
> 'ODF 1.0' with ods and
> 'ODF 1.2 extended' with sxc and ods,
> the new functions are reloaded with #NAME?, but the cells contain the
> formulas like '=imsech(z)'.
> In contrast to issue 95312 the old ima
Hi Regina,
Regina Henschel schrieb:
If I use ocExternal the prefix is set, but the functions are not
distinct, only one name is written and on import the whole function name
is stripped, so only =(z) remains from =_xlfnodf.IMSECH(z).
I see no way to add the imaginary functions to list saFunc
Hi Daniel,
Regina Henschel schrieb:
== B ==
But I have still questions concerning the new imaginary functions.
Those functions have no op-code. Need I to add them to
saFuncTable_Odf? If yes, how can I do it?
Yes, the filters in sc are used for import/export of the XLS format. On
export, the
Hallo Daniel,
Daniel Rentz schrieb:
Hello,
Regina Henschel schrieb:
== A ==
I have added SEC, CSC, SECH, and CSCH, to saFuncTable_Odf. All four
new functions have op-codes. Tests look good:
Reloading directly is correct for ods, xls, sdc, and sxc.
Loading and resaving with StarOffice8 (for
Hello,
Regina Henschel schrieb:
Daniel Rentz schrieb:
Right, fix has been integrated into m77
http://qa.openoffice.org/issues/show_bug.cgi?id=79854
Now I have a build based on m78. I made some import/export tests.
Excel2003 xml is totally broken (issue 94261) and not mentioned below.
Ye
Hi all,
Daniel Rentz schrieb:
Regina Henschel schrieb:
Hi Daniel,
Daniel Rentz schrieb:
Same for the equivalent table "saFuncTable_Odf" in
sc/source/filter/excel/xlformula.cxx.
It seems, that I have to wait till m78, because m76 does not contain
saFuncTable_Odf and m77 does not build for
On 05/17/10 00:21, Regina Henschel wrote:
When reloading into my patched DEV300m76 I get this up to now, without
any entry in the files formulabase.cxx:
save in .sxc: All addin functions, including the existing ones, result
in #Name?, but the cell content contains the correct formula.
That p
On 05/16/10 21:31, Regina Henschel wrote:
Daniel Rentz schrieb:
scadddins/analysis should contain only these functions that Excel offers
in its Analysis add-in. New functions should go into the Calc core IMHO.
(Anyway, starting from Excel 2007, all Analysis functions are built-in
in Excel.) I'm
Regina Henschel schrieb:
Hi Daniel,
Daniel Rentz schrieb:
Same for the equivalent table "saFuncTable_Odf" in
sc/source/filter/excel/xlformula.cxx.
It seems, that I have to wait till m78, because m76 does not contain
saFuncTable_Odf and m77 does not build for me.
Right, fix has been integ
Hi Daniel,
Daniel Rentz schrieb:
Same for the equivalent table "saFuncTable_Odf" in
sc/source/filter/excel/xlformula.cxx.
It seems, that I have to wait till m78, because m76 does not contain
saFuncTable_Odf and m77 does not build for me.
kind regards
Regina
--
Hi Daniel,
Daniel Rentz schrieb:
Regina Henschel schrieb:
Hi Daniel,
Daniel Rentz schrieb:
Hi regina,
Regina Henschel schrieb:
the file oox/source/xls/formulabase.cxx has a section /** Functions
defined by OpenFormula, but not supported by Calc or by Excel. */
Does this refer to the draft
Hi Daniel,
Daniel Rentz schrieb:
scadddins/analysis should contain only these functions that Excel offers
in its Analysis add-in. New functions should go into the Calc core IMHO.
(Anyway, starting from Excel 2007, all Analysis functions are built-in
in Excel.) I'm not sure if the filters are p
Regina Henschel schrieb:
Hi Daniel,
Daniel Rentz schrieb:
Hi regina,
Regina Henschel schrieb:
the file oox/source/xls/formulabase.cxx has a section /** Functions
defined by OpenFormula, but not supported by Calc or by Excel. */
Does this refer to the draft ODF 1.2 formula spec?
No. I just
Hi Daniel,
Daniel Rentz schrieb:
Hi regina,
Regina Henschel schrieb:
the file oox/source/xls/formulabase.cxx has a section /** Functions
defined by OpenFormula, but not supported by Calc or by Excel. */
Does this refer to the draft ODF 1.2 formula spec?
No. I just scanned the function op-c
Hi regina,
Regina Henschel schrieb:
the file oox/source/xls/formulabase.cxx has a section /** Functions
defined by OpenFormula, but not supported by Calc or by Excel. */
Does this refer to the draft ODF 1.2 formula spec?
No. I just scanned the function op-codes defined by sc (nowadays
for
Hi,
the file oox/source/xls/formulabase.cxx has a section /** Functions
defined by OpenFormula, but not supported by Calc or by Excel. */
Does this refer to the draft ODF 1.2 formula spec?
Which functions are listed there? For example, why are the imaginary
functions and the secant functions
29 matches
Mail list logo