Hi Daniel, Sorry I didn't reply earlier. I was on vacation on Friday.
On Fri, 2007-08-03 at 09:48 +0200, Daniel Rentz wrote: > 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... Ah, nice. Thanks for the info. :-) > 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. Gotcha. I was just wondering about the status of shared formulas, because I had noticed some recalculation problem upon loading of documents containing shared formulas. Anyway, I trust that problem will be worked on as part of solving the above problem (?) Thanks, Kohei --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
