Created attachment 47336 [details]
Zip file containg data.ods and formula.ods
Using LibO_3.4.0rc2_MacOS_x86_install_en-US, I get the wrong result from the IsBlank() function when it is referencing a cell in another ods file.
I have attached a zip with 2 sample files. The file data.ods has an empty A1, formulas with IsBlank() in A2 and A3, showing the correct result.
The file formula.ods has the corresponding formulas in A2 and A3, but referencing A1 from data.ods. And A2 and A3 displays the wrong output.
Fixed on master (for 3.5).
Let me send a request for review to the list shortly... (for 3.4.1).
RC2 is bit by bit identical with release version, so separate items in the version picker are useless. Changes have been discussed with Michael Meeks.
Just tried it in LibO_3.4.1rc1_MacOS_x86_install_en-US. The sample files now behaved correctly. Also tried it in the bigger ods file where I noticed the bug, and IsBlank() also behaved correctly there.