Dear WAMUGGERS I use excel to publish workbooks to web pages using the OSX version of Office (Excel X for Mac service release 1, running 10.4.2, PB G4). I find there are some annoying little bugs that maybe have a fix?
One is: I have a workbook of multiple worksheets. The formatting is set to 'wrap text'. When I save as web page, it looks fine on my mac, but when I put on the web and look at it with my PC, the text isn't wrapping, and get some strange character artifacts. When I do the conversion on the PC using Office for Windows, it is fine both on the mac and the PC. So I do the conversion on the PC, which takes me time to transfer it across. In 'web options' in Office on the Mac have tried a few different encoding options (Western European, Mac, Western European Windows, Western European DOS) - there are a lot more - but doesn't seem to have any effect. However, because it's quite a labour intensive process to convert, upload and test on both machines, gets a bit boring after while so was wondering if anyone had encountered this. 2nd one is: I do a cumulative spreadsheet of banking transactions. Every 3 months I download banking onto spreadsheets for that quarter, reformat to a standard layout, then transfer to a master spreadsheet. When I copy the data into the master spreadsheet, every now and again all the dates reset (only the year) - usually jump about 5 years into the future - can be fixed by a global replace but easy to miss then the data is useless. If no fix, is there a better spreadsheet that works consistently on OSX, publishes exactly to web pages which are viewed the same on Mac and PC, and that can copy data between spreadsheets without mincing it? Is the Mac version of Excel a 'domestic' version? cheers john
