• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

iPad Excel Formatting Issue

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
David G. Smith
Asked:
David G. Smith
  • 2
1 Solution
 
mlmccCommented:
What version of Crystal Reports?
What version of Excel?

mlmcc
0
 
David G. SmithOwnerAuthor Commented:
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
 
David G. SmithOwnerAuthor Commented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now