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,  V, { V, V, V, C, I }, 0, 0 },


The "C" means that the 4th parameter is Calc-only and will be stripped on export. The trailing "I" is needed for some internal resons.

Note that I am not sure that this works out of the box (adding and deleting parameters for the same function), if not, we have to look a bit deeper. Please change the function info in the oox module too, this code might be used in the near/far future to export functions: oox/source/xls/formulabase.cxx, look for "LOGNORMDIST" (line 498 here). Nowadays, that table is used for XLSX/XLSB import only, so no other changes are needed.


Regards
Daniel

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org

Reply via email to