#9624: TDE Visual Enhancements - more like a spreadsheet

SachinPrakash reported 2013-07-18T22:08:01Z · last modified 2018-03-12T22:01:42Z

TDE Visual Enhancements - more like a spreadsheet

Dev
QA

Priority	Major
Complexity	Unknown

Component	Tools - Table Data Editor
Version	Future - PM

When a cell has focus, instead of coloring the inside of the cell and changing the text color, color only the outline of the cell. (See Google xls as an example)
When multiple cells are selected, then do highlight the inside of the cell but use a light color (light aqua color) so that the color of the text does not have to be changed (see google xls)
- Still always show the current cell highlighted in a slightly darker border color
Similar to an xls, when I select a cell or multiple cells, the bottom right hand side of the last cell has a visible square notation. This lets me do a "fill" operation with the selected data. Support this in our TDE
- For numbers, support auto-incrementing like an xls does (support?)
- For dates, recognize the pattern and increment appropriately (support?)
When I right click on a cell, remove the "Insert, Delete, Clone" options. Remove "Clear selected ..."
When I right click on a row number, use the following options
- Insert x above (where x represents the # of rows highlighted)
- Insert x below (where x represents the # of rows highlighted)
- 1 row selected: Delete row. >1 selected: Delete rows <row #> - <row #>
- Clone x below (where x represents the # of rows highlighted)
- 1 row: Undo Delete row. >1: Undo Delete rows <row #> - <row #>
- Show copy and paste
- Don't show any other options
When I right click on a cell (or a set of cells), rename "Clear Changes in Selected Cell(s)" to "Undo Cell Changes"
When I right click on a cell, remove the "Find" and "replace" related actions.
Remove the "Fill" menu actions from right click.
Move "Fill" from Edit menu to its own top level menu
Move "Find" related items from Edit menu to its own top level menu
Move "Set Cell...." related items from Edit menu to its own top level menu called "Set Content "
Rename "Set Cells to NULL" to "Set to NULL"
Rename "Set Cells to Zero Length" to "Set to Zero Length"
Rename Insert GUID to "Set to GUID"
Rename Insert Current Date/Time to "Set to Current Date/Time"
Rename Insert Current Date Only to "Set to Current Date, No Time"
Edit in Window
- Remove from top level menu and right click menu
- When I highlight a single cell and only a single cell, show a little ... icon that when clicked, brings up the "Edit in Window" action
View Results In ....
- Remove from right click menu
- In File menu, add an export to excel option
Rename View Cell In ....
- to ???
- Do we want it as right click option?
Remove "AutoFit Column Width" from right click menu
- Similar to an xls, when I double click on a column header's edge, autofit should be applied
- When I right click on a column, add an AutoFit option
For MongoDB
- When I right click on a column, give me the option to create new columns and remove columns, similar to google xls.
For DBs that have a data type of variant, introduce a "Format" top level menu option
- Move the existing right click format menu options to this top level menu
- Remove the existing right click format menu
Value type & Pattern
- If I have multiple cells selected, remove the Value Type & Pattern
- If I have a single cell selected, rename Value Type to "Cell Data Type".
- Only display "Pattern" if applicable, based on data type. Do not display the word "Pattern" if not applicable to data type
- Change Pattern display so that it doesn't display things like #############. Follow something like what we do in Results Format where we limit the number of # displayed.

All Comments (0) Change History

Search Tips

Aqua Data Studio / nhilam

TDE Visual Enhancements - more like a spreadsheet

Issue #9624

Completion

Search Tips

Aqua Data Studio / nhilam

Title

TDE Visual Enhancements - more like a spreadsheet

Issue #9624

Completion