Solved

iPad Excel Formatting Issue

Posted on 2014-11-20
3
132 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

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

Set up iPhone and iPad email signatures to always send in high-quality HTML with this step-by step guide.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

821 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