My questing may be strange (or I chose bad place for ask)...
warning! bad english area, I'm sorry...
Project idea is simple. Sometimes you have to implement spreadsheet-like behavior in your application, but you don't want to use MS Excell via COM or ActiveX either to invent you own bicycle (loosing time and money...), also you may don't want to buy some popular expensive spreadsheet component. I think it will be great to able just to synchronize your favourite UI table component with spreadsheet calculation engine and voila.
I try to make such library (spreadsheet calculation engine). Using it, you will be able to create something like small virtual Excell with several data types, calculable formulas, rows and columns inserting/removing and so on.
Finally, my question:
Does anybody need a such spreadsheet-calculating library? Will it be useless or useful?
P.S. I already have a working alpha version. Here is a sample code:
SetValueS(10, 10, L"Hello");
SetValueS(10, 11, L"extab!");
SetFormula(10, 12, L"concat(j10;\" \";k10)"); Calculate();
ReadValue(10, 12);
ExTab xtab;
xtab.SelectTable(xtab.CreateTable());
xtab.Set(1,1, 22.0f); xtab.Set(2,1, 7);
xtab.SetFormula(3,1, L"a1/a2");
xtab.Calculate();
xtab.Get(3,1);
if (xtab.ctype() == EXTAB_VALUE_FLOAT)
wcout << L"PI is " << *(float*)xtab.cval() << endl;
else
wcout << L"The result isn't float! Something strange just happened..." << endl;
A also have python sample code if you interested.