Howto unit test for LOOKUP with external reference

[Kohei Yoshida]

Hi Regina,

On 8/4/25 03:08, Regina Henschel wrote:
>
> I think, I have now a solution for the unit test. I exchange the IRI 
> that are contained in the LOOKUP parameters with the IRI of the 
> current position of the file. At least that works locally. Jenkins is 
> pending.
>
> The test is currently in ScFiltersTest5. But I'm unhappy with that, 
> because the test is not about filters. Xisco, do you have a suggestion 
> where to put the test?

Not Xisco here, but one way to test a document with an external 
reference is to manually create an external document and assign a fake 
IRI.  If you can take a look at testExternalRef in 
sc/qa/unit/ucalc_formula2.cxx you'll see what I mean.

https://git.libreoffice.org/core/+/refs/heads/master/sc/qa/unit/ucalc_formula2.cxx#1543

I see several test cases below that line that uses this fake 
file:///extdata.fake path to reference external doc.

Kohei