Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Martin Groenescheij
On 14/03/2019 20:59, Joost Andrae wrote: Hi, if you format cells using a cell formating template (function key F11) F11 refers to Styles and Formatting which is not the same as Templates. To achieve the desired results you have to  create a Cell Style using the F11 Function Key. Then in on

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Joost Andrae
Hi, if you format cells using a cell formating template (function key F11) then you can easily change this cell formating by changing the cell formating template (eg. by adding background color red to this template). If you change this template then all cells where you assinged the template to

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Martin Groenescheij
> On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL > wrote: > > > Hi David: > > I do not think you understand what I am attempting to do, so I'll try to > clarify what my goal is. > > In my spreadsheet cells I have typed a word, e.g., Goes,many times. I meant > to type that word in Bold fo

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread WA.TWORSX via AOL
Hi David: I do not think you understand what I am attempting to do, so I'll try to clarify what my goal is. In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I meant to type that word in Bold font.  Is there a way to change the already typed word (e.g., Goes) to be in bol

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Keith N. McKenna
On 3/14/2019 11:54 AM, David Belina wrote: > The way the data is displayed in any spreadsheet is determined by the > formatting which is linked to cell/row/column and not the particular > data. The search and replace function searches the data not the > format. > > You might be able to write a sc

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread David Belina
The way the data is displayed in any spreadsheet is determined by the formatting which is linked to cell/row/column and not the particular data.  The search and replace function searches the data not the format. You might be able to write a script (in excel you do this in vbs (visual basic) but