QXlsx
QXlsx copied to clipboard
conditional formatting is not working
If I read a xlxs file that contains "conditional formatting" and later I save this file, then, the "conditional formatting" is lost. This problem appears specially with the type "Format only cells that contain" of "conditional formatting".
Dear @huvic
QXlsx does not support formula function properly.
If you need this function, we recommend using QXlnt or xlnt.
I will register this issue to a enhancement.
Hello, I have implemented a new function in QXlsx that copies the style from one excel file to other so that the conditional format is copied. This way, if you have an excel template and you create a new excel file using this tempalte (fill some cells and save), then, you can use the function "copyStyle(template,newfile)" to copy the original style and maintain the conditional format in the new file. I have tested and it seems to work, at least, with my samples. If you are interested, I can send you (or upload) implementation. Let me know if you are intereted and the way to proceed. Best regards
Dear @huvic
This project is an open source project and everyone is welcome to participate. 😃
If you perform a pull request, we will add it to a separate branch for testing.
Please write in easy English. Because I don't speak English as a native language, I can't speak English fluently.