Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

I was reading the SYLK entry in Wikipedia:

and came across the following short SYLK file content:

C;Y1;X1;K"Row 1"
C;Y2;X1;K"Row 2"

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 Build ID: 350m1(Build:2) on GNU/Linux 64-bit
- Version (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

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

Row 1|11
Row 2|22

(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 I've searched 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.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.