https://bugs.freedesktop.org/show_bug.cgi?id=45833
Bug #: 45833
Summary: Err:509 on Function Referencing Either Table, Row,
Cell Name, or Time Format (?)
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 RC3
Platform: x86-64 (AMD64)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 56816
--> https://bugs.freedesktop.org/attachment.cgi?id=56816
Err:509 in Row G
I downloaded an Excel 2007 template from
http://office.microsoft.com/en-us/templates/dailyworkprojecthourtracking-TC102031928.aspx
that works fine in Excel of course, but in LibO, I get Err:509 for the
following function in each data cell of column G, which says simply that an
operator is missing:
=Table1[[#this row],[end time]]-Table1[[#this row],[start time]]
In Excel, the function is actually this:
=[@[End Time]]-[@[Start time]]
What it should do is subtract a later time from an earlier time to show the
duration between, like 10:00 - 8:00 = 2:00. I'm no function guru so cannot
determine what is wrong.
There are various other rendering issues too, but those are other bugs.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
