Problem with Numbers in View!
My app links to two tables (tabs) in an Excel Worksheet.
One is for the inputs which shows good and the app edits just fine.
The second sheet has the results of complex formulas in the workbook and I just want to see those results.
So I created a view for the data, and the results.
The results - are read only, and the columns are formatted as numbers.
But the numbers shown in the view are always greater than the actual numbers returned in the spreadsheet.
I have verified that the app has synced and the spreadsheet does have those numbers stored in it and they still show wrong. The spreadsheet rounds the numbers down to nearest 25 increments.
On the view - Results number 7275 from the spreadsheet shows in the app view as 7350.
6525 shows as 6625, 4375 shows as 4400.
It looks like always increments of 25 greater.
On one column the result is zero, but it shows in the app as ‘$VALUE!’.
I can’t see anything else that would be manipulating the data.
Can anyone tell me why the data is not displaying as it shows in the spreadsheet?