[libreoffice-users] Re: Calc problem
Hi Tom and all that reply, thank you all for your answers. Kind regards, Ivan Omazic - Ivan Omazic IT Assistant / Technical Lead ioma...@wmo.int +41 22 730 81 55 +41 79 918 34 26 -- View this message in context: http://nabble.documentfoundation.org/Calc-problem-tp4094299p4095424.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Calc problem
I have had similar problems including both simple formulas and, in some cases, simple links to other cells. This occurs not only when I save to xlsx, but also when I save to xls. These same spreadsheets save with no problems using 4.1.4, to which I have had to revert. Unfortunately, I need to supply the spreadsheets to multiple clients in multiple organizations who may or may not use LibreOffice and over whom I have no control. This makes it impractical to save in ODF format. Since I am a Linux user, using Microsoft is not an option even if I wanted to. This is a serious problem. -- View this message in context: http://nabble.documentfoundation.org/Calc-problem-tp4094299p4095017.html Sent from the Users mailing list archive at Nabble.com. -- 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: Calc problem
Hi :) That is a tad disturbing. Please file a bug-report about it https://wiki.documentfoundation.org/BugReport This is about the first time we've had reports of problems with Xls but a lot of work went into Calc for the 4.2.0. It's plausible that created glitches. Hopefully those might get ironed out quickly if people report any odd problems they find with the 4.2.0. It is good to tests-drive the new branch as soon as it comes out (or even before) to make sure any unexpected oddities do show up. For production use it's good to use the latest stable-branch, currently the 4.1.4 i htink Regards and apols from Tom :) On 1 February 2014 18:17, bearymore caxilb...@iasinfo.com wrote: I have had similar problems including both simple formulas and, in some cases, simple links to other cells. This occurs not only when I save to xlsx, but also when I save to xls. These same spreadsheets save with no problems using 4.1.4, to which I have had to revert. Unfortunately, I need to supply the spreadsheets to multiple clients in multiple organizations who may or may not use LibreOffice and over whom I have no control. This makes it impractical to save in ODF format. Since I am a Linux user, using Microsoft is not an option even if I wanted to. This is a serious problem. -- View this message in context: http://nabble.documentfoundation.org/Calc-problem-tp4094299p4095017.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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] Re: Calc problem
Hi IOmazic IOmazic wrote So what I am doing wrong? You aren't doing anything wrong. It's a Bug. Even worse, because of the error when the formula is saved, the xlsx file is not compatible with Excel... However LibreOffice's purpose is to promote the use of the open document format ODF. If you save the file with the formula as ODS there is no loss... (the target file can remain xlsx) So maybe you can have a MS Office replacement for free but you need to adjust a little... Alternatively you can try to convince people to fix the bug for you or fix it yourself (if you are a developer) and contribute the patch to the project... -- View this message in context: http://nabble.documentfoundation.org/Calc-problem-tp4094299p4094305.html Sent from the Users mailing list archive at Nabble.com. -- 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: Calc problem
Hi :) The new XlsX format is notoriously unreliable, in my opinion and as people seem to suggest on this mailing list. Each version of MS Office 'accidentally' introduces different variances from each other and from the ISO standard as published. So, if you move to another version of MS Office then there is a good chance you will find pre-existing documents also have problems with MS Office. The current best format to allow different people to actively work on spreadsheets together and exchange between each other is the older MS format. Use File - Save As ... - MS Excel 2003/Xp or something like that to save in .xls without the X at the end. This allows Android and iPad/iPhones users to also freely use the spreadsheets. For the longer term storage of documents the ODF formats are better. For spreadsheets the specific one is .ods and it is likely to become the best one to use when sharing and collaborating too in the next few years. Regards from Tom :) On 28 January 2014 12:30, Pedro pedl...@gmail.com wrote: Hi IOmazic IOmazic wrote So what I am doing wrong? You aren't doing anything wrong. It's a Bug. Even worse, because of the error when the formula is saved, the xlsx file is not compatible with Excel... However LibreOffice's purpose is to promote the use of the open document format ODF. If you save the file with the formula as ODS there is no loss... (the target file can remain xlsx) So maybe you can have a MS Office replacement for free but you need to adjust a little... Alternatively you can try to convince people to fix the bug for you or fix it yourself (if you are a developer) and contribute the patch to the project... -- View this message in context: http://nabble.documentfoundation.org/Calc-problem-tp4094299p4094305.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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] Re: calc problem
It opens OK in the Mac, LO 4.0.1.2 version. 114 Rows by 13 columns. -- View this message in context: http://nabble.documentfoundation.org/calc-problem-tp4046080p4046119.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: calc problem
Hi :) It opens fine in Gnumeric but not LibreOffice 4.0.0 on Ubuntu 12.04. So far it only seems to open on a Mac. Regards from Tom :) From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Monday, 25 March 2013, 22:57 Subject: [libreoffice-users] Re: calc problem It opens OK in the Mac, LO 4.0.1.2 version. 114 Rows by 13 columns. -- View this message in context: http://nabble.documentfoundation.org/calc-problem-tp4046080p4046119.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Re: calc problem
I right-click the hyperlink in my browser, mail program, office document, whatever and choose a command like Copy Link Address. Then I paste the naked URL string into a Calc cell. -- For unsubscribe instructions e-mail to: users+h...@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: calc problem
Curious: How can right click, left click pop up menu, and Ctrl+V be slower than highlight the link, Ctrl+C, and Ctrl+V? I really do not see the difference. How are you selecting the links? --Dan On Mon, 2012-02-27 at 14:19 +0100, Václav Medek wrote: Hi Andreas, thanks for reply. Yes this works. But it is only half solution. I need it to work with ctrl+c/ctrl+v because it is faster then clicking with mouse. (Btw. in my opinion both should be the same, not different) Dne 27.2.2012 13:34, Andreas Säger napsal(a): I right-click the hyperlink in my browser, mail program, office document, whatever and choose a command like Copy Link Address. Then I paste the naked URL string into a Calc cell. -- For unsubscribe instructions e-mail to: users+h...@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: calc problem
Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working right as expected. When ctrl+c/ctrl+v some email address to Calc, no dialogue appear and address is just filled into Calc cell (as link, not as clear text, but it is not important for me). But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you are right that it is OS/browser problem. Dan I think that discussion what is faster or slower is off topic. I just need to solve problem with dialogue. Not find how to do it better or another way. Dne 27.2.2012 14:48, Dan Lewis napsal(a): Curious: How can right click, left click pop up menu, and Ctrl+V be slower than highlight the link, Ctrl+C, and Ctrl+V? I really do not see the difference. How are you selecting the links? --Dan On Mon, 2012-02-27 at 14:19 +0100, Václav Medek wrote: Hi Andreas, thanks for reply. Yes this works. But it is only half solution. I need it to work with ctrl+c/ctrl+v because it is faster then clicking with mouse. (Btw. in my opinion both should be the same, not different) Dne 27.2.2012 13:34, Andreas Säger napsal(a): I right-click the hyperlink in my browser, mail program, office document, whatever and choose a command like Copy Link Address. Then I paste the naked URL string into a Calc cell. -- For unsubscribe instructions e-mail to: users+h...@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: calc problem
2012/2/27 Václav Medek vaclav.me...@nic.cz: Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working right as expected. When ctrl+c/ctrl+v some email address to Calc, no dialogue appear and address is just filled into Calc cell (as link, not as clear text, but it is not important for me). But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you are right that it is OS/browser problem. I tried it and I never saw a dialogue. The link was pasted into the cell as pure text. I don't know if that's what you are looking for, though. Operating system: Ubuntu 10.10 Web browser: Opera 11.61 Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dan I think that discussion what is faster or slower is off topic. I just need to solve problem with dialogue. Not find how to do it better or another way. Dne 27.2.2012 14:48, Dan Lewis napsal(a): Curious: How can right click, left click pop up menu, and Ctrl+V be slower than highlight the link, Ctrl+C, and Ctrl+V? I really do not see the difference. How are you selecting the links? --Dan On Mon, 2012-02-27 at 14:19 +0100, Václav Medek wrote: Hi Andreas, thanks for reply. Yes this works. But it is only half solution. I need it to work with ctrl+c/ctrl+v because it is faster then clicking with mouse. (Btw. in my opinion both should be the same, not different) Dne 27.2.2012 13:34, Andreas Säger napsal(a): I right-click the hyperlink in my browser, mail program, office document, whatever and choose a command like Copy Link Address. Then I paste the naked URL string into a Calc cell. -- For unsubscribe instructions e-mail to: users+h...@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] Re: calc problem
Am 27.02.2012 16:53, Johnny Rosenberg wrote: 2012/2/27 Václav Medekvaclav.me...@nic.cz: Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working right as expected. When ctrl+c/ctrl+v some email address to Calc, no dialogue appear and address is just filled into Calc cell (as link, not as clear text, but it is not important for me). But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you are right that it is OS/browser problem. I tried it and I never saw a dialogue. The link was pasted into the cell as pure text. I don't know if that's what you are looking for, though. You see the text import dialog when you copy and paste multi-line text. This will never happen when you use the URL copy of the respective browser. Under Linux you can also use the system clipboard (middle mouse) to paste previously selected unformatted text. But this will also trigger a text table import in case of multiple lines. If you want multi-line text in one cell, you can always hit F2 before pasting. -- For unsubscribe instructions e-mail to: users+h...@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: calc problem
Dne 27.2.2012 17:27, Andreas Säger napsal(a): Am 27.02.2012 16:53, Johnny Rosenberg wrote: 2012/2/27 Václav Medekvaclav.me...@nic.cz: Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working right as expected. When ctrl+c/ctrl+v some email address to Calc, no dialogue appear and address is just filled into Calc cell (as link, not as clear text, but it is not important for me). But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you are right that it is OS/browser problem. I tried it and I never saw a dialogue. The link was pasted into the cell as pure text. I don't know if that's what you are looking for, though. You see the text import dialog when you copy and paste multi-line text. This will never happen when you use the URL copy of the respective browser. Under Linux you can also use the system clipboard (middle mouse) to paste previously selected unformatted text. But this will also trigger a text table import in case of multiple lines. If you want multi-line text in one cell, you can always hit F2 before pasting. URL copy works fine. Anyway, it seems like it happen in some circumstances only in latest Ubuntu 11.10. Now I tried it in Xubuntu 11.04 with Libre Office 3.3.4 and Firefox 10.0.2 and there it is ok - no dialogue (Import Options) appear and its just pasted as link into a cell. I still dont have any idea what and how to configure to avoid that dialogue. There must be some reason why Libre Office see it as multi-line (or whatever else). -- For unsubscribe instructions e-mail to: users+h...@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: Calc: Problem pasting listboxes
On Mon, Mar 21, 2011 at 12:37 AM, nvrk nvrk.89...@gmail.com wrote: On Sun, Mar 20, 2011 at 6:41 PM, Jim Trigg jktr...@gmail.com wrote: On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg jktr...@gmail.com wrote: I'm trying to set up a sheet with multiple listboxes nearly alike, each taking its data from a cell range in another sheet in the same file ('other sheet'.b218:b238). If I copy one and paste it, the pasted copy does not work -- it does not pull any data (drop-down does not have any items, even blank ones, even though it is specified to have 20). Any suggestions other than create each listbox by hand? The reason I'm using copy/paste is that each box is supposed to be the same size, and take the same input (while feeding a different cell). Just to give specifics, this is running LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 (32-bit) Windows version under 64-bit Windows 7 Home Premium. I have now confirmed that the problem exists in the 64-bit build on Ubuntu 10.10. 1. What happens if data source becomes ('other sheet.$b$218:$b$238) ?; It can't; if I input that into Source cell range as soon as I tab out the $s are stripped out of the reference. and/or 2. What happens if copy/paste/special is used? The same thing. However, I have determined that saving and reloading the sheet makes the list boxes work. I'm pretty sure this is a bug, but don't know what further info is wanted by the developers to work the problem (especially as I can't send a file that is a test case, just instructions on how to reproduce). Jim -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc: Problem pasting listboxes
On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg jktr...@gmail.com wrote: I'm trying to set up a sheet with multiple listboxes nearly alike, each taking its data from a cell range in another sheet in the same file ('other sheet'.b218:b238). If I copy one and paste it, the pasted copy does not work -- it does not pull any data (drop-down does not have any items, even blank ones, even though it is specified to have 20). Any suggestions other than create each listbox by hand? The reason I'm using copy/paste is that each box is supposed to be the same size, and take the same input (while feeding a different cell). Just to give specifics, this is running LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 (32-bit) Windows version under 64-bit Windows 7 Home Premium. Thanks, Jim -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc: Problem pasting listboxes
On Sun, Mar 20, 2011 at 6:41 PM, Jim Trigg jktr...@gmail.com wrote: On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg jktr...@gmail.com wrote: I'm trying to set up a sheet with multiple listboxes nearly alike, each taking its data from a cell range in another sheet in the same file ('other sheet'.b218:b238). If I copy one and paste it, the pasted copy does not work -- it does not pull any data (drop-down does not have any items, even blank ones, even though it is specified to have 20). Any suggestions other than create each listbox by hand? The reason I'm using copy/paste is that each box is supposed to be the same size, and take the same input (while feeding a different cell). Just to give specifics, this is running LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 (32-bit) Windows version under 64-bit Windows 7 Home Premium. Thanks, Jim -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** 1. What happens if data source becomes ('other sheet.$b$218:$b$238) ?; and/or 2. What happens if copy/paste/special is used? FWIW - I could easily be barking up a wrong tree here since I am a far cry from an experienced user. nvrk -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***