IchBistTod Posted February 15, 2010 Share Posted February 15, 2010 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 but this would be cool [center][/center][center]=][u][/u][/center][center][/center] Link to comment Share on other sites More sharing options...
NerdFencer Posted February 15, 2010 Share Posted February 15, 2010 (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 February 15, 2010 by NerdFencer _________[u]UDFs[/u]_________-Mouse UDF-Math UDF-Misc Constants-Uninstaller Shell Link to comment Share on other sites More sharing options...
IchBistTod Posted February 15, 2010 Author Share Posted February 15, 2010 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] Link to comment Share on other sites More sharing options...
IchBistTod Posted February 15, 2010 Author Share Posted February 15, 2010 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] Link to comment Share on other sites More sharing options...
martin Posted February 15, 2010 Share Posted February 15, 2010 also i have it looking the way i want but i can only edit the first peice of dataYou 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. Link to comment Share on other sites More sharing options...
IchBistTod Posted February 16, 2010 Author Share Posted February 16, 2010 (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 February 16, 2010 by IchBistTod [center][/center][center]=][u][/u][/center][center][/center] Link to comment Share on other sites More sharing options...
martin Posted February 16, 2010 Share Posted February 16, 2010 (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? Edited February 16, 2010 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. Link to comment Share on other sites More sharing options...
IchBistTod Posted February 16, 2010 Author Share Posted February 16, 2010 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] Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now