td4stage Posted September 3, 2006 Share Posted September 3, 2006 Just wanted to keep the "noise" up regarding being able to sort editable worksheets by two colums or more. Would be VERY useful! If anybody else is in favor of this...please respond! It is probably wishful thinking for having this available in 12.5....hmmmm....speaking of 12.5...aren't we due pretty soon!...anybody?! Pat Quote Link to comment
Sam Jones Posted September 9, 2006 Share Posted September 9, 2006 If Nemetschek doesn't do it in 12.5, I will, but it will be part of AutoPlot Tools for SpotLight. I think a much better solution would be for Nemetschek to make the worksheet reports interactive with the database records they display. That way you could have as much sorting as you wanted, and you wouldn't have to run a second macro to assign the changes you've made to the lights. It would also apply to any record, so that all the users of VW would benefit. Quote Link to comment
Mickey Posted September 11, 2006 Share Posted September 11, 2006 (edited) I've mostly given up using the worksheets, because I can't sort them into any usable fashion for me. So lets hear some noise! Edited September 11, 2006 by mickey Quote Link to comment
Sam Jones Posted September 12, 2006 Share Posted September 12, 2006 Mickey, 12.5 is just out. No 2 field sorting. A 3rd party solution to that will be available shortly. Till then, you will find that you can sort Channels, Dimmers, Circuit Numbers, and Unit Numbers, by using the "Alt-" fields. This will sort the numbers correctly. The most useful sort, for now, is select all the units in one position and then make a worksheet sorted by "Alt-Unit". HTH Quote Link to comment
AndyM Posted September 16, 2006 Share Posted September 16, 2006 You can also just copy the entire sheet and paste it into Excel and do whatever you want with it. I do it all the time. Quote Link to comment
td4stage Posted September 19, 2006 Author Share Posted September 19, 2006 Thanks AutoPlot!! "Alt" sorting works but is sort of a pain. Any idea when your AutoPlot software will be ready??!!! Also, when you do a custom selection, you can save the selection as a script. I was trying to do a custom selection using "position" as a modifier...no dice! It'd be nice to be able to have "Find and Modify" create a script! So when is the new AutoPlot coming out again! ;-) Pat Quote Link to comment
MrTemplate Posted September 20, 2006 Share Posted September 20, 2006 Hi Pat; i gave up on the editable worksheet long ago. when i whined the reaction i got just didn't sound that interested in pursuing it as a useable function for us. so i just bounce it into Lightwright and be done. Quote Link to comment
td4stage Posted September 20, 2006 Author Share Posted September 20, 2006 Thats what I do to but for what I am needing, LW is like killing a fly with a sledge hammer. Edit. worksheets are *so* close! if enough of us complain maybe change will occur! Pat Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.