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?
Surely this is something that others have tried to do.