Kohei Yoshida schrieb:
Hi there,
I was just wondering where we are on the formula import for our OOXML
importer work. Is it complete, or good enough to be used for other
features that require formula parsing?
OOX: Work is in progress, especially the mapping of built-in function
names, add-in function names, defined names, and sheet names needs to be
implemented. But good enough to be used for other features. Especially
if you need to convert a formula to a list of cell ranges, you can use
the function FormulaProcessorBase::convertToCellRangeList() from
oox/inc/oox/xls/formulabase.hxx (base class of the FormulaParser class).
I will add some documentation to the header now to clearly describe the
parameters...
BIFF: A bit better than OOX, I think, apart from missing support for
external links.
Also, how are we dealing with Excel's shared formulas?
I have implemented shared formula import for the OOX and BIFF filters.
They are as good as the underlying formula import. The only outstanding
task is to hide the generated defined names "__shared_???" that are used
to simulate shared formulas in Calc. We will do this when Niklas is back
from vacation.
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
