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 change it's formating immediately.
It think it's a better way then using search&replace.
Kind regards, Joost
Am 14.03.2019 um 19:44 schrieb Martin Groenescheij:
On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL <wa.two...@verizon.net.invalid>
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 font. Is there a way to change the already typed word
(e.g., Goes) to be in bold font by use of the Find & Replace function?
You can use Conditional Formatting to make a whole Cell bold, just check if the
Cell contains “Goes” and create a new Paragraph Stype.
I am not attempting to highlight an area within the spreadsheet. I do not
program in vbs, or any other language for that matter. :-) Years ago, I started
to learn machine language for the Motorola 6809E chip, but have not ever put
what I learned to use.
TNX for your reply.
VinceB.
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 script (in excel you do this in vbs (visual basic)
but I’m not sure in OO.
The question is what you want to highlight. If it is a summary or other
function you eventually want to arrive at - you can just format the last result
cell.
On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL
(wa.two...@verizon.net.invalid) wrote:
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
Desktop Windows 10-64 Home
________________________________________
I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For example, if the
cell presently shows:
Goes
I want it to be replaced with:
* Goes*
That is, add the *bold* attribute to the existing data.
In the Find & Replace dialogue window, I have selected: Fewer Options,
with none of the boxes checked. I have also selected: Search in:
"Values" (near the bottom of that window).
**
Is there a way to change / replace the assigned attributes when using
Find & Replace function in AOO-Calc Spreadsheets?
Regards,
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
