We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Formatting between Numbers and Excel
Posted on 2011-03-07
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?
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2- +1
8 Comments
Dear Filipp,
You could try to ask your client to use paste special, and choose values, that way the formatting of the sheet will not be altered..
Kind regards
Eric
You could try to ask your client to use paste special, and choose values, that way the formatting of the sheet will not be altered..
Kind regards
Eric
Active 1 day ago
Well, I already found that this could be a workaround, but I would prefer to look deeper to find out what any possible conflicts could be.
Surely this is something that others have tried to do.
Surely this is something that others have tried to do.
Active 1 day ago
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.
Active today
Hello,
if you don't want to trouble your client with learning how to use Paste Special - Values, you could have a Worksheet Change macro that removes any fill, font color and border formatting from the pasted cells.
Your client would have to have macros enabled to do this.
This is the code for Excel 2007 and later. It goes into the Sheet module (right-click the sheet tab, select View Code and paste the code into the code window)
If you need the code for Excel 2003 or earlier, please pipe up.
cheers, teylyn
if you don't want to trouble your client with learning how to use Paste Special - Values, you could have a Worksheet Change macro that removes any fill, font color and border formatting from the pasted cells.
Your client would have to have macros enabled to do this.
This is the code for Excel 2007 and later. It goes into the Sheet module (right-click the sheet tab, select View Code and paste the code into the code window)
Private Sub Worksheet_Change(ByVal Target As Range)
With Target.Font
.ColorIndex = xlAutomatic
.TintAndShade = 0
End With
With Target.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
With Target
.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
If you need the code for Excel 2003 or earlier, please pipe up.
cheers, teylyn
Active today
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
Active 1 day ago
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.
Featured Post
PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Suggested Courses
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.