Re: [libreoffice-users] installation problem LO4.4 - linux mint
[with apologies to Tom who'll see this twice. I wish Thunderbird defaulted to 'reply to list'. not 'reply to sender'!] On 12/02/15 21:07, Tom Davies wrote: Hi :) Hmm, i am not sure. Have you made sure you have administrator/SuperUser rights? Sudo perhaps? Regards from Tom :) I upgraded to 4.4 on Qiana by adding the ppa ppa:libreoffice/ppa and upgrading (using apt - synaptic has a few problems on this system.) Seems to work OK. On 12 February 2015 at 17:00, sqroot sqr...@zoho.com wrote: ... I was curious to test LO4.4, so i tried to install it on Linux Mint 17 Qiana. I followed the installation instructions, first purged the old LO-version, downloaded the file, checked it, etc... installation worked fine. but when I try to start it, wheter from the icons or from the command line, i get this error message ... Libre Office 4.4 - Fatal Error The application cannot be started. User installation could not be completed. ... -- Mike Scott (unet2 at [deletethis] scottsonline.org.uk) Harlow Essex England -- 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] installation problem LO4.4 - linux mint
Hi :) Glad to hear it installed properly this time :)) Congrats! :) Thanks for letting us know how you fixed it! :) You might fix the synaptic problem by doing; sudo apt-get check Also doing a reboot after getting a bunch of updates sometimes helps and then clean-up by doing these four commands; sudo apt-get clean sudo apt-get autoclean sudo apt-get autoremove sudo apt-get remove Very handy that the keyboard up-arrow brings previous commands back onto the command-line so that you can edit them! Then Ctrl left-arrow skips a word at a time. Having said that i have 2 *buntu systems that now don't open synaptic so it might be some problem that lots of people are having at the moment and that will doubtless be fixed fairly soon. Err, wrt me getting 2 copies of the message - i really don't mind. Pressing delete twice in quick succession is not much more onerous than pressing it once. I know some people get all unreasonable about it but i'm fine with it. It's not Thunderbird's fault btw. It's the way this mailing list is set-up now. It didn't used to be but people fought for it to be made awkward and clunky like this. TB has a button called something like Group Reply or something but almost no other commonly used emailer has such a ting so people have to use Reply to all instead. So we are very used to getting matched pairs of messages. Regards from Tom :) On 13 February 2015 at 09:27, Mike Scott v...@scottsonline.org.uk wrote: [with apologies to Tom who'll see this twice. I wish Thunderbird defaulted to 'reply to list'. not 'reply to sender'!] On 12/02/15 21:07, Tom Davies wrote: Hi :) Hmm, i am not sure. Have you made sure you have administrator/SuperUser rights? Sudo perhaps? Regards from Tom :) I upgraded to 4.4 on Qiana by adding the ppa ppa:libreoffice/ppa and upgrading (using apt - synaptic has a few problems on this system.) Seems to work OK. On 12 February 2015 at 17:00, sqroot sqr...@zoho.com wrote: ... I was curious to test LO4.4, so i tried to install it on Linux Mint 17 Qiana. I followed the installation instructions, first purged the old LO-version, downloaded the file, checked it, etc... installation worked fine. but when I try to start it, wheter from the icons or from the command line, i get this error message ... Libre Office 4.4 - Fatal Error The application cannot be started. User installation could not be completed. ... -- Mike Scott (unet2 at [deletethis] scottsonline.org.uk) Harlow Essex England -- 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
Re: [libreoffice-users] Calc fails to warn when insert cell breaks sum(A1:A2)
First: I missed sending to the list, so here again is my posting. Ok, I admit. I am the moron. Still I do not see the problem. Calc does not behave the way describe. If you insert a new cell, all its neighbours are influenced, and you yourself chose how, via the dialogue: Move down , Move right, New line or New column (ok I did not quote the headers correctly, but I am convinced you understand). No other option is given. So after a cell insertion with option Move right the neighbours really have new positions one step ahead of the original one. To me, what you describe, Brian, the situation is not inserting a new cell, but a new value, possibly clearing the old one, into cell A1, without changing the structure. Am I correct? If so, the solution is already given by Mark in this thread, namely cell protection. If this is done in an appropriate way, and the user changes the value an allowed cell, no spreadsheet program in this world can hinder that (or warn for it). I honestly try to understand the core of the original question, but I cannot, sorry. At 2015-02-13 04:27, Brian Barker wrote: At 01:14 13/02/2015 +0100, you wrote: I think have a wee difficult to understand what you are doing, as I do not see any error. You put constants 1 and 2 in the cells A1 and A2 and a sum formula in A3. Then you insert an empty cell in A1 while moving the existing content in the cells one step to the right. Hence after the insertion A2 contains the constant 1, A3 contains the constant 2 and A4 contains the formula. All references are relative, so cell A4 now is = sum(A2:A3) giving the result 3, just as before. That the cell A3 computes 2 is evident as it contains the constant you put in cell A2 before the move. You are right that there is no problem to be solved here, but you've misunderstood the detail of the problem. Although you talk of moving content one step to the right, your subsequent description is of the situation if the insertion into A1 moves the rest of column A *down*. Instead, the questioner means what he says: he inserts a new, empty cell into A1, moving the whole of row 1 one place to the right. A2 still has 2 and A3 still has =SUM(A1:A2), so the formula now adds the 2 in A2 to the value of the new empty cell A1 - interpreted as zero, of course. Brian Barker - privately -- 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 fails to warn when insert cell breaks sum(A1:A2)
On Feb 13, 2015, at 9:41 AM, Tom Davies tomc...@gmail.com wrote: Hi :) Ok, you are not being a moron. I wasn't trying to be funny of anything. The software is doing exactly the right thing and even has a little pop-up that people have to choose which way the existing cells have to go. So it really shouldn't be a problem at all. However people often create spreadsheets to do things that would probably be best done in some other program. A classic is to have a long list of numbers, and then those numbers repeated but split out across a table into different columns. Sometimes this is done using equations and codes but usually that just confuses the sorts of people who end-up typing the numbers in. Then each column is totalled-up and the total of the columns 'should' match the total of the long column, of course. This type of Cash-book approach shows the total spent on each budget heading and then also the total amount for the period. Ideally it would be done in GnuCash, Sage Instant/Line50, Quickbooks or some-such. However those are quite expensive (except GnuCash which is free and therefore usually assumed to be not-as-good) and then there are expensive training programs on how to use the expensive ones. So it's a lot cheaper for people (and easier for them to understand) to just start typing numbers into a spreadsheet and then kinda muddle along from there. This only sometimes leads to problems, such as the sum of the whole list not being the same as the total of the budget headings or not matching cash in the bank (after eliminating expected payments and expected income that either isn't quite on the bank statement or hasn't been typed into the cash-book yet). However when a problem DOES happen it's usually quite tricky to find out where things went wrong because everything still looks quite neat in a print-out even if the figures typed in were horribly wrong (we all make tpyos right?). So the problem is that when people insert a few cells they might well not realise that they are also moving cells that are part of some calculation either at the bottom of the sheet or elsewhere - and they might not be thinking about that because they are trying to juggle too many other points at the same time (such as is this zero-rated for tax or exempt or at a different level and does some of the payment have to go in one cell but a bit more of it appear in other columns and does this fit this column/budget heading or that one?) So, yes it's a user-problem, a classic pebcak but it can often be a reasonable error. Yes, but we can modify software to make it easier to use, like issuing a warning when a change that would break a multi-cell reference like this would produce an incorrect or unexpected result (usually called a bug). If so, the default behavior should be to issue a warning before producing the said incorrect or unexpected result, with the current behavior as the default option. [Thanks to Tom(?) for arguing effectively for this default.] Such a feature request would be appropriate if the vast majority of changes that would break a multi-cell reference like this are unintended. Does anyone seriously suggest that's not the case? Thanks to all who commented. Spencer Regards from Tom :) On 13 February 2015 at 11:52, Kaj 70147pers...@telia.com wrote: First: I missed sending to the list, so here again is my posting. Ok, I admit. I am the moron. Still I do not see the problem. Calc does not behave the way describe. If you insert a new cell, all its neighbours are influenced, and you yourself chose how, via the dialogue: Move down , Move right, New line or New column (ok I did not quote the headers correctly, but I am convinced you understand). No other option is given. So after a cell insertion with option Move right the neighbours really have new positions one step ahead of the original one. To me, what you describe, Brian, the situation is not inserting a new cell, but a new value, possibly clearing the old one, into cell A1, without changing the structure. Am I correct? If so, the solution is already given by Mark in this thread, namely cell protection. If this is done in an appropriate way, and the user changes the value an allowed cell, no spreadsheet program in this world can hinder that (or warn for it). I honestly try to understand the core of the original question, but I cannot, sorry. At 2015-02-13 04:27, Brian Barker wrote: At 01:14 13/02/2015 +0100, you wrote: I think have a wee difficult to understand what you are doing, as I do not see any error. You put constants 1 and 2 in the cells A1 and A2 and a sum formula in A3. Then you insert an empty cell in A1 while moving the existing content in the cells one step to the right. Hence after the insertion A2 contains the constant 1, A3 contains the constant 2 and A4 contains the
Re: Re: [libreoffice-users] installation problem LO4.4 - linux mint
thanks mike! adding the ppa means, you did not remove the old LO-version in the first place? regards, markus On Fri, 13 Feb 2015 10:27:28 +0100 Mike Scott lt;v...@scottsonline.org.ukgt; wrote [with apologies to Tom who'll see this twice. I wish Thunderbird defaulted to 'reply to list'. not 'reply to sender'!] On 12/02/15 21:07, Tom Davies wrote: gt; Hi :) Hmm, i am not sure. Have you made sure you have gt; administrator/SuperUser rights? Sudo perhaps? Regards from Tom :) I upgraded to 4.4 on Qiana by adding the ppa ppa:libreoffice/ppa and upgrading (using apt - synaptic has a few problems on this system.) Seems to work OK. gt; gt; On 12 February 2015 at 17:00, sqroot lt;sqr...@zoho.comgt; wrote: ... gt;gt; I was curious to test LO4.4, so i tried to install it on Linux Mint gt;gt; 17 Qiana. I followed the installation instructions, first purged gt;gt; the old LO-version, downloaded the file, checked it, etc... gt;gt; installation worked fine. but when I try to start it, wheter from gt;gt; the icons or from the command line, i get this error message ... gt;gt; Libre Office 4.4 - Fatal Error The application cannot be started. gt;gt; User installation could not be completed. ... -- Mike Scott (unet2 lt;atgt; [deletethis] scottsonline.org.uk) Harlow Essex England -- 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
Re: [libreoffice-users] installation problem LO4.4 - linux mint
hi tom, thanks for your support =) i followed all the apt-get check, clean, autoclean... steps and surprisingly i am now able to start LO from the command line. but, when i use the icons i still get the error message: The application cannot be started. User installation could not be completed. after the LO-logo pops up. it's fine for me this way, because i am able to work with LO started from the terminal. but if you have any suggestions how to solve the problem with the graphical start, this would be perfect =) many thanks, markus On Fri, 13 Feb 2015 10:52:10 +0100 Tom Davieslt;tomc...@gmail.comgt; wrote Hi :) Glad to hear it installed properly this time :)) Congrats! :) Thanks for letting us know how you fixed it! :) You might fix the synaptic problem by doing; sudo apt-get check Also doing a reboot after getting a bunch of updates sometimes helps and then clean-up by doing these four commands; sudo apt-get clean sudo apt-get autoclean sudo apt-get autoremove sudo apt-get remove Very handy that the keyboard up-arrow brings previous commands back onto the command-line so that you can edit them! Then Ctrl left-arrow skips a word at a time. Having said that i have 2 *buntu systems that now don't open synaptic so it might be some problem that lots of people are having at the moment and that will doubtless be fixed fairly soon. Err, wrt me getting 2 copies of the message - i really don't mind. Pressing delete twice in quick succession is not much more onerous than pressing it once. I know some people get all unreasonable about it but i'm fine with it. It's not Thunderbird's fault btw. It's the way this mailing list is set-up now. It didn't used to be but people fought for it to be made awkward and clunky like this. TB has a button called something like Group Reply or something but almost no other commonly used emailer has such a ting so people have to use Reply to all instead. So we are very used to getting matched pairs of messages. Regards from Tom :) On 13 February 2015 at 09:27, Mike Scott lt;v...@scottsonline.org.ukgt; wrote: gt; [with apologies to Tom who'll see this twice. I wish Thunderbird defaulted gt; to 'reply to list'. not 'reply to sender'!] gt; gt; On 12/02/15 21:07, Tom Davies wrote: gt;gt; gt;gt; Hi :) Hmm, i am not sure. Have you made sure you have gt;gt; administrator/SuperUser rights? Sudo perhaps? Regards from Tom :) gt; gt; gt; I upgraded to 4.4 on Qiana by adding the ppa gt; ppa:libreoffice/ppa gt; and upgrading (using apt - synaptic has a few problems on gt; this system.) Seems to work OK. gt; gt;gt; gt;gt; On 12 February 2015 at 17:00, sqroot lt;sqr...@zoho.comgt; wrote: gt; gt; ... gt;gt;gt; gt;gt;gt; I was curious to test LO4.4, so i tried to install it on Linux Mint gt;gt;gt; 17 Qiana. I followed the installation instructions, first purged gt;gt;gt; the old LO-version, downloaded the file, checked it, etc... gt;gt;gt; installation worked fine. but when I try to start it, wheter from gt;gt;gt; the icons or from the command line, i get this error message gt; gt; ... gt;gt;gt; gt;gt;gt; Libre Office 4.4 - Fatal Error The application cannot be started. gt;gt;gt; User installation could not be completed. gt; gt; ... gt; gt; gt; -- gt; Mike Scott (unet2 lt;atgt; [deletethis] scottsonline.org.uk) gt; Harlow Essex England gt; gt; gt; -- gt; To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org gt; Problems? gt; http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ gt; Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette gt; List archive: http://listarchives.libreoffice.org/global/users/ gt; All messages sent to this list will be publicly archived and cannot be gt; 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 -- 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 fails to warn when insert cell breaks sum(A1:A2)
Hi :) Ok, you are not being a moron. I wasn't trying to be funny of anything. The software is doing exactly the right thing and even has a little pop-up that people have to choose which way the existing cells have to go. So it really shouldn't be a problem at all. However people often create spreadsheets to do things that would probably be best done in some other program. A classic is to have a long list of numbers, and then those numbers repeated but split out across a table into different columns. Sometimes this is done using equations and codes but usually that just confuses the sorts of people who end-up typing the numbers in. Then each column is totalled-up and the total of the columns 'should' match the total of the long column, of course. This type of Cash-book approach shows the total spent on each budget heading and then also the total amount for the period. Ideally it would be done in GnuCash, Sage Instant/Line50, Quickbooks or some-such. However those are quite expensive (except GnuCash which is free and therefore usually assumed to be not-as-good) and then there are expensive training programs on how to use the expensive ones. So it's a lot cheaper for people (and easier for them to understand) to just start typing numbers into a spreadsheet and then kinda muddle along from there. This only sometimes leads to problems, such as the sum of the whole list not being the same as the total of the budget headings or not matching cash in the bank (after eliminating expected payments and expected income that either isn't quite on the bank statement or hasn't been typed into the cash-book yet). However when a problem DOES happen it's usually quite tricky to find out where things went wrong because everything still looks quite neat in a print-out even if the figures typed in were horribly wrong (we all make tpyos right?). So the problem is that when people insert a few cells they might well not realise that they are also moving cells that are part of some calculation either at the bottom of the sheet or elsewhere - and they might not be thinking about that because they are trying to juggle too many other points at the same time (such as is this zero-rated for tax or exempt or at a different level and does some of the payment have to go in one cell but a bit more of it appear in other columns and does this fit this column/budget heading or that one?) So, yes it's a user-problem, a classic pebcak but it can often be a reasonable error. Regards from Tom :) On 13 February 2015 at 11:52, Kaj 70147pers...@telia.com wrote: First: I missed sending to the list, so here again is my posting. Ok, I admit. I am the moron. Still I do not see the problem. Calc does not behave the way describe. If you insert a new cell, all its neighbours are influenced, and you yourself chose how, via the dialogue: Move down , Move right, New line or New column (ok I did not quote the headers correctly, but I am convinced you understand). No other option is given. So after a cell insertion with option Move right the neighbours really have new positions one step ahead of the original one. To me, what you describe, Brian, the situation is not inserting a new cell, but a new value, possibly clearing the old one, into cell A1, without changing the structure. Am I correct? If so, the solution is already given by Mark in this thread, namely cell protection. If this is done in an appropriate way, and the user changes the value an allowed cell, no spreadsheet program in this world can hinder that (or warn for it). I honestly try to understand the core of the original question, but I cannot, sorry. At 2015-02-13 04:27, Brian Barker wrote: At 01:14 13/02/2015 +0100, you wrote: I think have a wee difficult to understand what you are doing, as I do not see any error. You put constants 1 and 2 in the cells A1 and A2 and a sum formula in A3. Then you insert an empty cell in A1 while moving the existing content in the cells one step to the right. Hence after the insertion A2 contains the constant 1, A3 contains the constant 2 and A4 contains the formula. All references are relative, so cell A4 now is = sum(A2:A3) giving the result 3, just as before. That the cell A3 computes 2 is evident as it contains the constant you put in cell A2 before the move. You are right that there is no problem to be solved here, but you've misunderstood the detail of the problem. Although you talk of moving content one step to the right, your subsequent description is of the situation if the insertion into A1 moves the rest of column A *down*. Instead, the questioner means what he says: he inserts a new, empty cell into A1, moving the whole of row 1 one place to the right. A2 still has 2 and A3 still has =SUM(A1:A2), so the formula now adds the 2 in A2 to the value of the new empty cell A1 - interpreted as zero, of course. Brian Barker - privately -- To unsubscribe e-mail to:
Re: [libreoffice-users] Where is Base?
Hi all: Would you please open Calc as you can did ? Then in the Menu select please Tools-Options. There select Advance (Option No. 13), there automatic appear JAVA Environment that you have installed in your PC System. Is there nothing appear ... I think is necesary to install JRE 7 or 8 (JAVA Environment) in windows 7 to run BASE of LibreOffice. I hope this help you, Regards, Jorge Rodríguez El jue, 12-02-2015 a las 00:55 -0700, pranzar escribió: Hello. I just installed 4.4.03 on Windows 7. I'd like to use Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Thanks -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- 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]
Kim Maass wrote: PLEASE TAKE ME OFF OF ALL OF YOUR LISTS! THANK YOU. At the bottom of every message you receive from the list is the following: To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Most of us receiving your message are just other users, and have no control over the mailing list subscriptions. However, you can remove yourself by following that instruction. Mark. -- 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
