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 <guanid...@gmail.com> wrote:
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 needed. p.s. please don't respond to me personally but rather to the list, viz. <users@openoffice.apache.org>. 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: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
