Popular Post A.D.K. Posted July 3, 2019 Popular Post Share Posted July 3, 2019 Can we please get the ability to freeze rows/columns, and the ability to edit more than one cell at a time? Thanks! 5 Quote Link to comment
0 livespace josha Posted July 3, 2019 Share Posted July 3, 2019 My two requests for worksheets: - Make the functionality and interaction more like Excell/Numbers (formulas, moving cells, merging, etc) - The ability to import, export and reference cells/columns/data from an external spreadsheet file (or have the worksheet portion of the file .vwx file separate and externally editable.) Hope I didn't hijack your thread! 3 Quote Link to comment
0 A.D.K. Posted July 4, 2019 Author Share Posted July 4, 2019 Hijack away! I'm trying to coordinate with my GrandMA fixture layer exports, and gosh darn if it ain't tedious at the moment. And the opportunity for human error is huge. Are your requests for similar reasons? Quote Link to comment
0 JMR Posted July 6, 2019 Share Posted July 6, 2019 A bit like the freeze column / row wish, I think: 2 Quote Link to comment
0 A.D.K. Posted July 8, 2019 Author Share Posted July 8, 2019 On 7/6/2019 at 1:53 AM, JMR said: A bit like the freeze column / row wish, I think: Exactly, amigo. Quote Link to comment
0 GoodPeter Posted July 12, 2019 Share Posted July 12, 2019 (edited) Dear Sir and/or Madam. I endorse this thread whole-heartedly. Ideally, at least some basic spreadsheet functionality should be present in worksheets. You should be able to cut and paste more easily, you should be able to extend a value or series of values along rows or columns (for example type 1, 2, 3, and highlight further with it automatically filling in the subsequent series - or at least it should be able to populate a single value along a column). Failing this, I believe a reasonable request would be to at the very least be able to copy and paste between worksheet and standard spreadsheet of your choice. Currently, we are halfway there - cutting and pasting does preserve values and cells from worksheet into spreadsheet. Unfortunately, cutting and pasting back the other direction results in all values being paste into ONE cell in the worksheet. - If multiple cells with the same number of rows/columns are selected when you paste, then all the source information is pasted into each one of those worksheet cells. I hope the worksheet gets the love it deserves. Edited July 12, 2019 by GoodPeter 1 Quote Link to comment
0 Amorphous - Julian Posted July 17, 2019 Share Posted July 17, 2019 Agree with the above points to: (1) freeze columns rows (2) split worksheets Further, would like to see the following: (3) use ‘Text Style’ and ‘Cell Style’ for formatting (4) increase the logic test with formula [if(a=b(c,d))] from the current 14 levels limit to at least 50 levels 1 Quote Link to comment
0 tekbench Posted July 25, 2019 Share Posted July 25, 2019 Worksheet improvements are also high on my list. I'd like a couple key items: Cut and Paste from excel should be same shape and size in the Vectorworks worksheet. Vectorworks should stretch to accept a paste that has more columns or rows than the user has set up. Rather/in addition to the 1 vs 1.1 database nomenclature, ability to change the color of database rows automatically in mixed database/worksheet documents. Make the 'create new worksheet' button a tool button rather than a disappearing button in the bottom of the resource browser that you can only find if you've selected 'worksheets' in the resource browser. At least make is show up in the resource browser when you select "All Resources". The worksheet and database functionality is a huge selling point of Vectorworks. I'd like to see some serious cycles behind it to make it a little easier on the end user. Quote Link to comment
0 Popular Post Benson Shaw Posted July 27, 2019 Popular Post Share Posted July 27, 2019 This is super basic: An update button on the worksheet. For me a big red one would be great, but almost anything is ok if I can see and access it without clicking into a dialog or menu. -B 5 Quote Link to comment
0 tekbench Posted July 29, 2019 Share Posted July 29, 2019 I'd add that Benson's proposed big red 'Update' button should also be re-labeled 'Update Active' and then a second button labeled 'Update All'. While re-calculate makes technical sense, it is very counter intuitive for an end user IMHO. Especially when there is nothing to calculate in your database. Just a long list of things. re-calculate implies that I only need that button if my worksheet is doing maths. And I do understand that it IS doing a ton of background math, just not maths that i've set up. 2 Quote Link to comment
0 Samuel Derenboim Posted July 29, 2019 Share Posted July 29, 2019 Also, is it possible to make hidden columns? (For calculation purposes, or referencing information that shouldn't appear in the worksheet for modification purposes) 2 Quote Link to comment
0 Benson Shaw Posted July 30, 2019 Share Posted July 30, 2019 (edited) 15 hours ago, tekbench said: I'd add that Benson's proposed big red 'Update' button should also be re-labeled 'Update Active' and then a second button labeled 'Update All'. Update or Recalc Active could be good. Maybe the Update All should remain hidden in a menu or dialog? It’s potentially time consuming to wait for inadvertent unstoppable multiple updates. A related idea (but way down list) is some graphical indicator of Out Of Date status. Could be barber pole border similar to Viewports, or color background. Or color text/background in the resource manager list of worksheets. Or ??? -B Edited July 30, 2019 by Benson Shaw Riffing 2 Quote Link to comment
0 Administrator JuanP Posted July 30, 2019 Administrator Share Posted July 30, 2019 Thank you for feedback, I just submitted this wish under the following: VE-99965 Even though this is an internal # and might not mean much to you all, It will help me/us to keep you all informed of any progress. 2 Quote Link to comment
0 The Anorak Posted August 29, 2019 Share Posted August 29, 2019 Hey all this is half a question and half a wishlist (as who knows the functionality might exist and I may not have found it). This is primarily for generating fixture and fitting, and furniture schedules: Is there a way to assign an image to a symbol i.e in the record format include an image function (photo from the product website) that can then be called up in the worksheet? Of course you can include a plan/elevation view of the object but this really doesn't satisfy what I'm looking for. Thanks - any help would be appreciated. Quote Link to comment
Question
A.D.K.
Can we please get the ability to freeze rows/columns, and the ability to edit more than one cell at a time?
Thanks!
Link to comment
13 answers to this question
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.