Created attachment 56816 [details]
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.
Thanks for bugreport
reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit
Changing version to 3.3.4 as most early reproducible
(In reply to comment #1)
> Thanks for bugreport
> reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit
> Changing version to 3.3.4 as most early reproducible
I can reproduce it with LibreOffice 4.0
Changing version to 4.0 release.
But "Version" means that bug appears in this version. It is important to determine when exactly, after which change in program bug appears. And if bug not exist in current version of LO we just close bugreport.
It has to do with Structured Reference which I don't think is implemented in Calc (though I could be wrong). I think this would be good idea to be implemented for interoperability with xlsx, obviously after other bugs and features etc.
Created attachment 116571 [details]
Err:509 in column G
Same issue other File, the file wars created with Office 2007.
Build ID: 40m0(Build:2)
Ubuntu 14.04 LTS x64
This *seems* to be the same as #85063 .
fixed now, see https://wiki.documentfoundation.org/ReleaseNotes/5.1#Table_structured_references
*** This bug has been marked as a duplicate of bug 85063 ***