Solved

iPad Excel Formatting Issue

Posted on 2014-11-20
3
130 Views
Last Modified: 2015-04-18
I have a SQL database using the front end application Prophet 21 (P21).  I use a Crystal Report to pull data and export to Excel.  The data and formatting look good on a standard PC using Excel.  

When you open the same spreadsheet on an iPad, you lose the formatting such as currency, decimals and percentages.  In other words, 12% looks like .12 and a dollar amount such as $12,234.50 looks like 12.2324.50125.

Any idea how to correct within the report builder or is this an APPLE app issue?  Any ideas?
0
Comment
Question by:David G. Smith
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40455745
What version of Crystal Reports?
What version of Excel?

mlmcc
0
 

Accepted Solution

by:
David G. Smith earned 0 total points
ID: 40721137
This was resolved as I was told to use Apple's  "Numbers" program to open an excel file by  holding down the attachment icon and choosing "Numbers" to open the file.  When I open this file with Apple's program, the formatting looks fine.
0
 

Author Closing Comment

by:David G. Smith
ID: 40731074
Prior to engaging further with an Experts Exchange expert, I visited an Apple store and they showed me that opening the excel file in "Numbers" solved the formatting issue.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes in detail how to set up the iPad in the Enterprise using iPCU aka iPhone Configuration Utility.  This could also be used for the iPhone although I have not detailed out any differences. Preparation as an iPad Administrator:…
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now