QXlsx icon indicating copy to clipboard operation
QXlsx copied to clipboard

conditional formatting is not working

Open huvic opened this issue 4 years ago • 3 comments

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".

huvic avatar Apr 30 '20 16:04 huvic

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.

j2doll avatar May 01 '20 13:05 j2doll

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

huvic avatar May 19 '20 11:05 huvic

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.

j2doll avatar May 19 '20 12:05 j2doll