Re: [libreoffice-users] Conditional formatting question

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 val

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

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 inst

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

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 wrote: > I downloaded the US version easily from the Mac App store. > > Problem is that it w

[libreoffice-users] Libra Office App for Mac

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 Woking

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

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 th

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

Am 02.07.2015 um 19:49 schrieb QC: > 19) It doesn't work. No path to the document. When I copy&paste-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 ma

[libreoffice-users] Re: Conditional formatting question

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

Re: [libreoffice-users] Conditional formatting question

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] Conditional formatting question

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 c

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

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 Fone: +55 41 9977-3947 Twitter, Facebook, Gtalk, Skype: vfurusho Free Software Furusho

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

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 : >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

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

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.