[libreoffice-users] Calc SYLK support error?

I was reading the SYLK entry in Wikipedia:

https://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29

and came across the following short SYLK file content:

ID;P
C;Y1;X1;K"Row 1"
C;Y2;X1;K"Row 2"
C;Y3;X1;K"Total"
C;Y1;X2;K11
C;Y2;X2;K22
C;Y3;X2;K0;ER1C2+R2C2
E

which I copied and pasted into a UTF-8 text file with newline line 
endings named "test.slk".

I loaded test.slk into two builds of LibreOffice Calc:

- Version 3.5.7.2 Build ID: 350m1(Build:2) on GNU/Linux 64-bit
- Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) on 
Microsoft Windows 7 64-bit

Both systems had all OS updates installed as of the time/date on this email.

I expected to get what the Wikipedia page described -- a table with two 
columns, three rows, and one sum:

Row 1|11
Row 2|22
Total|33

but instead I get the following on both aforementioned Calc versions in 
both OSes:

Row 1|11
Row 2|22
Total|0

(I'm using "|" to show where the cell ends/starts, not that theres a 
literal vertical bar anywhere in the SYLK file or Calc output)

I'm seeing the K value for Y3;X2; (from the penultimate line of my SYLK 
file) instead of the computed value 33.

Also, when I focus the cell in column 2 row 3 in both versions of Calc 
listed above I do not see the formula R1C2+R2C2. This formula is clearly 
specified in the SYLK file. I don't see any formula in this cell at all.

Is this because Calc's SYLK support is broken or is something else going on?

When I load my SYLK file into Gnumeric 1.10.17 on GNU/Linux I see 0 in 
the same position (column 2 row 3) but I also see the formula 
("=$B$1+$B$2") and when I recalculate the spreadsheet I get the 33 I 
expect. Thus, Gnumeric isn't recalculating on load but that's okay 
because no data is lost.

Per https://wiki.documentfoundation.org/QA/BugReport I've searched 
https://bugs.freedesktop.org/buglist.cgi?quicksearch=calc+sylk but found 
only 2 bugs neither of which seem applicable so I'm asking on this 
mailing list before filing a bug of my own against Calc.

Thanks.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted