If you cannot fix the issue this way: please give an exact step-by-step description of what you are doing so that i can reproduce the issue.
I am attempting to make use of FPSpreadsheet, however, I keep running into a problem displaying data - basic test
1 new project
2 add a tsWorkBookSource, set SourceFile name - gives error due to sfUser being the default format setting!
3 add a tsSpreadsheetInspector - displays details for the specified source file.
4 add a tsWorksheetGrid - yields a Range Check Error (see attached screenshot)
Any ideas on what the problem really is?
Sorry, I thought I had - please see the original post.Of course, I followed your first post. But I cannot reproduce the bug with it, and I tried to explain why this cannot work because the package no longer has fpsallformats in its "uses". I am also referring to your later post saying that you see the bug at runtime which i cannot reproduce either. Therefore I am asking for more detailed step-by-step instructions of what you are doing.
How can you open a spreadsheet file at design time? This used to work, but I removed the unit fpsAllFormats from the uses clause of the fpspreadsheetctrls to avoid linking all readers/writers into your program automatically, and since that time, the IDE does no longer have access to the reading/writing code to open spreadsheets at designtime.
This must be changed. A crash is not acceptable.
Unfortunately there are two conflicting reqirements.What is more important?
- Being able to view spreadsheet files at designtime? This means that all readers/writers must be linked to the visual controls automatically.
- Link only the formats which are needed by your application? This means that you must add the reader/writer unit(s) manually, and the files can be accessed only at run time.
Alternatively, I could split the visual package into a runtime and designtime package. In fact, this would be the correct way to have both options. But installation of fpspreadsheet would be a bit more complicated.
1. Still have the same problem if I open file at designtime :- hourglass (mouse pointer) keep appearinf AND IDE after a while.Sorry, no idea what this could mean... "keep appearinf AND IDE"? Please write down every step you do
1. Still have the same problem if I open file at designtime :- hourglass (mouse pointer) keep appearinf AND IDE after a while.Sorry, no idea what this could mean... "keep appearinf AND IDE"? Please write down every step you do
With 6470 revision of fps, I haven't any problem with your steps. I use "old" format excel, so I need add to uses line: fpsallformatsI dont think there is any problem with the excel file because I tested it with a blank new worksheet (.xlsx) which you also can create ;-)
Possible wp master solved this problem meanwhile, but good idea if you attach the problematic excel file.
No luck. Everything working correctly here. Only when I compile and run I get the error that the reader is not found - but this is clear because I did not add the unit to "uses". After adding xlsBiff8, the program runs correctly.The compiled exe does not has any problem (requires fpsallformat to uses clause in the source). The problem only occurs in designtime and only after I set the filename in the object inspector.
I assume that you are using fpspreadsheet trunk. After updating from svn did you perform a clean rebuild of the IDE? Normally this is not necessary. But one of the recent revision had a drastic change in the fpspreadsheet packages. So, please, go to "Tools" > "Configure Build Lazarus", in the "Clean-up" box select "Clean all" and "Switch after building to automatically". Then "Build".