UserWarning: Conditional Formatting extension is not supported and will be removed

[Steve B.]

Can somebody on the development team please clarify this message?

• It appears to work well
  
  
• It's an extremely useful capability; you can annotate workbooks using it.

So why remove it?!

[I'm using 2.6.4 (which is what the distro's python3 repo I am on happens to support...)]

[Charlie Clark]

On 21 Oct 2020, at 13:14, Steve B. wrote:

> Can somebody on the development team please clarify this message?
>

> - It appears to work well
>
> - It's an extremely useful capability; you can annotate workbooks

> using
> it.
>
> So why remove it?!

It's not part of the OOXML so openpyxl can't handle it. The warning is
just a courtesy to users, so that they're aware that something is being
lost.

Charlie

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

[immersi...@gmail.com]

OK, I can get that. But perhaps you could make an extras area, and a standalone install option, and retire things like that to there, warning that people are on their own using them. LibreOffice has conditional formats, even using formulas, so it's not like it would be just for Microsoft's benefit.

The psycopg2 driver (for python+postgres) did something like that:

https://www.psycopg.org/docs/extras.html

I think a bounty link to fix+maintain such non-core-but-damn-helpful components would be nice too.

Speaking of which: your package is helping a client look good; where can I have them throw the openpyxl developers down a donation?

[Charlie Clark]

I think you misunderstood me: the conditional formats that are covered by the specification are supported. It's just some extended formats, I think traffic lights are a popular one, aren't.

Glad the library is working for your client. Donations are always gladly received! Contact me directly by email for the details.

Charlie