Axolot Data

shayanjameel08 wrote:User functions are public static (Public Shared in VB.NET) methods that should always return a value and can take an arbitrary number of input parameters.

I'm not sure how is this related to my question.

Do I have any option to open those old xls files right now and user functions will work or I need to wait for new version. If later, when you think that will be available?

Thanks

We will only open this (old xls) files and save them in new format (xlsx). That is allowed, right?

I can confirm that. The question now is, will tat stay this way or will I be able to use user functions in Excel 97 files as well? We have existing files that were handled by some other component and now we would like to move to your component. We can not open all files and change format as those fi...

Could you please look at this issue. I can't move forward.

Thanks

Grega

I added but...

Looking at TXLSFormulaEvaluator.DoEvaluate, Sum function goes to xptg_EXCEL_97, FStack.Push, then to xptgFuncVar97 where DoFunction is called.
Same procedure for custom function goes to xptg_EXCEL_97, then to xptgInt97 where 8 is pushed to stack and finished.

I changed the demo this way: procedure TfrmMain.btnReadClick(Sender: TObject); begin XLS.Filename := edReadFilename.Text; XLS.Read; XLS[0].AsInteger[0,0] := 4; XLS[0].AsInteger[0,1] := 5; XLS[0].AsFormula[0,2] := 'SUM(A1:A2)'; XLS[0].AsFormula[0,3] := 'TEST_NUM_1ARG(8)'; end; When I press Calculate ...

I've used now OnUserFunction event but I get access. I have =MYFUNC(1) in the cell. Debug: TXLSWorksheet.GetAsFormula at step Result := FOwner.Formulas.DecodeFormula(FCells,FIndex,Ptgs,Sz,False); I get access. Going deeper I get into DecodeFmla, there is a big case and first loop gets to xptg_EXCEL_...

Is this working? I have Delphi XE and I have formula like =MyFormula(1) in the cell. When I click into the cell, I get exception. I also don't get any event for this assignment: XSS.XLS.OnFunction := MyFunction; When I call this and I debug, I step into this: procedure TXLSReadWriteII5.SetFunctionEv...

Hi Lars

On the registered users download page it says I can download 5.20.01. Is that just the wrong text? I need XE version.

Anything new on the subject?

Thanks

larsa wrote:Hello

You don't have to define user functions. Just enter them in the formula. The OnFunction event is however never fired. Will fix that in the next update.

Do you have any idea when next update will be ready? I can miss some things and move on but I can miss those functions.

I need to execute cut/copy/paste programmatically.

Sorry for all the messages, but I must replace cxSpreadSheet with this spreadsheet and I report what I see.

I don't see any option for cut/copy/paste. Are those implemented already or will be available sometime in the future?

What about undo?

Grega

Hi As far as I can understand (I haven't checked this though) there was option in older xls to define user functions. I can see OnFunction event in new version but I can't find the place where this is executed or AddUserFunction which should be used to register user function. Is this still supprted ...