Skip to main content

Is there a way to retain number formatting in excel when using the Pigment Excel Connector?  I can retain things such as cell borders, colors, etc. but cannot retain number formatting.  Every time I pull data to refresh from Pigment, the number formatting is overridden in my excel workbook.

This is not the case with the Google Sheets connector, which does retain number formatting in cells where Pigment data is being imported.  Does this functionality exist for the Excel connector, or is this a feature request?  

Hi Dave,

 

Many thanks for this question / feedback.

You are right, it is something that the Excel connector does not support at the moment but we’ll look to unlock this limitation in the future.

Our Product team is aware of it and will prioritize it. We’ll come back to you when it will be released.

 

Many thanks for your understanding.

Best


Thanks Benoit for the quick reply.  Understood on the current functionality, and we are looking forward to the team unlocking this limitation.


Reply