Delete 'conditional formatting' across many sheets at once?

English
#1

Having to go to Format > Condition > Manage on each individual sheet is time consuming.
The reason I’m doing this, is for some reason the Column and Letter show up as #ref.
[strikethrough]I tried to copy the format from a good sheet, and did Ctrl + Shift + V, and the #ref still appears.[/strikethrough]

Right clicking on a cell and doing clear direct formatting is not an option neither, since this removes the display formatting. E.g. 10:42 is shown as 1042. 00\:00.000 is used so I don’t have to manually enter :.

Edit: I was able to copy the format from the good sheet, by manually selecting the cell range a 2nd time; first time is when I used Ctrl C shortly after.

#2

in case you use this for »time-input« … NO, NO, NO… its still »one-thousand-fourty-two« and not »ten minutes and fourty-two seconds«

1 Like
#4

I meant to say 1042 is shown as 10:42 after pressing enter key.
I use the function TEXT(TEXT(A1,"00\:00\:00.000"),"hh:mm:ss.000")), if I need to to do arithmetic. Still beats entering :.

#6

Thats complete nonsense, and returns »error 501«

#7

What do you want/expect if you enter 1063 ?

#3

python:

def remove_all_Conditional_Format(*_):
    doc = XSCRIPTCONTEXT.getDocument()
    for sheet in doc.Sheets:
        _formats = sheet.ConditionalFormats
        for cf in _formats.ConditionalFormats:
            _formats.removeByID(cf.ID)
#5

I thought LibreCalc used BASIC, if they’ve implemented Python I’ll look into this.
I’m familiar with OpenPyXL.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.