Apache OpenOffice (AOO) Bugzilla – Issue 62895
conditional formating exported to .xls Excell format
Last modified: 2006-03-10 13:24:09 UTC
Hi ! i am working with some data that i need to share with somebody working only under Windows Excell so i have to export my data to Microsoft Excelle format. So i have some conditional formating in my columns which is if a letter "j" is present in the cell than there is a background color assigned to this cell one color for each column. The problem is when I save in Excell .xls Format, I loose this formating but only starting at row Nr 257. That is row 1 to 256 has the good color, but from 257 and higher the color formatting is lost. (enclosed are the 2 documents one my sxc extension and one with xls extension that i have created with OpenCalc save as Microsoft Excell format.) so that you could compare yourself. Sincerely Yours, and keep the good work
Created attachment 34654 [details] 2 files to compare zipped to reduce size (compressed under linux zip )
Hi, used OOo2.0.2 rc4 to save your sxc file and opened the resulting document with Excel 2003 and found all conditional formats working properly. So I've to close this Issue as worksforme. Frank
closed wfm