In Calc functions can use data from other files. For example if we enter formula
then this function will count numbers in file abc.ods.
Alas, not all formulas work with this.
How to use this:
Create spreadsheet and enter some numbers in adjaicent cells, then save this but not close. (or open existing spreadsheet with some numbers in adjaicent cells)
Then create second spreadsheet, type =c Enter, then switch to first document and select some cells with numbers and then switch to second document and press Enter. Appears number in cell. Functions sum, count works.
Functions And, Median, Percentile and many others produces error: Err:504 or Err:508
produced on Libreoffice 3.3.2 on Mandriva 64 bit and windows XP 32 bit
Please re-test this with 3.4 Beta when it's convenient. The external reference has been reworked in 3.4, so there is a chance that this is already fixed in 3.4. If not I'll go fix it.
on LibO 3.4 on Mandriva 64 bit and Windows XP 32bit problem stil exist
can you please attach a little test kit?
Created attachment 51076 [details]
unzip contents to Windows to disk D, start file with formulas, refresh links when asked
In LibreOffice 3.4.3 almost all works except functions AND, OR
We can count this bug as fixed (most functions I not tested yet)
PS: Thanks to developers! Function with problem is fixed, as I can see
[Reproducible] with reporter's testkit and "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]", A6 and A7 show "ERR:504" instead of result "TRUE". Same with Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: d3d1481-3f8994a-2ba0a9f)]".
Works fine with OOo 3.3.
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
reproduced on LibO 3.5.0 beta1
External references should now work with AND and OR. Please verify with 3.5 Beta3 when it's out.
in LibO 3.5.0 beta 3 on Windows and in master on Fedora works correctly
Thanks for fix!