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. > In AOO you would use OpenOffice Basic the guide for which can be found at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide Keith
> 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. > > >
signature.asc
Description: OpenPGP digital signature