asked on Formatting between Numbers and Excel
I am working with a client on a solution for integrating an iPad into his daily business life.
He is a builder so needs to be mobile, and the size of the iPad is perfect. He works on an excel spreadsheet with a list of orders and would need to modify this spreadsheet on the run. I have been able to string together DropBox, WebDav, DropDav and Numbers into a solution to get the file from his PC to the iPad and back to the PC, but am facing what looks to be a formatting issue between Numbers and Excel.
So once he gets back into the office he logs onto his PC and needs to copy/paste data from Spreadsheet into a new spreadsheet. For some reason when he uses the Paste function the result is a red outlined cell with white text and a light grey shade (see attached).
If I Paste Values I get the intended results (also in screenshot), but I am not using any non-default formatting in the original spreadsheet?
![ScreenShot]()
He is a builder so needs to be mobile, and the size of the iPad is perfect. He works on an excel spreadsheet with a list of orders and would need to modify this spreadsheet on the run. I have been able to string together DropBox, WebDav, DropDav and Numbers into a solution to get the file from his PC to the iPad and back to the PC, but am facing what looks to be a formatting issue between Numbers and Excel.
So once he gets back into the office he logs onto his PC and needs to copy/paste data from Spreadsheet into a new spreadsheet. For some reason when he uses the Paste function the result is a red outlined cell with white text and a light grey shade (see attached).
If I Paste Values I get the intended results (also in screenshot), but I am not using any non-default formatting in the original spreadsheet?
Microsoft ExceliPadApple Software
Last Comment
Flipp
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Hi Flipp,
It is a weird formatting/conversion issue going from Excel to Numbers for iPad and back. I don't know if there is a solution other than to do paste special and values or use the format painter to fix it post-paste.
It is a weird formatting/conversion issue going from Excel to Numbers for iPad and back. I don't know if there is a solution other than to do paste special and values or use the format painter to fix it post-paste.
SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Oooo, that's certainly better than Format Painter. Nice job teylyn.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Here's the same macro code for Excel 2003 and earlier
Any cell that is edited or pasted will be formatted with no background, automatic font color and no borders.
cheers, teylyn
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
.Font.ColorIndex = 0
.Interior.ColorIndex = xlNone
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
.Borders(xlEdgeLeft).LineStyle = xlNone
.Borders(xlEdgeTop).LineStyle = xlNone
.Borders(xlEdgeBottom).LineStyle = xlNone
.Borders(xlEdgeRight).LineStyle = xlNone
.Borders(xlInsideVertical).LineStyle = xlNone
.Borders(xlInsideHorizontal).LineStyle = xlNone
End With
End Sub
Any cell that is edited or pasted will be formatted with no background, automatic font color and no borders.
cheers, teylyn
ASKER
Does anyone have a copy of Numbers on Mac that they can test? I would like to know if this is isolated to Numbers App on iPad or Numbers in general.
ASKER
Thank you all - did not see any update to my final comment so closing question.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Surely this is something that others have tried to do.