AutoHotkey Community

2 toralf
Now, all bugs in control are fixed. The latest updates made able to do some Properties APIs I didn't succeed so far. I only wait to see reaction on 3 things I asked and control will be perfect for everything and I will finish properties module after that in several hours !

Also some pending features will come nice with Prop API:



This will make able to show picture for Button or Picture control inside properties

Perhaps some ppl can help KetilO with this :



You got the control for free, this is fairly trivial to do, and you can support author this way.

_________________

new version

Great new updates. Most of them I requested and KetilO implemented.



Those black things really made a difference.

New 2 functions:


Fast fucntions to get cell string and data, the same functionality is available via GetCell but those will extract only data and text info, so much faster for looping and more extensive usage.

_________________

Where is the link to 0.0.1.4.96 version, please ?

Why everybody ask such questions ? Link is always in the first post.

_________________

Sorry but the link in the first page point to a "SpreadSheet.rar" file, without version number to be sure that the version in the first page is the last one. Thanks to confirm, as the link to the last version is not necessary always in the first page.

majkinetor,


Great contribution to the product and thanks in advance for your help. I'm having a bit of trouble getting multiselect to work with with ctrl-leftclick (similar with how you'd select multiple cells from an excel spreadsheet). In the examples you've posted, I'm only able to multiselect connected cells with shift-leftclick or by left-click and dragging my mouse.

Ultimately, I'd like to be able to use this to allow someone to select multiple options from a grid for inputs into a function. This method of multiselect is necessary if I want the user to be able to select A1 and say C4 values.


Cheers. Z

Thank you majkinetor for sharing this.
I've been searching for an extremely customizable spreadsheet alternative to Excel for basic spreadsheet work (and what's more customizable than getting to program the interface yourself? :D).

_________________
-m35

FYI: There is a newer version of the SprSht.dll available.

Question: can you add support for images?

_________________
mirror 1 • mirror 2 • mirror 3 • ahk4.me • PM or

Any news about images on cells?

Yes, it can be done

I just don't have any particular interest in doing so, perhaps somebody else can do it.

About latest version, after some longer conversation with KetiO, I give it up updating the module to the new version of control. I can't make ComboBox control work anymore. This is due to the changes this control had in last version.

So, thats the reason, I didn't update the module, while it would be very good to do so as latest version has better features and it looks complete too me.

In fact, I would like to use your spreadsheet module to check cells. Is it possible to use a handler so that if I click left or right on a cell, it can fill the cell with a special caracter?
I would like also a context menu to appear if possible.

I saw the function SS_SetHandler in the code but I don't know how to use it and if it can really be used for this.

You have 3 options

• Do it yourself, there is obvious sample in _Test.ahk (SetHandler)
• Ask in Ask For Help forum, somebody with solid knowledge of AHK can help you
• Wait for another sample, that I will do in near future.

Thanks for your answer.
Maybe I'm an idiot, but where is the _test.ahk file?

Thanks for your work on this control, Maj. Did you ever happen to figure out how to get float values from a cell?

Updated with documentation.
Removed legacy code (i.e. InsertInteger and friends).

_________________