Created attachment 102307 [details] PPC Problem description: The formula in cell C27:C66 appears to have been highlighted to have a missing bracket, however, MS Excel does not highlight this problem and a visual inspection does not seem to indicate that there is a missing bracket. Current behavior: Is it possible that square brackets [] are not parsed by LibreOffice? Operating System: Windows (other) Version: 4.2.5.2 release
Does LO support structured references at all?
Test System: Kubuntu 4.13.2 LibreOffice 4.2.0.2 During the opening of the file, a popup says, "This file contains links to other files. Should they be updated?" Does that have any bearing on the error? My system DOES report the error code "Err 508" for all the listed cells. looking at each cell does not show a missing bracket. =A*(L-(Table1[[#this row],[x]]/B)^(1/Ex)^Ey) When opening the file in LibreOffice 4.3.0.3 the formula reports differently. =A*(L-(Table1[#this row,x]/B)^(1/Ex)^Ey) (Note the different number of brackets).
LibreOffice does not support structured references: http://ask.libreoffice.org/en/question/11977/using-excel-structured-references-syntax-in-calc/
Marking as: Enhancement
Actually this is a duplicate of another enhancement request created by one of our developers. Marking as such. *** This bug has been marked as a duplicate of bug 81711 ***
This issue has been resolved for a while (before LO 5.4.0.3). I assume it was fixed by Eike for bug 85063 and related, so changing the duplicate target. *** This bug has been marked as a duplicate of bug 85063 ***