Search code examples
linuxcsvlibreofficelibreoffice-calc

Error 504 in COUNTIFS while referencing other file


Trying to calculate the following formula:

=COUNTIFS('file:///home/user/PycharmProjects/my_project/My insights/Train/CSV/Train_tags.csv'#$Train_tags.L$1:L$1048576, "1")

But it fails with error 504, despite being successfuly calculated with COUNTIF.
I need COUNTIFS (and not COUNTIF) because I want to stack more conditions.

Searched for COUNTIFS docs, searched for other issues but haven't seen anything related.
Any idea why it fails?


Solution

  • For anyone struggeling with this, I upgraded my LibreOffice version from 5 to 6 and it just worked. Probably a bug in version 5.