Handling of worksheet functions from Excel 2010 and newer

Markus Mohrhard markus.mohrhard at googlemail.com
Mon Nov 11 15:30:24 PST 2013


2013/11/11 Kohei Yoshida <kohei.yoshida at collabora.com>

> Hi there,
> Eike brought to my attention that my recent change to use the internal
> API to import formulas from xlsx broke the extra handling that the UNO
> API was doing to translate some of the newer Excel functions from Excel
> 2010 and newer.  These new functions are typically prefixed with _xlfn.
> in the XML stream so that when the function name is e.g. BETA.DIST, it
> would appear as _xlfn.BETA.DIST in the sheet stream where the formula
> cell is stored.
> Long story short, the way I've decided to solve this was to add another
> set of function names and associate it with formula language XL_ENGLISH,
> which is, for now, only used for importing xlsx in a significant way.
> So, when you guys have implemented these new functions in Calc core, but
> have trouble importing them from xlsx, please take a look at resource
> formula/source/core/resource/core_resource.src and see if the stored
> function name matches what's in the XML stream.
> Hopefully this fixes the old functionality from the UNO formar parser
> that we were missing in ScCompiler.
And a small request by me. Could we maybe add always directly an
import/export test when we add a new function?

Adding an import/export test for a function is normally a task of a few
minutes and should help us prevent regressions with these functions.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20131112/cdee7274/attachment.html>

More information about the LibreOffice mailing list