Getting a Table Formula in UNO
mst at libreoffice.org
Mon Jun 29 12:46:11 UTC 2020
On 28.06.20 20:57, Michael wrote:
> I'm trying to write a unit test for
> https://bugs.documentfoundation.org/show_bug.cgi?id=133647. As I see it,
> in order for this unit test to be effective, it needs to either compare
> to the formatted display value of the function (to check whether or not
> "** Expression is faulty **" is being shown) or compare to the formula
> text value (to see if it is getting translated the way I expect). But, I
> am having a heck of a time getting either of those in the unit test.
> I put what I have so far in https://paste.debian.net/1154267/ with the
> output at the bottom in a comment.
apparently there's a SwXCell::getFormula() function...
there's a problem in line 24:
uno::Reference<table::XCell2> xCell2(xTable, uno::UNO_QUERY);
this should be 'xTable->getCellByName("B4")' not "xTable".
but line 62 already prints an empty formula from XCell interface.
> The operational code in DomainMapper_Impl.cxx appears to be writing the
> formula text to a com.sun.star.text.TextField when importing the
> document, but trying to get an XTextField from an XCell like this:
> uno::Reference<text::XTextField> xTextField(xCell, uno::UNO_QUERY);
> In the unit test isn't working, xTextField.is() is false.
a cell isn't a text field; to enumerate the fields in the cell you need
to first enumerate the paragraphs in the cell and then enumerate the
text portions in the paragraph... or use helpers getParagraph() /
getRun() from SwModelTestBase.
> I can get a calculated value by getting an XText from the XCell, but
> that's not what I am after.
> As far as looking at the formatted display value, from what I can tell
> in a debugging session it seems like I need
> DocumentFieldsManager::UpdateTableFields() to run, but I don't know if
> this is happening when running a unit test, maybe it isn't. I can't tell
> if there is some way to force it from a unit test.
probably it's not happening automatically but you can call UpdateFields
either via SwDoc or by dispatching ".uno:UpdateFields".
More information about the LibreOffice