AutoHotkey Community

Hmm, good point. It didn't occur to me to go that route, but that might have been easier for me. I wasn't even aware of subclassing until I stumbled across it in your ComboX library, which gave me the idea. In the end the logic is probably the same. , but with a hotkey avoids me having to watch events and figure out which one's I need to respond to.


Thanks for the tip. I knew I'd seen this somewhere before but I haven't made time to go find it. Thanks for giving me a place to look.


And thank you for posting the various libraries you have. Without the SS control and ComboX, I wouldn't be sharing anything.

Btw, I updated the above example slightly. I didn't have #includes for SpreadSheet.ahk and ComboX.ahk, and I corrected a comment or two.

Thanks again.

The difference is that subclassing is more encapsulating, so you could reuse it, you could have multiple levels of it (so module can use it). On the other hand, module shouldn't use hotkey as user could overuse it.

Other important thing is that AHK is not that good with random queue high frequency functions like wndproc. Its best to avoid them if possible.


Dimension is system thing (i.e. SysGet). There is WInAPI to query window for existence of scroll bar.

_________________

I updated the sample program with one other thing I meant to include: enabling movement within the spreadsheet using Tab and Shift-Tab. I found it odd that this doesn't work by default, especially since it seems virtually universal among spreadsheets: tab usually moves the active cell position to the right or ends edit mode, and shift-tab moves left.

It's also useful if you're using the spreadsheet control as an enhanced grid replacement, since using tab to move between columns is intuitive, faster for data entry and much easier to do then moving your hands to the arrow keys.

The only thing I don't like about the solution is that I couldn't find a way programmatically to determine the edit control # that the SS control uses, so the code has to be edited based on the application's context. In this sample, it's Edit1. In the app I'm currently working on, it's Edit7. Any ideas how to improve it?

As a quick answer, you could select next cell and send ENTER to the control. That way you wont need to know which Edit. Alternatively you could check the detailed info of all Edits and see which one belongs to SS. It will have different parent then AHKGui or some other attribute (style for instance).

_________________

(I'm bad English. Please forgive me.)

When I tried to multi-select on SpreadSheet, also I want some change about it like colorize... I'm very awful but hard working.

So, do you need any particular help or just want to report ur success ? I am not sure....

Btw, I see some typos in your code. You have frequent "=" vs ":=" typo/error.
Also, keep in mind that using function names such as "Temp" is not a good idea even while testing. Function name should always represent what function does and nothing more and nothing less (if you can't do that, you need to redesign the function). For instance, in this case "WhitenSSRange" would be good name.

If you hope that there will be SS_ function to change range color, thats not going to happen. The function like that is too specialized to be included in the API. Somebody else might want, as an example, to change foreground color, clear selection, populate it with constants etc....

_________________

I'll remember all your advice.

Thank you very much.

Majkinetor: I've seen this control around a number of times and really just got into playing with it tonight - it's awesome! I have a lot of things I need to be able to export / display and this is going to make my life much easier, keep up the good work

_________________

Macro Everything
Lucid_Method Index

Could someone tell me where to find the source for the StdLib loader and script initializer and other functions (S Structure function) mentioned here:

http://www.autohotkey.net/~majkinetor/_/_.html#_

and in this threads first post.

EDIT:Never mind, I found them as part of the Forms Framework here:

http://www.autohotkey.com/forum/viewtop ... sc&start=0

dmatch

Magkinetor, Sorry to bother you with what seems like a newb question but I have been trying to get this SpreadSheet to work and am not having much success. I am running windows 7 64bit with AutoHotkey_L v1.1.05.1



with SprSht.dll and the script on the desktop this is my result.




What am I missing?

Thanks for any assistance you can provide.

I get the same duplicate error message when running test.

_________________
http://www.panofish.net

What happens if you change it like so ? Or it might not work with Unicode at all ...

I believe the problem is actually 3 lines earlier where params is declared as a local.


Just remove that reference on line 1083 and the error should go away.