Created attachment 41890 [details] Archive containing S.ods and K.ods Attached 2 simple ods files. S.ods has 2 formulas referencing K.ods. The Sumif formula gives Error 504. The Sum formula works ok. I have opened the files in OpenOffice.org 3.2.1, and there both formulas work. (And I have been using Sumif formulas like this for a long time, but then also referencing a third file.) If that is important, I actually created the files using Norwegian app language, using Summer.hvis, the Norwegian equivalent of Sumif. Using LibO_3.3.0rc2_MacOS_x86_install_en-US, with LibO_3.3.0rc2_MacOS_x86_langpack_nb installed.
My turf. I'll look into this.
Ok. Just pushed my fix to master. http://cgit.freedesktop.org/libreoffice/calc/commit/?id=57ddf99a4b3cc2340d3d5fdb3ae4ac268cb89076 The fix will be in 3.4.
I just found that this also fails for Countif. I just edited the Sumif in S.ods to use Countif and drop the last parameter. Tried it both on LibO_3.3.0rc2_MacOS_x86_install_en-US and LibO_3.3.0rc3_MacOS_x86_install_en-US. Sad to hear we'll have to wait till 3.4, but RC is RC.
Could you file a separate bug for that?
Done. Bug 33137.
target 3.4 is to late, some people can't use LibO. OOo 3.3.0 works fine
This bug is not only true for SUMIF and COUNTIF but for any conditional calculation. So, all external references like "'file:///tmp/file.ods'#$table.A1" work as is but can't be used for generating TRUE / FALSE-values as follows: 'file:///tmp/file.ods'#$table.A1=A2 Due to that I guess this seems to be kind of a more general issue.
This bug is not only true for SUMIF and COUNTIF but for any conditional calculation. So, all external references like "'file:///tmp/file.ods'#$table.A1" work as is but can't be used for generating TRUE / FALSE-values as follows: ='file:///tmp/file.ods'#$table.A1=A2 Due to that I guess this seems to be kind of a more general issue.
General issue, yes, but the code still needs to be adjusted on a individual function basis. I've done major fixes in the 3.4 code base, so please test again when the first 3.4 beta arrives.
Ok! But, do I get it right, if the code for SUMIF and COUNTIF is adjusted on a individual function basis, as side-effect the formula "='file:///tmp/file.ods'#$table.A1=A2" will also work again?
Internally everything is a function, even those '+', '-', '/', '*', '=' etc.. So my comment still holds. Again, please test it with 3.4 beta, and report back any problem you'll find there (with new bugs filed).
I checked this on LibO_3.4.0beta2_MacOS_x86_install_en-US.dmg, and Sumif was working in my sample files.
I've testet it with Win 7 and SuSE 11.4, all seems ok
This is a Calc issue, therefore changed the 'Component' field accordingly.