XCELLEGEN Technologies
Excel 2007 application level add-in using VSTO (Visual Studio Tools for the Office System) 3.0.
The code layer that directly interacts with the Excel object model is written in VB.NET (about 20% of the total code).
All other code is C# (about 80% of the total code).
Development environment requires Visual Studio Professional 2008, Excel 2007, .NET Framework 3.5 SP1, and VSTO 3.0. MS Expression Blend optional for editing WPF.
Code is broken into four assemblies:
VSTO layer; a core library; WinForms library; WPF library
Data source may be either Access 2007 or SQL Server 2005 (not tested with SQL Server 2008 but am not aware of any potential issues).
An Access sample database can be upgraded to SQL Server using Access 2007. Go to Database Tools tab and select SQL Server from the Move Data group. Access queries are not moved only the tables. Queries will need to be rewritten into SQL Server views using the appropriate T-SQL syntax. (See the XCELLEGEN data source documentation for more information.)
What’s the point of this bulk of technical data?
For Calc Add-in, you only need, LibreOffice SDK and Python (you can used others languages), simple is better than complex.
Pay a developer to write a LibreOffice Calc extension according to your specs.