On Thursday 12 July 2007 06:56:16 Helen Fox wrote: > Hi > I have been using the open office spreadsheets but have found a > conflict when others open up the file in excel. In particular, > using data validity. I have chosen a list as part of the criteria > but when it converts to the excel sheet it loses the list or > moves it. Has anyone else had this problem and is there any way > to fix it?
There is always some formatting loss going between two applications. Calc can read and write xls formats but there still is some loss because Excel cannot understand a lot of the functionality of Calc and vise versa. There will almost always be some problems with some formulas between the two applications. There isn't a lot that can be done about it in either direction. The OOo developers work hard at trying to improve it and the MS developers work hard at trying to make even more difficult. -- http://webpages.charter.net/jlgates Microsoft users go to http://www.pclinuxos.com for a great user friendly Linux experience! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
