Thomas | 4 Jul 12:53 2015
Picon

Re: customize keyboard (font color)

On 2015/07/04 18:48, Johnny Rosenberg wrote:
> 2015-07-04 11:34 GMT+02:00 Thomas <nyuwa <at> hb.tp1.jp 
> <mailto:nyuwa <at> hb.tp1.jp>>:
>
>     Good evening
>     In Calc however, there is no "Font color fill"and 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+unsubscribe <at> 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/
(Continue reading)

Thomas | 4 Jul 11:34 2015
Picon

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 fill"and 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

Rob Jasper | 3 Jul 21:32 2015
Picon

Re: 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 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:
(Continue reading)

John Robins | 3 Jul 21:22 2015
Picon

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
johnrobins921 <at> gmail.com

11, Andrew Close
Wokingham. RG40 2 HY

07710 612339 / 0118 978 4486

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Rob Jasper | 3 Jul 16:23 2015
Picon

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
3	x3	y3	3	7	f
4	x4	y4		9	g

I looked at conditional formatting but I don't see how to format the complete line based on one value in the line

Does someone of you bright minds have an idea how to accomplish this?

Thanks,
Rob.

Nat | 3 Jul 10:17 2015

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.  Later I open mydoc123.odt.
Once opened, instead of mydoc123.odt showing at the top as the title,
it says "untitled".  When I update the document and save, I have to
name it again.  Why?

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Cor Nouws | 2 Jul 18:40 2015
Picon

nice weather for a LibreOffice Hackers/Users event in The Netherlands, next Sunday :)

Hi all,

Temperature will drop to as low as 26 degrees here. And the
trainingcenter where the Hackers/Users event is organized, is pretty
cool too :)
So do you happen to be in the area: welcome!

https://wiki.documentfoundation.org/NL/bijeenkomst_2015-07-05

Cheers,
Cor

-- 
Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger http://nl.libreoffice.org
- volunteer http://www.libreoffice.org
- The Document Foundation Membership Committee Member

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
QC | 2 Jul 02:18 2015
Picon

Automatic updating of a cell from one spreadsheet to another doesn't work

Ok, so I have this spreadsheet, and a Writer document with embedded
spreadsheets.
It's an invoice document with two pages each with it's own spreadsheet.
Because I
could never figure out how to link the subtotal from one page (i.e. one
internal embedded
spreadsheet to another) to the next, I linked in a subtotal from the time
tracking spreadsheet.
Apparently internal document links are illegal in LibreOffice.

Why? I don't know. He's on third.

Well it *USED* to automatically update, back in the day. Not sure when it
broke. Maybe I broke
something in the configuration. It's pretty freaking fragile. I breath the
wrong way and something breaks.
Anyway.

I noticed maybe last month it's not updating anymore. Again this month,
nothing. Opening up the links
dialog and it shows as manual and no option to make it automatic. Searched
help docs and it says it
needs to be a DDE link. Ok, fine. So I follow the instructions and make a
"DDE" link. Only when it does that
it doesn't include the file path, so it can't find the link. Useless. Tried
to edit it. I doesn't like that, and it turns it into a URL.
URLs don't compute.

This should be a simple no-brainer. Here I am 2 hours later. Wasting a
couple hundred dollars of my time
(Continue reading)

john.egger | 1 Jul 20:04 2015
Picon
Picon

Editing an html page

Please pardon me if I do not use the correct terminology. I do not know html. 

About a year ago I was able to open and edit my website's home page,
index.html, using LO (Writer, I think). It looked just like the web page
itself, but could be edited and then previewed to show what it would look
like when the changes were saved. Links could be changed, photographs and
text replaced, etc.

Now, however, every attempt to open "index.html" gives screens of (I
presume, html code) numbers and letters that I do not know how to work with.

There is a remote possibility I was doing this with OOo Writer, but I'm
quite sure I had moved to LO by a year ago.

Can anyone help? I would like to make some changes to that page without
investing the resources to learn html. [LibreOffice Version: 4.2.8.2, Build
ID: 420m0(Build:2) with Kubuntu 14.4]

--
View this message in context: http://nabble.documentfoundation.org/Editing-an-html-page-tp4153337.html
Sent from the Users mailing list archive at Nabble.com.

Kevin O'Brien | 1 Jul 17:10 2015
Picon

Impress Drawing Object Styles: Headings and Titles

I am a little confused by the Drawing Object Styles called Heading and
Title. Are they intended for different uses? What would be a good use
case for each of these?

Thanks,

-- 
Kevin B. O'Brien
zwilnik2 <at> gmail.com
http://google.me/+kevinobrien
“If there are no dogs in Heaven, then when I die I want to go where they went.”
- Will Rogers

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
QC | 1 Jul 16:52 2015
Picon

Automatic updating of a cell from one spreadsheet to another doesn't work

Ok, so I have this spreadsheet, and a Writer document with embedded
spreadsheets.
It's an invoice document with two pages each with it's own spreadsheet.
Because I
could never figure out how to link the subtotal from one page (i.e. one
internal embedded
spreadsheet to another) to the next, I linked in a subtotal from the time
tracking spreadsheet.
Apparently internal document links are illegal in LibreOffice.

Why? I don't know. He's on third.

Well it *USED* to automatically update, back in the day. Not sure when it
broke. Maybe I broke
something in the configuration. It's pretty freaking fragile. I breath the
wrong way and something breaks.
Anyway.

I noticed maybe last month it's not updating anymore. Again this month,
nothing. Opening up the links
dialog and it shows as manual and no option to make it automatic. Searched
help docs and it says it
needs to be a DDE link. Ok, fine. So I follow the instructions and make a
"DDE" link. Only hen it does that
it doesn't include the file path, so it can't find the link. Useless. Tried
to edit it. I doesn't like that.

This should be a simple no-brainer. Here I am 2 hours later. Wasting a
couple hundred dollars of my time
doing a task that can't be much simpler. I was doing this stuff in Word
(Continue reading)


Gmane