Does it require MS Office or LibreOffice installed? lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- Graeme · 2018-04-30 11:08 If one wants to use fpSpreadsheet, does it require an installation of MS Office (for XLS or XLSX exporting) or LibreOffice (for ODS exporting)? eg: Can I use it in a web server environment where a web interface will trigger a data export file for download, but the web server itself doesn't contain a copy of MS Office or LibreOffice/OpenOffice. Is that possible? On a side note:   Has anybody thought of making fpSpreadsheet Delphi compatible too? Regards,   Graeme ---------------------------------------------------------------------- marcov · 2018-04-30 11:27 No, it doesn't have external dependency. I started with fpspreadsheet to Delphi (XE3 then) in 2014, but didn't finish because that part of the project was shelved indefinitely.  So yes, I've thought about it. ---------------------------------------------------------------------- Graeme · 2018-04-30 11:58 Quote from: marcov on April 30, 2018, 01:27:02 pmNo, it doesn't have external dependency. Thank you that is good to know. I only briefly looked at the units included with fpspreadsheet and saw a couple of OLE named units, hence my question. QuoteI started with fpspreadsheet to Delphi (XE3 then) in 2014, but didn't finish because that part of the project was shelved indefinitely.  So yes, I've thought about it. Is there any chance you still have that work, and willing to share it?  I assume it will be a rather large amount of work as it references many FPC specific units. On a side note, our company is using XE3 too. ---------------------------------------------------------------------- wp · 2018-04-30 14:20 Quote from: Graeme on April 30, 2018, 01:08:13 pmIf one wants to use fpSpreadsheet, does it require an installation of MS Office (for XLS or XLSX exporting) or LibreOffice (for ODS exporting)? No, fpSpreadsheet is pure Pascal. QuoteHas anybody thought of making fpSpreadsheet Delphi compatible too?As for me, nor seriously. Deep in the heart of fpspreadsheet, there is an AVLTree, and AFAIK Delphi does not have this one, and I never was motivated to take the burdon of porting the AVLTree to Delphi or to replace it in fpspreadsheet by some other container type. ---------------------------------------------------------------------- Graeme · 2018-05-01 08:43 Quote from: wp on April 30, 2018, 04:20:07 pmNo, fpSpreadsheet is pure Pascal. Perfect, and very good to know. QuoteQuoteHas anybody thought of making fpSpreadsheet Delphi compatible too?As for me, nor seriously. Deep in the heart of fpspreadsheet, there is an AVLTree, and AFAIK Delphi does not have this one, and I never was motivated to take the burdon of porting the AVLTree to Delphi or to replace it in fpspreadsheet by some other container type. Yeah, I saw the usage of AVLTree, and some other FPC specific units. In a way it is fully understandable for FPC and Lazarus to have components, features and abilities which Delphi doesn't have. That could give FPC/Lazarus the edge at some point (for corporate environments). Personally I think FPC/Lazarus is already a much better product than Delphi, but that's for another discussion and another day. ---------------------------------------------------------------------- marcov · 2018-05-01 09:18 Afaik there is a generic version of avltree now based on Maciej's work. I assume that is roughly Delphi compat ? But for that to creep into everything, we will be a well into the next version cycle. ---------------------------------------------------------------------- Thaddy · 2018-05-01 12:38 Quote from: marcov on May 01, 2018, 11:18:31 amAfaik there is a generic version of avltree now based on Maciej's work. I assume that is roughly Delphi compat ? But for that to creep into everything, we will be a well into the next version cycle. Indeed, including some very useful derivatives ---------------------------------------------------------------------- hnb · 2018-05-11 13:03 Quote from: marcov on May 01, 2018, 11:18:31 amAfaik there is a generic version of avltree now based on Maciej's work. I assume that is roughly Delphi compat ? In Delphi you will not find many of collections from my implementation (including TAVLTree), also library has special property Ptr^ intended for "for in do" loops ready for smart pointers (also usefully for all managed types). The root/inspiration of Delphi implementation was .NET System.Collections.Generic. btw. especially interesting IMO is TSortedHashSet which is rather unique when you will look at standard RTL collections in other languages. I have plan to add many new collections in NewPascal soon.