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+unsubscr...@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