Export with same formatting

CommunityMember113484
Occasional Contributor

Export with same formatting

Hi,

Is it possible to export with the same formatting as the module / dashboard ?

e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel.

Thanks in advance,

8 REPLIES 8
MarkWarren
Expert

Re: Export with same formatting

No, the underlying data will always be exported. You could, but you shouldn't, have a text representation of that data to achieve the same effect. But don't do this, Text is bad for the model and I should never have mentioned it.
I'd apply the same formatting in Excel afterwards.
Using the Excel add-in may help if you're looking to export to Excel in a specific way...
Excel Add-in Series 4 - Anaplan Technical Documentation

Singh_Rahul
New Contributor

Re: Export with same formatting

@CommunityMember113484 

 

You can export module as "text" as an option, you would get the desired result.

 

Regards,

Rahul 

CommunityMember113484
Occasional Contributor

Re: Export with same formatting

Doesn't quite work - exporting as text creates a notepad?

Tiffany.Rice
Certified Master Anaplanner

Re: Export with same formatting

@CommunityMember113484 Try exporting with a file type of Excel Open XML (.xlsx).

TiffanyRice_0-1625145370344.png

 

CommunityMember113484
Occasional Contributor

Re: Export with same formatting

Is that only possible in the Old UX? i've got this in the NUX and it doens't provide the option?
Tiffany.Rice
Certified Master Anaplanner

Re: Export with same formatting

Yes, that would have been old UX/blueprint view. See below for option in NUX.

TiffanyRice_0-1625146514161.png

 

CommunityMember113484
Occasional Contributor

Re: Export with same formatting

Thanks - but that doesn't work. I lose the formatting when exporting if using the methodology you've just shown.
Tiffany.Rice
Certified Master Anaplanner

Re: Export with same formatting

Very odd, as it works for me. Could be something in your Excel configuration.