Unfortunately, this is not quite the same, and rather limited in possibilities.
Also, it destroys ALL existing formatting, which we do NOT want to do. We want only the conditional formatting, e.g. to mark some critical data, or to highlight potential errors. I would rather want to program separately the conditional formatting - as a separate layer - and apply then this *Conditional Formatting Schema* to a spreadsheet. This is similarly to the various XML-schemes, I want to be able to write a schema and apply it to the spreadsheet. Lets say, I want an abstraction layer, and instead of $A1, $A2, $B1, ..., will use named ranges (once the versatility of conditional formatting is enhanced to support such advanced features). [This may need to enhance Calc with additional functions and Conditional Formatting features.] Then a programmer writes an abstract formatting schema. Then everyone reuses this schema everywhere, enterprise-wide. XPATH is already used for enterprise-wide schemes, so why not have something similar for spreadsheets and conditional formatting. Sincerely, Leonard -------- Original-Nachricht -------- > Datum: Tue, 06 Oct 2009 21:28:22 +0200 > Von: Regina Henschel <[email protected]> > An: [email protected] > Betreff: Re: [sc-dev] Copying Conditional Formatting across spreadsheets > Leonard Mada schrieb: > > Dear Calc Team, > > > > I would like to easily copy the *Conditional Formatting* across > > different sheets. > > [see issue: http://www.openoffice.org/issues/show_bug.cgi?id=105659] > > That is possible without problems. > > 1. Mark the cell in the source spreadsheet. > 2. Copy to clipboard. > 3. Goto the target spreadsheet. > 4. Mark the cells, which should get the conditional formatting. > 5. Menu Edit > Paste special > 6. Deselect all but "Formats". OK > > The needed styles are copied too automatically. > > kind regards > Regina > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] -- Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 - sicherer, schneller und einfacher! http://portal.gmx.net/de/go/chbrowser --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
