Go Back   MacRumors Forums > iPhone, iPod and iPad > iOS > iOS 6

Reply
 
Thread Tools Search this Thread Display Modes
Old Sep 20, 2012, 05:19 PM   #1
dnkbro
macrumors regular
 
Join Date: Jan 2010
Excel spreadsheet issues with iOS 6

I upgraded to iOS 6 and I'm extremely disappointed. Overlooking the battery drain issues, auto-brightness issues, and maps debacle, one thing that is really bothering me is the issues with excel. My work sends my schedules in a excel format (.xlsx i believe) and so far and the data values for the times are not being displayed correctly. I went into my gmail on the computer and checked the spreadsheet and everything was fine. This has never been an issue with iOS 5. Is anyone else experiencing this issue?
dnkbro is offline   0 Reply With Quote
Old Sep 20, 2012, 10:46 PM   #2
dnkbro
Thread Starter
macrumors regular
 
Join Date: Jan 2010
anyone?
dnkbro is offline   0 Reply With Quote
Old Sep 20, 2012, 11:43 PM   #3
KeepCalmPeople
macrumors 6502a
 
KeepCalmPeople's Avatar
 
Join Date: Sep 2012
Location: San Francisco Bay Area, California
Question

Are you opening the file in the Numbers app?

I don't think I could help without getting a copy of the file to open myself, which is obviously impossible.
KeepCalmPeople is offline   0 Reply With Quote
Old Sep 21, 2012, 11:26 AM   #4
dnkbro
Thread Starter
macrumors regular
 
Join Date: Jan 2010
I'm opening the file through the email (it's an .xlsx document). It is whatever default spreadsheet app that's on the phone (I never downloaded anything new). I downgraded to iOS 5 and it's opening the documents correctly so for sure this is an iOS 6 issue.
dnkbro is offline   0 Reply With Quote
Old Sep 22, 2012, 01:27 AM   #5
Dassvenster
macrumors newbie
 
Join Date: Sep 2012
I'm having exactly the same problems. I get an email sent to me each day with an Excel attachment (though older .xls in my case). I used to be able to view the spreadsheet in iOS 5, but now I can't in iOS 6. It was such a useful feature - why on Earth would they remove it?
Dassvenster is offline   0 Reply With Quote
Old Sep 23, 2012, 04:52 PM   #6
MyGigaHurts
macrumors newbie
 
Join Date: Sep 2012
Same issue with Excel attachments

Also experiencing issues with Excel (xls & xlsx) attachments since updating to iOS 6. The file will open, but with missing fields and formatting. Thus, important data on the file is either missing or incorrect. Like the others here, the issue is with a work schedule that my wife emails to herself so she can glance at it when away from her PC. It appears that the date/time formatting is not being displayed correctly, so every field with a date/time value is being displayed as [$-000]h:mm AM/PM.

Last edited by MyGigaHurts; Sep 23, 2012 at 05:08 PM.
MyGigaHurts is offline   0 Reply With Quote
Old Sep 24, 2012, 09:49 AM   #7
JnDRader
macrumors member
 
Join Date: Mar 2008
Having the same issue. Excel spreadsheet emailed daily no longer opens with the default viewer. A little frustrating.
__________________
Windows convert.
27" 3.1GHz i5, 8GB RAM, 2GB 6970M; 20" Alumimac, 2.66 GHz, 4GB RAM
JnDRader is offline   0 Reply With Quote
Old Feb 5, 2013, 08:58 PM   #8
denaliOnDubs
macrumors regular
 
Join Date: Aug 2011
Location: Southern CO
I'm having this issue also. Sorry to bump an older thread... but did anyone ever find a way to solve this issue? I've tried various free apps with no luck.
denaliOnDubs is offline   0 Reply With Quote
Old Feb 25, 2013, 11:24 AM   #9
davidharris
macrumors newbie
 
Join Date: Feb 2013
Issue still exists!

Our users with iOS 6.x see Excel spreadsheets that have date fields display as currency fields instead. Ugh!
davidharris is offline   0 Reply With Quote
Old Apr 17, 2013, 12:32 PM   #10
muledoggie
macrumors newbie
 
Join Date: Sep 2007
I have the same problem, and since the viewer capability of IOS is apparently the issue, dropbox doesn't render dates in spreadsheets well either.
muledoggie is offline   0 Reply With Quote
Old Aug 20, 2013, 09:30 AM   #11
bpphillips5
macrumors newbie
 
Join Date: Aug 2013
I am not a Mac user, so I apologize if this is less than helpful to a lot of you. That said, I have experienced this same problem when I e-mail my work schedule (in Excel format) home for my wife to look at on her iPad.

My solution is to rewrite the Excel file, using VBScript, and convert the date-cells to a text string representing the date value (e.g. "AUG 20").

I realize that a lot of you may not have A) access to a Windows machine in order to run VBScript; and/or B) the requisite skills to write the code to carry off the transformation, but for those that do, here is an example of what I'm talking about:

Note: This is copied straight from the code that I use, so your loop values will undoubtedly be different.

Code:
dim j
dim oExcel
dim tmp

set oExcel = CreateObject("Excel.Application")

'Convert date-formatted cells to text because Apple's Excel viewer doesn't handle dates properly
for j = 15 to 2 step -1
	'Save date value
	tmp = oExcel.Cells(3,j)

	'Set format = "text"
	oExcel.Cells(3,j).NumberFormat = "@"

	oExcel.Cells(3,j) = Day(tmp) & " " & ucase(MonthName(Month(tmp),true))
next

oExcel.quit

set oExcel = nothing
Brian
bpphillips5 is offline   0 Reply With Quote

Reply
MacRumors Forums > iPhone, iPod and iPad > iOS > iOS 6

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Any way to access "hidden" columns from an Excel spreadsheet? therealseebs Mac Applications and Mac App Store 1 May 2, 2013 05:17 PM
Best spreadsheet excel app? roccobladr iPad Apps 0 Jan 2, 2013 10:28 AM
Help creating a food costing spreadsheet on Excel shoelover4eva Mac Basics and Help 1 Jan 2, 2013 04:56 AM
Are there any Word Perfect/Excel Spreadsheet apps? tpcollins MacBook Pro 5 Oct 8, 2012 02:17 PM
Excel 2011 Lags when more than one spreadsheet is open? Always Red Mac Applications and Mac App Store 0 Oct 2, 2012 06:25 PM

Forum Jump

All times are GMT -5. The time now is 07:51 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC