AutoHotkey Community
It is currently May 25th, 2012, 7:29 am

View unanswered posts | View active topics


Board index » AutoHotkey » Scripts

All times are UTC [ DST ]



Post new topic Reply to topic  Page 1 of 8
  [ 118 posts ]  Go to page 1, 2, 3, 4, 5 ... 8  Next
  Print view | E-mail friend Previous topic | Next topic 
Author Message
majkinetor
PostPosted: June 3rd, 2007, 12:00 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade


Notes:

_________________
Image


Last edited by majkinetor on July 13th, 2010, 9:10 am, edited 58 times in total.

Report this post
Top
 Profile  
Reply with quote  
majkinetor
 Post subject:
PostPosted: June 3rd, 2007, 10:33 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade
Version 0.1

Practicaly everything is possible to set with SetCell function

_________________
Image


Report this post
Top
 Profile  
Reply with quote  
majkinetor
 Post subject:
PostPosted: June 4th, 2007, 2:30 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade
No interest/comments for this control...

Project is abandoned then :idea:

_________________
Image


Report this post
Top
 Profile  
Reply with quote  
John W
 Post subject:
PostPosted: June 4th, 2007, 2:49 pm 
Offline

Joined: April 9th, 2007, 4:43 pm
Posts: 172
Just saw it, seem´s interesting...

_________________
COMPLETELY INACTIVE - I do not use AHK anymore.


Report this post
Top
 Profile  
Reply with quote  
elchapin
 Post subject:
PostPosted: June 4th, 2007, 2:53 pm 
Offline

Joined: March 6th, 2007, 4:35 pm
Posts: 64
Location: Columbus, OH, USA
I also think it's very interesting, and I immediately started thinking of possible uses... just curious, what are you planning to do with this? :)


Report this post
Top
 Profile  
Reply with quote  
SKAN
 Post subject:
PostPosted: June 4th, 2007, 2:56 pm 
Offline
User avatar

Joined: December 26th, 2005, 4:40 pm
Posts: 8775
Awesome control!

majkinetor wrote:
No interest/comments for this control...
Project is abandoned then :idea:


Uh! Please.. The forum is unable to match your speed, I guess!

Thanks for all the good work!

:)


Report this post
Top
 Profile  
Reply with quote  
n-l-i-d
 Post subject:
PostPosted: June 4th, 2007, 3:58 pm 
No, do keep going. Did you manage to implement import/export yet? Looks interesting too.

Very cool if this control can be fully used in AHK! 8)


Report this post
Top
  
Reply with quote  
AGU
 Post subject:
PostPosted: June 4th, 2007, 4:15 pm 
If you can embed controls within this "spreadsheet control", this could possibly a solution for some kind of continous form I asked a long time ago.

When I wrote my ToDo List app I asked for a possibility like this. If was one of my first questions within this forum. :)
:arrow: http://www.autohotkey.com/forum/post-14758.html#14758

Can this control handle this?
______________________
Cheers AGU


Report this post
Top
  
Reply with quote  
majkinetor
 Post subject:
PostPosted: June 4th, 2007, 4:50 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade
Oh, thank you guys, you are gordgeous...

Quote:
If you can embed controls within this "spreadsheet control", this
could possibly a solution for some kind of continous form I asked a long time ago.

Isnt the picture clear ? Isn't the Type clear ?

You can embed only controls available in the Types list, nothing else. So this is not general container.

Quote:
Exists an GUI Element that can hold other GUI elements? It should be s.th like a endless form. Do you understand what I mean?

Of course it exists, its called Tab. You can get "endless form" if you do keep adding controls constantly ;)

_________________
Image


Report this post
Top
 Profile  
Reply with quote  
AGU
 Post subject:
PostPosted: June 4th, 2007, 5:02 pm 
Well it can hold checkbox, text and button. :D

So it seems to me like a possible solution. Sorry if these next questions sound stupid, but assuming I have a checkbox in a first column, would it be possible to do some kind of action to a text control in a second column when activating/deactivating the checkbox in the first column?

