Export excel number format align with Anaplan data format
Options
SuwareeA1
Member, ALL USERS Posts: 2 Occasional Contributor
We have lineitem set as number with 2 decimal places.
We set export file action with excel format template for user to easily upload back to the system.
The excel output does not set data format by column but by cell which making us lost decimal number if we did not change format to number.
Cell that already has data entered:
Cell without any data:
Any cell with "Number" format, even we enter x.xx. It always show rounding number.
Once we save as CSV or Tab we lost number. We expected to save exact value not a rounding value. It would be good if Anaplan can set the excel output with the proper format since we already identify that in the lineitem.
4
Comments
-
0
Categories
- All Categories
- 2.3K Anaplan Community
- Academy
- Anaplan Talent Builder
- Model Design Course
- The Anaplan Way
- Archive
- 2 Idea exchange
- 62 Enterprise Scale
- 1.1K Extensibility
- 21 Intelligence
- 1.6K Planning & Modeling
- 331 Security
- Community Connections
- Connections
- Experiences
- Groups
- Personas
- Employees
- CS Toolkit
- Customer Care Center
- Forums
- Academy & Training
- Community Feedback & Updates
- Japan
- Anaplan Community Japan
- Anaplan Community Japan Knowledge Base
- HyperCare Japan
- JP-Central
- Support-Japanese
- Partners
- Partner Leadership Council
- Partner Product Council
- 724 Platform
- Anapedia
- App Hub
- Centers Of Excellence
- Extensions
- Planual
- Platform Updates
- 724 User Experience
- Profile Builder
- Resources
- Anaplan Advocates
- Anaplan Live!
- Community
- Community Advancement
- Community Connections
- Partner Program
- The Official Master Anaplanner Program
- Videos
- Welcome to the Anaplan Community!
- Success Central
- Support
- Case Portal Link
- Common Support Questions
- HyperCare Redirect
- Known Issues and Workarounds
- Support test page
- SupportFAQ
- Survey
- 2 Training Day Takeaways