nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Maintain Formatting in Data Export

kylavalley

When exporting data from Anaplan to Excel, it would be great to have the option to maintain certain formatting options such as wrapped text and conditional formatting.

Comments

Miran

Status changed to: New

Chris Wren

another thread with the same thing: https://community.anaplan.com/t5/Idea-Exchange/Option-to-export-conditional-formatting-in-export-to-xls/idc-p/122060#M9235

There is a definite need to be able to export conditional formatting from both NUX and standard reports and exporting.

At the moment we are having to replicate formatting in Excel which is time consuming. It also steers users and stakeholders to just export the raw data in Excel and continue to format and produce reports in Excel when they could be done in excel and exported where necessary

zbunting

I also agree that this should be on the roadmap.

VeronicaP

It will be kept under consideration for the roadmap of Anaplan for Microsoft 365 on Excel.

ExcelGunnar

Agree with original ask. I think having the formats available in MS 365 Add in doesn't address the actual issue.

Vamsi_Kaki

If data exported with conditional formatting from Anaplan to Excel, cells show CF but what if user wants to apply CF with another conditions in Excel? How can CF be differentiated from Original file and later applied conditions?

Quick Links

New ideas

Introduce Native Negative Binomial function
Describe the problem or experience related to your idea: In inventory planning models, Target Stock Levels are commonly calculated using a Negative Binomial distribution to model demand variability and set safety stock/service level targets. This is standard practice because demand is typically overdispersed (variance…
Make Page Builder Workspace Scoped (Limit Delete in Prod)
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Our developers need Page Builder access to create and manage Apps/Boards for model building and enhancements. This is primarily a…
Number format default settings
We use several languages and currencies in our environment. It would be usefull to switch the default number format of number line Items depending on what country the user come from how the user have set it (LI) driver based //GP