Difference between revisions of "Talk:Calc/To-Dos/Usability"
(→Highlight Row: Added Highlight ROW topic) |
(→Highlight Row: SQL-Queries) |
||
| Line 6: | Line 6: | ||
| − | = Highlight Row = | + | = Additional Feature Requests= |
| + | |||
| + | == Highlight Row == | ||
Another useful usability issue is described in greater detail in [http://www.openoffice.org/issues/show_bug.cgi?id=78181 issue 78181]. | Another useful usability issue is described in greater detail in [http://www.openoffice.org/issues/show_bug.cgi?id=78181 issue 78181]. | ||
| − | Basically, Calc should implement a '''Table View Mode''' | + | Basically, Calc should implement a '''Table View Mode''', whereupon: |
| − | * alternating rows | + | * alternating rows are coloured using two distinct and contrasting colours (light gray vs dark grey) |
| − | * the | + | * the current row (under the cursor) should be highlighted using a 3rd colour |
This would greatly enhance the readability of the table. | This would greatly enhance the readability of the table. | ||
| + | |||
| + | ADVANTAGES: | ||
| + | * vs selecting row: row remains highlighted, even IF editing a cell | ||
| + | * vs background color: NO need to change cell backgrounds | ||
Currently almost every internet site formats tables this way. Spreadsheet applications however have failed to implement this user-proven (by millions of internet users) feature. | Currently almost every internet site formats tables this way. Spreadsheet applications however have failed to implement this user-proven (by millions of internet users) feature. | ||
[[User:Discoleo|Discoleo]] 21:00, 23 July 2007 (CEST) | [[User:Discoleo|Discoleo]] 21:00, 23 July 2007 (CEST) | ||
| + | |||
| + | == SQL-Queries in Calc == | ||
| + | |||
| + | [http://www.openoffice.org/issues/show_bug.cgi?id=66588 Issue 66588] describes a very useful feature for power-users, that lets them run SQL-queries in Calc. | ||
| + | |||
| + | This borrows basically most of the MS Visual Fox Pro (VFP) functionality. As MS will NO longer develop VFP (see [http://msdn2.microsoft.com/en-us/vfoxpro/bb190293.aspx MS announcement]), this is a huge opportunity for OOo to step in and fill the vacuum. That also means, there will be revenue from this feature, too. | ||
| + | |||
| + | Please also note, that VFP had some disastrous bugs, non-standard SQL, and, for me most annoying, the terrible [http://support.microsoft.com/kb/813361 '''GROUP BY'''] ''counter-feature'' introduced in VFP 8.0. As the DB used with VFP were basically plain tables, this means that most work could be done in Calc, IF SQL-queries were implemented. | ||
| + | |||
| + | [[User:Discoleo|Discoleo]] 20:41, 25 July 2007 (CEST) | ||
Revision as of 18:41, 25 July 2007
MOVE
Should I move this wiki page to /Calc/Usability in order to structure the Calc wiki site???
Discoleo 19:23, 23 July 2007 (CEST)
Additional Feature Requests
Highlight Row
Another useful usability issue is described in greater detail in issue 78181.
Basically, Calc should implement a Table View Mode, whereupon:
- alternating rows are coloured using two distinct and contrasting colours (light gray vs dark grey)
- the current row (under the cursor) should be highlighted using a 3rd colour
This would greatly enhance the readability of the table.
ADVANTAGES:
- vs selecting row: row remains highlighted, even IF editing a cell
- vs background color: NO need to change cell backgrounds
Currently almost every internet site formats tables this way. Spreadsheet applications however have failed to implement this user-proven (by millions of internet users) feature.
Discoleo 21:00, 23 July 2007 (CEST)
SQL-Queries in Calc
Issue 66588 describes a very useful feature for power-users, that lets them run SQL-queries in Calc.
This borrows basically most of the MS Visual Fox Pro (VFP) functionality. As MS will NO longer develop VFP (see MS announcement), this is a huge opportunity for OOo to step in and fill the vacuum. That also means, there will be revenue from this feature, too.
Please also note, that VFP had some disastrous bugs, non-standard SQL, and, for me most annoying, the terrible GROUP BY counter-feature introduced in VFP 8.0. As the DB used with VFP were basically plain tables, this means that most work could be done in Calc, IF SQL-queries were implemented.
Discoleo 20:41, 25 July 2007 (CEST)
