no of fonts and cells exceeding error in excel sheet.
After saving a report(containing many nos. of cells and fonts) in an excel sheet through my code, and opening it in a microsoft excel, "Too many fonts/cells" or "...maximum no of fonts have exceeded...." errors are coming and the all the fonts are not loaded.But while opening the same in Open Office, it is opening fine.
One obsevation:- after opening it in open-office and saving it as an .xls (microsoft) file, the document's size gets reduced to nearly half.And then this problem does not arise when reopening it in microsoft.
Can anyone suggest how to overcome it.Or can we do this suppressing job of Open-office through our code???