Sign in to follow this  
Followers 0
IchBistTod

Making a Spreadsheet like control without excel

8 posts in this topic

I want to make a spreadsheet object without having to have excel installed.

Options using .dll calls to make a control are fine, I just dont want to have to have excel installed.

Also want to know how to write data to them?

If this doesnt work out i guess i could always use a list view :mellow:

but this would be cool


[center][/center][center]=][u][/u][/center][center][/center]

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

Create a listview control with the following styles...

The result is basically an Excel-type editable data grid.

BitOR($LVS_EDITLABELS,$LVS_SINGLESEL,$LVS_NOLABELWRAP)
Edited by NerdFencer

_________[u]UDFs[/u]_________-Mouse UDF-Math UDF-Misc Constants-Uninstaller Shell

Share this post


Link to post
Share on other sites

thank you my one other question is how to make a GUI pop up when this "row" of data is double clicked?

So like to allow editing of data in the rows, but one of the fields is gonna have like multiple pieces of data....

like multiple names associated with that row.

Basically im trying to make a customized sql file viewer.

Where the data is stored in a file in sql format and then read/edited by my program, without the need for a mysql server to be running, just a db file.

so like

info | info2 | info3 | name1!name2!name3

info | info2 | info3 | name1!name2!name3

info | info2 | info3 | name1!name2

then if you double clicked on the first row it would bring up a dialouge with all that info, only that the names would be in a list view of their own

with a add/remove button to add names to the list to associate with the data.

I just need to know how to make double click show a box or do an event.

also how to change the color of each row.


[center][/center][center]=][u][/u][/center][center][/center]

Share this post


Link to post
Share on other sites

also i have it looking the way i want but i can only edit the first peice of data


[center][/center][center]=][u][/u][/center][center][/center]

Share this post


Link to post
Share on other sites

also i have it looking the way i want but i can only edit the first peice of data

You could make your own. There is an example of one I started here. Each cell is a label and you could make them multiline for more lines of data.


Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.

Share this post


Link to post
Share on other sites

#6 ·  Posted (edited)

I just need to launch a GUI with the info from that row on double click, it doesn't need to be editable from the list view as of right now.

Edited by IchBistTod

[center][/center][center]=][u][/u][/center][center][/center]

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

I just need to launch a GUI with the info from that row on double click, it doesn't need to be editable from the list view as of right now.

Have you searched for +listview+doubleclick?

No? :mellow:

Edited by martin

Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.

Share this post


Link to post
Share on other sites

Ya im sorry... I'm going quite insane.

I'm under a lot of stress, I dont think clearly.


[center][/center][center]=][u][/u][/center][center][/center]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0