Howto unit test for LOOKUP with external reference

[Regina Henschel]

Kohei Yoshida schrieb am 13.08.2025 um 02:41:
Hi Kohei,

thank you for pointing me to ucalc_formula2.cxx. I need some time to 
understand the details.

Currently the test is committed in the form Xisco has changed it. That 
is, the IRIs are manually set to a relative path in the target document. 
That gives messages about damaged cache when running the test and #Ref! 
errors when opening the target file directly, but the links are repaired 
on update of links. Somehow tricky, but it works for the test.

Kind regards,
Regina

> 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
> 
>