[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;KRow 1 C;Y2;X1;KRow 2 C;Y3;X1;KTotal 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
Re: [libreoffice-users] Calc SYLK support error?
At 17:52 18/07/2013 -0500, J.B. Nicholson-Owens wrote: I was reading the SYLK entry in Wikipedia: https://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29 ... I know nothing about this - but did you notice in the Wikipedia article *Variants of* the format are supported by [...] OpenOffice.org, ... (my emphasis)? and came across the following short SYLK file content: ID;P C;Y1;X1;KRow 1 C;Y2;X1;KRow 2 C;Y3;X1;KTotal 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: ... . 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 ... [...] Total|0 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? Your sample file uses the R1C1 numbered-row-and-column method of referencing cells, which you probably know Calc does not support. Since Calc will save a spreadsheet sheet in its version of SYLK format, it is a fairly simple job to see what works. You need to change the cell references in the formula to the column-letter-and-row-number form. It appears that Calc also needs its name on the first line. Try this: ID;PSCALC3 C;X1;Y1;KRow 1 C;X1;Y2;KRow 2 C;X1;Y3;KTotal C;X2;Y1;K11 C;X2;Y2;K22 C;X2;Y3;K0;EB1+B2 E Will you need CALC4 instead for one of your versions? I trust this helps. Brian Barker -- 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