Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Daniel Rentz
Eike Rathke schrieb: Hi Regina, On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote: But export to Microsoft Excel 2003 XML (.xml) is problematic. If OOo is set to save in odf1.2, the file opens with errors in Excel. All formulae are stripped. The error log says for example GRUND:

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Regina Henschel
Hi Eike, hi Daniel, Regina Henschel schrieb: No more questions for now, I'll continue my tests. Thanks for your help. Now all works as it should and I'm going to create patches. And have got the next problem. For the file token.cxx in formula/source/core/api I get an odd patch. The patch

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Daniel Rentz
Regina Henschel schrieb: Hi Eike, hi Daniel, Regina Henschel schrieb: No more questions for now, I'll continue my tests. Thanks for your help. Now all works as it should and I'm going to create patches. And have got the next problem. For the file token.cxx in formula/source/core/api I

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Eike Rathke
Hi Regina, On Tuesday, 2009-03-17 22:15:48 +0100, Regina Henschel wrote: While 3.2 will be able to read without arguments for the optional parameters, it will write something that can be read by any 3.x release. OK, a kind of 'political' decision. I'll implement it that way. More a kind of

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-18 Thread Eike Rathke
Hi Regina, On Wednesday, 2009-03-18 12:25:32 +0100, Regina Henschel wrote: For the file token.cxx in formula/source/core/api I get an odd patch. The patch includes the function FormulaMissingContext::AddMissingExternal( FormulaTokenArray *pNewArr ) although there is nothing changed.

[sc-dev] Excel 2003 XML export (was: [sc-dev] How to export expanded LOGNORMDIST to Excel)

2009-03-18 Thread Eike Rathke
Hi Daniel, On Wednesday, 2009-03-18 09:39:51 +0100, Daniel Rentz wrote: That's http://qa.openoffice.org/issues/show_bug.cgi?id=96018 We should consider to drop that filter completely... +1 Objections, anyone? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-17 Thread Regina Henschel
Hi Eike, hi Daniel, I delete the old mail-texts, because it becomes to long and confusing. There are still problems. First the Excel part: Exporting to xls is OK now. I get #NV for four parameters and for parameter count 3 the missing parameters are added. But export to Microsoft Excel

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-17 Thread Eike Rathke
Hi Regina, On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote: But export to Microsoft Excel 2003 XML (.xml) is problematic. If OOo is set to save in odf1.2, the file opens with errors in Excel. All formulae are stripped. The error log says for example GRUND: Ungültiger Wert

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-17 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote: But export to Microsoft Excel 2003 XML (.xml) is problematic. If OOo is set to save in odf1.2, the file opens with errors in Excel. All formulae are stripped. The error log says for

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-17 Thread Frédéric Courchesne
Hi everyone, I am looking for engineering notation in Calc for about 5 years!!! Issue 5930 has been opened in 2002 and is not closed yet: http://www.openoffice.org/issues/show_bug.cgi?id=5930 I would like to participate and do my best to implement this feature. I am actually reading the

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-17 Thread Frédéric Courchesne
Oops. My apologize for posting in this thread. Fred 2009/3/17 Frédéric Courchesne courc...@gmail.com: Hi everyone, I am looking for engineering notation in Calc for about 5 years!!! Issue 5930 has been opened in 2002 and is not closed yet:

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-16 Thread Daniel Rentz
Regina Henschel schrieb: Hi Daniel, That works. When exporting to xls, I get the correct function structure, if there are one, two or three parameters in OOo. If there are four parameters in OOo, I get a =#NV entry in German Excel 2007. I think, the error message is correct, because the user

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-16 Thread Eike Rathke
Hi Regina, On Friday, 2009-03-13 22:20:35 +0100, Regina Henschel wrote: It is a concession that the missing parameters are added, although the user who will export to Excel-format should know, that Excel expects three parameters. Not necessarily. They might use OOo and just have to

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-13 Thread Regina Henschel
Hi Daniel, Daniel Rentz schrieb: Regina Henschel schrieb: Hi, I'm expanding LOGNORMDIST to the form it has in ODF spec. There it is LOGNORMDIST( Number x [ ; Number m = 0 [ ; Number s = 1 [ ; Logical Cumulative = TRUE() ] ] ] ) Inside OOo it is no problem. But how to export it to Excel?

Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-12 Thread Daniel Rentz
Hi again, Daniel Rentz schrieb: To delete the 4th parameter, you can change the function info of this function. Go to xlformula.cxx and look for ocLogNormDist, change the line from { ocLogNormDist,290,3, 3, V, { V }, 0, 0 }, to { ocLogNormDist,290,3, 3,

[sc-dev] How to export expanded LOGNORMDIST to Excel

2009-03-11 Thread Regina Henschel
Hi, I'm expanding LOGNORMDIST to the form it has in ODF spec. There it is LOGNORMDIST( Number x [ ; Number m = 0 [ ; Number s = 1 [ ; Logical Cumulative = TRUE() ] ] ] ) Inside OOo it is no problem. But how to export it to Excel? Excel has 3 Parameters, no one optional. For expanding