Auto It with opens office spreadsheets

[Jyotiranjandas]

Hello ,

I am trying to check the validation with open office spreadsheets . But its not working . Do I need to add any library file for the same. Or is it limited to microsoft excel only.

Please answer as soon as possible.

[water]

Welcome to AutoIt and the forum!
You are talking about something like _Excel_RangeValidate?

Edited August 10, 2016 by water

[Jyotiranjandas]

yes but iam getting this error:

 Error creating a new Excel application object.

@error = 1 , @extended = -2147221164

[TheDcoder]

45 minutes ago, Jyotiranjandas said:

Or is it limited to microsoft excel only.

The default library only supports Microsoft Excel because it interacts with the Excel object interface provided by Microsoft.

[water]

Please check the wiki for Open Office UDFs:

https://www.autoitscript.com/wiki/User_Defined_Functions

[Jyotiranjandas]

Thanks for the suggestions and help