calligratables and formula offset

Marijn Kruisselbrink mkruisselbrink at kde.org
Thu Jan 13 17:56:04 GMT 2011


On Tuesday, January 11, 2011 03:50:51 pm David Faure wrote:
> Hello,
> 
> I have a question for the applixspread import filter: if I have a formula
> like =B1+C1 for A1,
> and I want to reuse this formula for A3, I need to somehow change it to
> =B3+C3, just like copy/paste would do. Is there some utility function for
> this, which I can call from the applixspread import filter? Thanks.
The xlsx import filter has its own code for that 
(filters/tables/xlsx/FormulaParser.cpp, MSOOXML::convertFormulaReference), 
which probably doesn't even handle 100% all cases correctly. So I think at the 
moment that is something every filter implements independently.

Marijn



More information about the calligra-devel mailing list