[SOLVED] .xls bad under win7 fine under winXP

Forum > FPSpreadsheet

(1/1)

mirce.vladimirov:
I use Lazarus 1.0.2 on Windows7 32-bit. Since described problem apeared i downloaded the FPSpreadsheet 1.1 from source forge, but nothing changed. Here it follows.
When opening a .xls file created by FPSpreadsheet :
1.On windows XP with MSOffice2003 or MSOffice2007 it gets opened OK
2.On windows7 with Libre Office it gets opened OK
3.On windows7 with MSOffice2007 if the file is small (200-300 rows) it gets opened OK
4.On windows7 with MSOffice2007 if the file is bigger it gets opened but only numeric cells are displayed while text-containig cells are displayed empty. Errors are reported:
"Excel found unreadable content in "filename.xls". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
as seen on attached pic1.png. So here i click yes, and then file is opened but again error is reported and text containig cells are blank (entire column B and column D on pic3.png)
If i open the file by means of case(1) or case(2) and then save, and re-open under win7+MSOffice2007 then it's all right.

P.S. .ods files are all fine, no problems at all.
.xlsx files are not opened by any of the 4 combinations from above, various errors are reported. But right now I dont mind because .xlsx is not in my focus of interest rght now.

BigChimp:
What about a sample project?

The development version of fpspreadsheet in the subversion repository (see fpspreadsheet page) has some fixes. They may fix the problems you are seeing.

Have you searched the forum for reports of similar problems?

marcov:
Maybe language might also be a factor, are the Windows and office versions for the same language?

mirce.vladimirov:

--- Quote ---Maybe language might also be a factor, are the Windows and office versions for the same language?
--- End quote ---

Thank you my friends for your replies. I found this http://avemey.com/zexmlss/examples.php?lang=en which is Very nice tool for .xlsx and .ODS and I switched to that because :
-supports Cell comments
-supports Cell formating: fonts.name, fonts.size, fonts.color, alignment including horizontal and vertical alignment
-supports Column resizing
-supports Merge cells
-supports String formulas very easy (it's diferent for .xlsx and .ods, but very easy)
-supports coloring cells
-supports hyperlink inside of a cell
-supports unicode (very important to me) and god knows what other codepages
-it's open source under zlib licence (see http://en.wikipedia.org/wiki/Zlib_License)
-for those who still use delphi : includes suport all delphi from Delphi5 until latest possible version.
-for those who use C++ Builder : includes suport for that too
-it's perfectly documented
and gues what: version is stil 0.0.6 beta, not even 0.1.0 !
it only lacks support for lower versions of excel, prior to .xlsx.

Navigation

[0] Message Index