Over the past few months I've been writing a little list on the side of my desk as I've hit problems or quirks. It's wishes and changes that in my opinion would make things a little better.
Worksheets:
Can't right click columns nor rows to add/delete/format.
Desired functions such as, LEN (length of resulting string), LEFT & RIGHT (character results a number of characters left or right of a string end), FIND (find within resulting string) and SUBSTITUTE (substitute within a string).
Call the rotation of an object, perhaps =ROT
Lineworking of Spreadsheet cells meeting Database cells. Often the bottom or top border of a spreadsheet cell directly meeting a database row will result in lines being added to all database row. Often this is not the desired result, perhaps checkboxed?
Formular bar only accepts 255 characters, more?
=Height and =Width to be calculated not only from the bounding box but the base object (regardless of rotation), perhaps =Height for base object originally and =_Height for the bounding box?
OR as an option in the database criteria dialog box, instead of having to open dialog, close, then edit formula.
Easily accessible function guide covering all possible functions, accessible from worksheet window.
Selecting multiple database rows and applying sorts/sums across all.
Functions for objects on annotation layers for are they on an annotation layer (T/F) and perhaps an =VP for the viewport they are contained in.
When working with a large amount of database rows open and then collapsing them it would be desired that the view returns to the bottom resulting row, not leaving the user several rows beneath with a grey table.
Worksheet open on both Sheet Layer/Design Layer and in preview window at the same time.
Moveable breaks in worksheets for split pages. When working with a worksheet of 120+ rows it no longer fits at a reasonable scale on an A1 page. It would be desired to have a method of splitting a table so it can be placed on multiple pages without needing to cover sections on each page or using multiple viewports.
-----------
That's about it for now but I encourage you all to add if you feel the need or if you have found efficient work arounds for issues I'd like to hear them. I'll keep adding to this forum set when I've tidied more of my list.
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.
Question
James Russell
Hey all,
Over the past few months I've been writing a little list on the side of my desk as I've hit problems or quirks. It's wishes and changes that in my opinion would make things a little better.
Worksheets:
Can't right click columns nor rows to add/delete/format.
Desired functions such as, LEN (length of resulting string), LEFT & RIGHT (character results a number of characters left or right of a string end), FIND (find within resulting string) and SUBSTITUTE (substitute within a string).
Call the rotation of an object, perhaps =ROT
Lineworking of Spreadsheet cells meeting Database cells. Often the bottom or top border of a spreadsheet cell directly meeting a database row will result in lines being added to all database row. Often this is not the desired result, perhaps checkboxed?
Formular bar only accepts 255 characters, more?
=Height and =Width to be calculated not only from the bounding box but the base object (regardless of rotation), perhaps =Height for base object originally and =_Height for the bounding box?
OR as an option in the database criteria dialog box, instead of having to open dialog, close, then edit formula.
Easily accessible function guide covering all possible functions, accessible from worksheet window.
Selecting multiple database rows and applying sorts/sums across all.
Functions for objects on annotation layers for are they on an annotation layer (T/F) and perhaps an =VP for the viewport they are contained in.
When working with a large amount of database rows open and then collapsing them it would be desired that the view returns to the bottom resulting row, not leaving the user several rows beneath with a grey table.
Worksheet open on both Sheet Layer/Design Layer and in preview window at the same time.
Moveable breaks in worksheets for split pages. When working with a worksheet of 120+ rows it no longer fits at a reasonable scale on an A1 page. It would be desired to have a method of splitting a table so it can be placed on multiple pages without needing to cover sections on each page or using multiple viewports.
-----------
That's about it for now but I encourage you all to add if you feel the need or if you have found efficient work arounds for issues I'd like to hear them. I'll keep adding to this forum set when I've tidied more of my list.
Cheers,
James
Link to comment
7 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.