Skip to main content
Solved

Excel connector - retain formatting?

  • November 28, 2023
  • 3 replies
  • 295 views

Dave L
Trendsetter
Forum|alt.badge.img+3

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?  

Best answer by Benoit

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

3 replies

Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • Answer
  • November 29, 2023

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


Dave L
Trendsetter
Forum|alt.badge.img+3
  • Author
  • Trendsetter
  • November 29, 2023

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


Forum|alt.badge.img
  • Apprentice Author
  • October 14, 2025

Hi all, just wondering if there’s any update to this?  Thank you!