iPad Excel Formatting Issue
Posted on 2014-11-20
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?