[libreoffice-users] customize keyboard (font color)
Good evening I working with Calc, checking translations made by someone else. I would like to mark certain words within the text in red or any color. For Writer I used: Tools - Customize - Keyboard - Format - Font color fill and assigned a shortcut key. In Calc however, there is no Font color filland ANY shortcut I assign to Font color brings up the Cell Format dialog box. Is it not possible to assign a shortcut key that will change the font color of the particular word/text I am working on in a particular cell? If there is, how do I achieve that? Thank you. Thomas -- 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] remove older version
2015-07-04 13:01 GMT-03:00 Thomas Blasejewicz ny...@hb.tp1.jp: Good evening I made a fresh install of Mint 17.1, 64-bit on a Dell Optiplex 745 machine. Mint comes with LibreOffice 4.2.6.3. Since there is a newer version (4.4.4.3) available, I downloaded and installed it. However, I now have under (Mint) Menu - Office TWO Libreoffice items each (Writer, Calc etc.). In the newer version I am not able to modify / install an extensions. I get errors like: Error while installing extension Alternative searching. The error message is: an error occurred during file opening The extension will not be installed. Error reading data from the Internet. Server error message: Could not read status line: Connection reset by peer. General Internet error has occurred. Somehow I suspect, the old package gets in the way (this kind of trouble with extensions has NEVER happened on any computer with ANY OS before) and I would like to remove it ... but don't know how. Software Manager and Synaptic Package Manger show only ONE version of LibreOffice: 4.4.4.3. Is there a trick to do this? What are the chances this will solve the extension problem? I am also wondering why the newer version did not replace the older one. Thank you. Thomas To have the latest version I recommend remove installed versions, add PPA repositories and install from there. Comunidad LibreOffice Argentina www.libreoffice.org.ar -- 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] remove older version
Good evening I made a fresh install of Mint 17.1, 64-bit on a Dell Optiplex 745 machine. Mint comes with LibreOffice 4.2.6.3. Since there is a newer version (4.4.4.3) available, I downloaded and installed it. However, I now have under (Mint) Menu - Office TWO Libreoffice items each (Writer, Calc etc.). In the newer version I am not able to modify / install an extensions. I get errors like: Error while installing extension Alternative searching. The error message is: an error occurred during file opening The extension will not be installed. Error reading data from the Internet. Server error message: Could not read status line: Connection reset by peer. General Internet error has occurred. Somehow I suspect, the old package gets in the way (this kind of trouble with extensions has NEVER happened on any computer with ANY OS before) and I would like to remove it ... but don't know how. Software Manager and Synaptic Package Manger show only ONE version of LibreOffice: 4.4.4.3. Is there a trick to do this? What are the chances this will solve the extension problem? I am also wondering why the newer version did not replace the older one. Thank you. Thomas -- 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] remove older version
On 04/07/15 17:01, Thomas Blasejewicz wrote: Since there is a newer version (4.4.4.3) available, I downloaded and installed it. How did you do that? If you'd added the PPA deb http://ppa.launchpad.net/libreoffice/ppa/ubuntu trusty main all you would have had to do is an upgrade. In a terminal do sudo apt-get purge libreoffice* That should remove all your versions of LO. Then see here for how to install via PPA: http://linuxpitstop.com/upgrade-libreoffice-4-4-4-on-ubuntu/ As you will have removed ALL your versions of LO then you will have to edit the final command to sudo apt-get install libreoffice -- 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] remove older version
2015-07-04 18:01 GMT+02:00 Thomas Blasejewicz ny...@hb.tp1.jp: Good evening I made a fresh install of Mint 17.1, 64-bit on a Dell Optiplex 745 machine. Mint comes with LibreOffice 4.2.6.3. Since there is a newer version (4.4.4.3) available, I downloaded and installed it. However, I now have under (Mint) Menu - Office TWO Libreoffice items each (Writer, Calc etc.). In the newer version I am not able to modify / install an extensions. I get errors like: Error while installing extension Alternative searching. The error message is: an error occurred during file opening The extension will not be installed. Error reading data from the Internet. Server error message: Could not read status line: Connection reset by peer. General Internet error has occurred. Somehow I suspect, the old package gets in the way (this kind of trouble with extensions has NEVER happened on any computer with ANY OS before) and I would like to remove it ... but don't know how. Software Manager and Synaptic Package Manger show only ONE version of LibreOffice: 4.4.4.3. Is there a trick to do this? What are the chances this will solve the extension problem? I am also wondering why the newer version did not replace the older one. Thank you. Thomas Thomas, my experience with downloading newer versions of LibreOffice on Linux Mint accords with yours, i e, the new version is installed *alongside* the older one. The latter is easy to remove, both via Synaptic and from the menu. As others have mentioned, installing the LibreOffice PPA is one way of making certain that one always has the latest stable version ; I use it myself. Why you can't get extensions to work on the new version is, however, beyond me ; perhaps someone else who frequents our forum knows Here it might be worth noting that the latest version of Linux Mint, 17.2 Rafael, has now been released with a mechanism that allows for an upgrade to be done directly from the Update Manager ; I did this last night and it took all of 2-3 minutes. The version of LibreOffice that comes with LM 17.2 is 4.4.3 Henri -- 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] Conditional formatting question
Hi :) The dynamic methods are more scalable (or just extend a little) and easier to replicate. Also the original question looked like it required a less static approach. With the static approach you need to remember to do 2 actions and try to remember what the reason/rule was for the different back-grounds. Each approach has pros/cons. Anyway, congrats on solving the problem in the way that suits your own use-case the best :)) Regards from Tom :) On 4 July 2015 at 12:42, Rob Jasper r...@famjasper.nl wrote: OK, in stead of an dynamic setting I reverted to manual setting (makes the sheet faster too). I set autofilter on the column, selected all rows not empty, and set the background color... Simple and fast. Why do something dynamic if the data is not that dynamic. On 3 jul. 2015, at 21:32, Rob Jasper wrote: Andreas Brian, thanks, that works great! Now I have another followup question: I already had a formatting for 2 colums where I set the number of digits behind the decimal based on the formula MOD(F2,0.01)=0. This to make a Euro/dfl denomination look like 0.10 and 0.15, while the real old values (e.g. 12.5 cents) display as 0.125 For those values which on have 2 digits after de decimal, the background color doesn't display.. If I look at the conditions the first one is the one just added (Range A2:AMJ3500; Formula ISNUMBER($H2). This is followed by a hugh list in the style F4 — MOD(F4,0.01)=0 F20-F21 — MOD(F20,0.01)=0 Apparently the list breaks if rows are added... I changed the condition to MOD($F2,0.01=0) for the range F2-F3500. It seems that changing the number format conditionally overrides the set background color. Result: If Fx has the value n.nnn it has de correct background but the numberformat displayed is now n.nn If Fx has the value n.nn the background is gone Am I missing something here? Is this expected behavior? Thanks, Rob. On 3 jul. 2015, at 19:17, Brian Barker wrote: At 16:23 03/07/2015 +0200, Rob Jasper wrote: I am looking on a way to set the background color of a full row if one specific field in the row has a value. [Example: C3 = 3.] I looked at conditional formatting but I don't see how to format the complete line based on one value in the line. By having a value, do you mean the specific example value of 3, or do you mean having value as distinct from not having a value (whatever that means)? o Select the relevant rows. o Go to Format | Conditional Formatting... . o For Condition 1, select Formula is from the drop-down menu. o In the box, enter INDIRECT($CROW())=3 - or perhaps INDIRECT($CROW())0 . o For Cell Style, select your cell style with the appropriate background colour (or click New Style... and create a style on the fly). o OK. 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 -- 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 -- 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] customize keyboard (font color)
On 2015/07/04 18:48, Johnny Rosenberg wrote: 2015-07-04 11:34 GMT+02:00 Thomas ny...@hb.tp1.jp mailto:ny...@hb.tp1.jp: Good evening In Calc however, there is no Font color filland ANY shortcut I assign to Font color brings up the Cell Format dialog box. Doesn't sound much like a task for a spreadsheet application to me, Yes. I am aware of that AND totally agree with you. However, translation agencies keep sending me Excel files for translation or editing all the time. I have been trying to convince them for 20 years, that Excel, or Calc, is for CALCULATION. So far with no success at all. That is why I have to cope with these inappropriate tasks/tools. I don't know, but I am pretty sure you can make a macro that does that for you. A macro. OK, I will try that. Thomas -- 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] Conditional formatting question
OK, in stead of an dynamic setting I reverted to manual setting (makes the sheet faster too). I set autofilter on the column, selected all rows not empty, and set the background color... Simple and fast. Why do something dynamic if the data is not that dynamic. On 3 jul. 2015, at 21:32, Rob Jasper wrote: Andreas Brian, thanks, that works great! Now I have another followup question: I already had a formatting for 2 colums where I set the number of digits behind the decimal based on the formula MOD(F2,0.01)=0. This to make a Euro/dfl denomination look like 0.10 and 0.15, while the real old values (e.g. 12.5 cents) display as 0.125 For those values which on have 2 digits after de decimal, the background color doesn't display.. If I look at the conditions the first one is the one just added (Range A2:AMJ3500; Formula ISNUMBER($H2). This is followed by a hugh list in the style F4 — MOD(F4,0.01)=0 F20-F21 — MOD(F20,0.01)=0 Apparently the list breaks if rows are added... I changed the condition to MOD($F2,0.01=0) for the range F2-F3500. It seems that changing the number format conditionally overrides the set background color. Result: If Fx has the value n.nnn it has de correct background but the numberformat displayed is now n.nn If Fx has the value n.nn the background is gone Am I missing something here? Is this expected behavior? Thanks, Rob. On 3 jul. 2015, at 19:17, Brian Barker wrote: At 16:23 03/07/2015 +0200, Rob Jasper wrote: I am looking on a way to set the background color of a full row if one specific field in the row has a value. [Example: C3 = 3.] I looked at conditional formatting but I don't see how to format the complete line based on one value in the line. By having a value, do you mean the specific example value of 3, or do you mean having value as distinct from not having a value (whatever that means)? o Select the relevant rows. o Go to Format | Conditional Formatting... . o For Condition 1, select Formula is from the drop-down menu. o In the box, enter INDIRECT($CROW())=3 - or perhaps INDIRECT($CROW())0 . o For Cell Style, select your cell style with the appropriate background colour (or click New Style... and create a style on the fly). o OK. 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 -- 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