[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+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] Re: All TDF files "corrupt"
MR ZenWiz wrote: I rebooted (after the kernel update) and all seems well again. Still wondering why that would happen On most OSes (including GNU/Linux) I doubt one can update (in other words, change) something as low-level as an operating system's kernel and continue to run the system normally. After the update and before the reboot, the new kernel is updated on the primary storage medium and the old kernel is still running in memory. I'd imagine that there are all sorts of kernel dependencies where the currently-running kernel and newly-installed kernel differ. Therefore you'll see lots of adverse effects for the currently running system which are resolved by getting everything rebased on the updated kernel. Hence kernel update packages are marked to require a reboot as soon as possible. -- 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
[libreoffice-users] Issue resolved -- system needed updating
MR ZenWiz wrote: Now if I knew why the update got stuck running depmod for more than ten minutes, I'd feel more comfortable. Oh, well. It's hard to say without knowing what was happening at the time. I can only guess it took some time to identify and remove your oldest kernel and all of its unique dependencies (files that aren't shared by any other package) in order to free up space for the newest kernel and its dependencies, plus manipulate whatever configuration files needed changing to accommodate the new kernel, plus do any other ordinary package work performed when installing/removing any package. And on top of all that, do all the other activity the system was also doing at the time. But this is clearly a system administration issue and not related to LibreOffice per se. If you wish to followup please don't be surprised if my address doesn't show up as a destination; I'm experimenting with headers to tell mail clients to only send followups to the list and not to me. I can read followups posted to the list on the list, I don't need another copy sent to me. -- 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] Add Dictionary Online
Brandon wrote: I would like to submit a large dictionary of medical terminology that has already been compiled. It seems that I can only create a new dictionary on a word-by-word basis on the user end, and there doesn't seem to be the option for me to submit directly to the site that Writer links me to when I click "get more dictionaries online". Please help me install this thing. Thank you. It wasn't clear to me if you're trying to install a custom dictionary so you can use it when you run Writer or if you're trying to submit a dictionary to extensions.libreoffice.org (the site I'm taken to when I click the "Get more dictionaries online..." link in Tools->Options->Language Settings->Writing Aids). For personal use, consider visiting http://www.freesoftwaremagazine.com/articles/build_scientific_names_dictionary_libreoffice which describes how to make a dictionary for hunspell, LibreOffice's spell checker, and how to get LibreOffice to see your new dictionary. For adding a dictionary to extensions.libreoffice.org, I'd consider reading the site's how-to documentation for contributing an extension to the site, and then asking extensi...@otrs.documentfoundation.org if I had questions. I haven't gone through the process of submitting an LibreOffice extension there myself but I imagine part of that process involves filling out the form at http://extensions.libreoffice.org/@@hosting-your-extension so the site moderators know what to expect from your contribution. If you decide to share your medical terminology dictionary, thanks for doing that. Such a dictionary sure sounds helpful. -- 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
