[libreoffice-users] Já fez a sua inscrição? Inscreva-se. Vamos p/ o FISL 16, minha inscrição é n. 5.303

2015-07-03 Thread Vitorio Furusho - LibreOffice
Amigos, Já fez a sua inscrição? Inscreva-se. Vamos p/ o FISL 16, minha inscrição é n. 5.303 http://softwarelivre.org/fisl16/ Abraços, Vitorio Furusho https://wiki.documentfoundation.org/User:Furusho Fone: +55 41 9977-3947 Twitter, Facebook, Gtalk, Skype: vfurusho Free Software Furusho

[libreoffice-users] Conditional formatting question

2015-07-03 Thread Rob Jasper
Hi, 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. So, if the value is in col C, this would be the result: A B C D E 1 x y 8 p 2 x2 y2 6

[libreoffice-users] Re: Conditional formatting question

2015-07-03 Thread Andreas Säger
Am 03.07.2015 um 16:23 schrieb Rob Jasper: Hi, 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. So, if the value is in col C, this would be the result: A B C D E 1 x y 8

Re: [libreoffice-users] Conditional formatting question

2015-07-03 Thread Brian Barker
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

[libreoffice-users] Re: Automatic updating of a cell from one spreadsheet to another doesn't work

2015-07-03 Thread Andreas Säger
Am 02.07.2015 um 19:49 schrieb QC: 19) It doesn't work. No path to the document. When I copypaste-special a range of cells with link option, LibreOffice creates an external reference like 'file:///path/document.ods'#%SheetX.$A$1:$F$9 as an array formula. Same when I use the mouse pointer to

Re: [libreoffice-users] Why Does The Title Of My Document Change?

2015-07-03 Thread anne-ology
maybe you've uncovered a bug in your version ;-) If the document is as it was when you saved it, then check to see which extension you've saved it as ... maybe 'search'ing would pull up the /each of the document(s); then you'll be able to see if there are more

Re: [libreoffice-users] Re: Automatic updating of a cell from one spreadsheet to another doesn't work

2015-07-03 Thread QC
I'm not getting anything like that when I try. I'll try with a new user account. Maybe there's something wrong with a configuration file. Then I'll try a few other things. Now that I know what a good link looks like. Thanks! I may be back for more help. If these things don't work and a clean

[libreoffice-users] Libra Office App for Mac

2015-07-03 Thread John Robins
I downloaded the US version easily from the Mac App store. Problem is that it will not accept UK dates of dd/mm/yy. I tried downloading Libre Office from the Web but this won’t work either. How can I resolve this problem please? John John Robins johnrobins...@gmail.com 11, Andrew Close

Re: [libreoffice-users] Conditional formatting question

2015-07-03 Thread Rob Jasper
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

Re: [libreoffice-users] Libra Office App for Mac

2015-07-03 Thread Kevin O'Brien
Go to Tools Options Language Settings, and make your choices for English (UK) instead of English (USA). That should give you the D/M/Y you seek. Regards, On Fri, Jul 3, 2015 at 3:22 PM, John Robins johnrobins...@gmail.com wrote: I downloaded the US version easily from the Mac App store.

[libreoffice-users] Why Does The Title Of My Document Change?

2015-07-03 Thread Nat
Hi, I have a document in Writer. I saved it with a name. When I open it however, the open document shows Untitled at the top instead of the name it was saved with. Then, as I add to the document save, I am asked what I would like to save it as. So again, I save a document as mydoc123.odt.

Re: [libreoffice-users] Why Does The Title Of My Document Change?

2015-07-03 Thread Florian Reisinger
Hi, Are you sure you did not save it as a template? (Ott vs odt) Am 03. Juli 2015 10:17:36 MESZ, schrieb Nat offer...@myemailaddress.biz: Hi, I have a document in Writer. I saved it with a name. When I open it however, the open document shows Untitled at the top instead of the name it was