openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "johnny smith" <>
Subject Re: Related to changing font color of a large selection of cells in OpenOffice Calc
Date Tue, 09 Jul 2013 11:39:10 GMT
and here's my reply to pushpak given on 8 July 2013 at 21:00:04:

On Mon, 08 Jul 2013 20:03:08 -0000, Pushpak Dagade <>

> I had cells no. 5 and 10 in bold, rest all normal (ie not bold). I  
> selected all the cells, clicked on 'new style from selection',

 from here it went wrong. the selected cells had different cell style: some
were regular and other bold. so, calc can't have create a single style
 from the entire selection but rather created a style from the first cell
of the selection, which wasn't bold. saving formatting through creation of
a new style works only if all cells are identical in style.

however, that's not a problem. you can just create a backup of the
selection in some spare location in your spreadsheet, maybe on a new
sheet, then clear formatting of the original and restore its cell styles -
but not character styles - from the backup. For that you should copy the
backup, select the original, choose 'edit/paste special' and uncheck
everything but 'formats'.

if sizes of the original and the backup are equal, which is assumed true,
then all cell styles of the backup will be transfered to the original,
after which the backup may be safely disposed of, because it is no longer

p.s. please don't respond to me personally but rather to the list, viz.
<>. it's meant to be a kind of open help desk,
so that your successor in experiencing a similar problem would find the
solution by just googling it.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message