fpspreadsheet problems lazarus / 5-Lazarus Extra Components ---------------------------------------------------------------------- tjstew · 2009-11-01 20:34 I have been trying to get up to speed with fpspreadsheet which is a very useful component.  But I have had two niggling problems which I don't understtand.  Any help is welcome 1. When I try to access the CHM file listed in the wiki, I see the contents list, but in the description box just the message "Navigation to the webpage was canceled" (indicating I should retype the address.  So I can't get any descriptions 2. When I write to and xls file that already exists I get some some sort of access violation error.  I can get round this by first deleting  the file, but that seems a bit of a nuisance Thanks Theo Stewart ---------------------------------------------------------------------- felipemdc · 2009-11-04 20:58 Quote1. When I try to access the CHM file listed in the wiki, I see the contents list, but in the description box just the message "Navigation to the webpage was canceled" (indicating I should retype the address.  So I can't get any descriptions Strange, which operating system do you use? Quote2. When I write to and xls file that already exists I get some some sort of access violation error.  I can get round this by first deleting  the file, but that seems a bit of a nuisance This was on purpose, as to avoid overriding files by mistake. I will add a property to set this latter. Better would be if you post a bug report so that I don't forget this. ---------------------------------------------------------------------- tjstew · 2009-11-05 20:13 Thanks ... I have Windows XP.  The problem with the CHM file occurs either when I open n Internet Explorer or download the CHM for local use. Quote 1. When I try to access the CHM file listed in the wiki, I see the contents list, but in the description box just the message "Navigation to the webpage was canceled" (indicating I should retype the address.  So I can't get any descriptions Strange, which operating system do you use? ---------------------------------------------------------------------- tjstew · 2009-11-05 20:18 But, sorry ... as a "newbie", I can't see how to post a "bug report" Quote2. When I write to and xls file that already exists I get some some sort of access violation error.  I can get round this by first deleting  the file, but that seems a bit of a nuisance This was on purpose, as to avoid overriding files by mistake. I will add a property to set this latter. Better would be if you post a bug report so that I don't forget this. [/quote] ---------------------------------------------------------------------- mica · 2009-11-05 20:44 QuoteBut, sorry ... as a "newbie", I can't see how to post a "bug report" http://bugs.freepascal.org/view_all_bug_page.php?project_id=1 ---------------------------------------------------------------------- tjstew · 2009-11-07 13:49 On second issue, I have posted the suggested bug report. On the first point, I have opened the CHM file included in the zipped file (the problems were in accessing the CHM by the web link on the Wiki).  I was then disappointed to find that there was no description of fpspreadsheet functions.  I do find it difficult to understand exactly what is happening by just examining the fpspreadsheet.pas file.  Is there an easily accessible description of the functions? But thanks to all. Quote from: sekel on November 04, 2009, 09:58:32 pmQuote1. When I try to access the CHM file listed in the wiki, I see the contents list, but in the description box just the message "Navigation to the webpage was canceled" (indicating I should retype the address.  So I can't get any descriptions Strange, which operating system do you use? Quote2. When I write to and xls file that already exists I get some some sort of access violation error.  I can get round this by first deleting  the file, but that seems a bit of a nuisance This was on purpose, as to avoid overriding files by mistake. I will add a property to set this latter. Better would be if you post a bug report so that I don't forget this. ---------------------------------------------------------------------- felipemdc · 2009-11-08 19:28 Quote from: tjstew on November 07, 2009, 02:49:22 pmOn second issue, I have posted the suggested bug report. Implemented, see the bug report. QuoteOn the first point, I have opened the CHM file included in the zipped file (the problems were in accessing the CHM by the web link on the Wiki). Which Zip file? In source-forge? That's probably very old (I don't even remember having put there), you should use the latest files from subversion. In subversion is the CHM file, which I downloaded following the link in the wiki and worked in my Windows XP. I don't know why it doesn't work for you, but it works for me. Maybe your download was corrupted? Anyway, the CHM is generated automatically by reading the comments in the source code and all routines from the most important classes like TsWorkbook and TsWorksheet are described in the CHM files, and you can read the same description in the source code in the file fpspreadsheet.pas from subversion There are also the examples files to follow. You could also describe what you are trying to do so that I can say how to do it. ---------------------------------------------------------------------- tjstew · 2009-11-18 20:25 Hi ... Just to say thanks to the responses from sekel. I only have occasional times to experiment with the software, maybe once in a week or two.  I'll try  to read the comments in the PAS file, and will post any further questions I have.  But I appreciate your effort Quote from: sekel on November 08, 2009, 08:28:07 pmQuote from: tjstew on November 07, 2009, 02:49:22 pmOn second issue, I have posted the suggested bug report. Implemented, see the bug report. QuoteOn the first point, I have opened the CHM file included in the zipped file (the problems were in accessing the CHM by the web link on the Wiki). Which Zip file? In source-forge? That's probably very old (I don't even remember having put there), you should use the latest files from subversion. In subversion is the CHM file, which I downloaded following the link in the wiki and worked in my Windows XP. I don't know why it doesn't work for you, but it works for me. Maybe your download was corrupted? Anyway, the CHM is generated automatically by reading the comments in the source code and all routines from the most important classes like TsWorkbook and TsWorksheet are described in the CHM files, and you can read the same description in the source code in the file fpspreadsheet.pas from subversion There are also the examples files to follow. You could also describe what you are trying to do so that I can say how to do it.