☝️Small business or a startup? See if you qualify for our special offer.
+

Exported PDF doesn't have the same cells colors

Answered
Julien PULEO asked on February 20, 2025

The pdf export seems to take into account the conditional formatting cell but not the styles applied by customizeCell function.
 
So the visual pivot table is not the same when is exported to PDF.
 
Is it possible to fix it in future release ?

5 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster February 24, 2025

Hello, Julien!

Thank you for reaching out to us.

Please note that for PDF format, Flexmonster only supports exporting text changes, such as modifications to the cell.text property, applied with customizeCell. We are not planning to support exporting to PDF with styles applied via the customizeCell, as this would require a complex manual conversion for every possible customization.

Currently, you can achieve the most accurate export result by exporting to an image. This would create a screenshot of the grid with currently visible data, maintaining the applied styles.

Also, could you share which specific styles you are trying to apply? We might be able to suggest an alternative approach that uses conditional formatting and ensures a consistent appearance in the exported PDF.

We are looking forward to hearing from you.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster April 15, 2025

Hello, Julien!

Hope you are doing well.
We are wondering if you tried exporting Flexmonster to an image or if you could share the specific styles you are aiming to apply.
Our team is looking forward to hearing your feedback.

Best Regards,
Maksym

Public
Julien PULEO April 15, 2025

Hi Maksym,

I'm sorry the problem is not with export PDF but with Excel export.

The color congigured with conditionnal formating is preserved, but the customize cells colors are missing.

Any solution or futur fix possible ?

 

Best Regards

Public
Maksym Diachenko Maksym Diachenko Flexmonster April 16, 2025

Hello, Julien!

Thank you for your reply.

Similar to PDF, the Excel export is not compatible with styles applied with customizeCell API call. As stated in our previous reply, the only solution would be to try applying the same cell color scheme with conditional formatting. Our team could try helping you with this if you shared some details about your use case. This could be the following things:

  • The customizeCell function code.
  • Grid screenshot showing which cells have changed color.

We are looking forward to hearing from you.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster 1 day ago

Hello, Julien!

Hope you are doing well.
Just checking in to ask whether you need any help with moving the logic you currently have in customizeCell over to conditional formatting for keeping color highlights in the exported file.
Please let us know if you need any guidance on this matter.

Best Regards,
Maksym

Please login or Register to Submit Answer