And what about user-action in general. Can these embedded controls be assigned a g-label?
_____________________
Cheers AGU


Report this post
Top
  
Reply with quote  
majkinetor
 Post subject:
PostPosted: June 4th, 2007, 5:06 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade
SpreadSheat is basicly Excell. I saw in the demo it is possible to do all Excel basic things.

So, the answer is yes. You can uncheck something and influence other cells easily.

Your handler will be called on button click, state change etc, so you can do all that is necessary manualy.

So, SS is not Excell, but it can be wrapped into Excell with some higher API that relies on low level API on this page.

_________________
Image


Report this post
Top
 Profile  
Reply with quote  
majkinetor
 Post subject:
PostPosted: June 4th, 2007, 5:10 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade
For instance:
Code:
 SS_SetCell(hCtrl, 1, 1, "type=TEXT", "txt=Caption", "bg=0xFF", "fg=0xFFFFFF")
   SS_SetCell(hCtrl, 2, 4, "type=CHECKBOX", "data=1", "imgal=CENTER", "sub=OnChange")


OnChange:
  SS_SetCell(hCtrl, 1, 1, "txt=Control is changed")
return


This little code creates 2 cells one to have check. WHen you check it, it will change cell AA1 (1,1).

Red code is still not implemented.

_________________
Image


Report this post
Top
 Profile  
Reply with quote  
olfen
 Post subject:
PostPosted: June 4th, 2007, 5:26 pm 
Offline

Joined: June 4th, 2005, 1:30 am
Posts: 113
Location: Stuttgart, Germany
Very impressive! I'm looking forward to using this.
Also thanks for your great work on the other custom controls!


Report this post
Top
 Profile  
Reply with quote  
n-l-i-d
 Post subject:
PostPosted: June 4th, 2007, 7:08 pm 
Just for information: Link to the original with examples

Screenshot of the SprDemo.exe

Image

It can even convert a formula to graphics! And, it can save and import to spr-file. Amazing possibilities for the size.

Would be very cool if we could fully use it with AHK! :wink:


Report this post
Top
  
Reply with quote  
majkinetor
 Post subject:
PostPosted: June 5th, 2007, 12:44 pm 
Offline

Joined: May 24th, 2006, 2:49 pm
Posts: 4511
Location: Belgrade
v0.2

Many new functions added - total count 29.

Acctually, almost everything is implemented but you can not access everything as I didn't find the way to interface some things yet...

The good thing is that SS can even be used for dynamic calculus as it supports Formula type for which you send CALCULATE message

Some examples from the demo code. Fairly trivial to xtend SetCell function to support this:

Code:
dtCellFloat      dt 1.2345
szCellFormula1      db '(AA6+AA7+2)*3',0
szCellFormula2      db 'Sin(Rad(45))',0
szCellGraph      db 'Grp(T(-1,0,0,Rgb(0,0,0),"Graph Demo"),X(0,PI()*4,0,1,Rgb(0,0,255),"x-axis"),Y(-1.1,1.1,0,0.5,Rgb(255,0,0),"y-axis"),gx(AJ1:AJ13,Rgb(0,0,0),"Cell values"),fx(Sin(x()),0.1,Rgb(255,0,255),"Sin(x)"),fx(x()^3-x()^2-x(),0.1,Rgb(0,128,0),"x^3-x^2-x"))',0



About fonts:

There are 16 slots for user fonts.
U create font by using SS_SetFont(hCtrl, idx, pFont)

U set the font for given cell with SetCell using fnt named parameter which u set to font index you want to use.

One other major thing is missing. SetGlobal.
This sets defaults for everything (row height, widht, colors etc..). This is currently possible to do per cell basis only.

_________________
Image


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 8
  [ 118 posts ]  Go to page 1, 2, 3, 4, 5 ... 8  Next

Board index » AutoHotkey » Scripts

All times are UTC [ DST ]

Who is online

Users browsing this forum: nightson, sks, Yahoo [Bot] and 14 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group