View source for 2008 Q2 Review of Spreadsheet Project

From Apache OpenOffice Wiki

← 2008 Q2 Review of Spreadsheet Project

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

---

You can view and copy the source of this page.

= Review of the OpenOffice.org [[Spreadsheet]] project (April/May 2008) = == Review schedule == * start of review: April 28th * review of collected issues: May 5th, 3pm UTC, #ooocalc on freenode * start of sorting priorities and assignments May 5th * review of final list: May 13th, 3pm UTC, #ooocalc on freenode == Status of the project == === what are the most severe issues in the current release === High voted issues April 2008 (all types - defects, features, enhancements): # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8302 8302]: (111 Votes) Want to be able to insert into the middle of merged cells # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: (75) Spreadsheet Sheet Labels (change Color and Font) # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: (71) Engineering Notation # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: (61) Autofilter works just on one sheet (only one auto-range per # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=30215 30215]: (57) Further thoughts on row limits # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]: (55) R1C1 notation for the spreadsheet # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=21280 21280]: (50) Automatic Insert (shift down or shift right) of cells, colum # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=2131 2131]: (47) Ability to merge cells already merged # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15773 15773]: (45) Currency symbol left justified, while amount right justified # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: (44) Cell notes do not move when cells are sorted in Calc # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=35579 35579]: (42) Standard filter requires more options.. # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=6087 6087]: (40) ODF: Allow all characters in sheet names # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: (38) Copy multiple seperated rows # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=22762 22762]: (33) Page preview for Selection # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33723 33723]: (31) Ability to turn off Number Recognition in Calc # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5658 5658]: (24) Spreadsheet thinks a number is a string (text) # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=87970 87970]: (22) Hebrew Characters in Spreadsheet Names Became Misdisplayed # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=38494 38494]: (21) Copy/Paste numbers from Writer to Calc: decimal separator in # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]: (19) DataPilot: allow more than 8 data fields # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=3687 3687]: (18) Make CSV import/export filter settings persistent (e.g. the === which are the most requested (or needed) features (in the press, user forums, issues, other feedback) === The following ux-ctest issues have been recorded during usability sessions. # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60408 60408]: Sum Icon in Calc not Found: [http://specs.openoffice.org/calc/ease-of-use/sum_button_enhancements.odt Specification] # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60403 60403]: Edit menu: Expected menu command to duplicate sheets # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60402 60402]: German terminology in context menu for sheet controls could be misunderstood # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60400 60400]: Spreadsheet handling wording table vs. spreadsheet # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60399 60399]: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header The following issues have been recorded during expert talks with customers. # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=969 969]: Auto-Correct on leaving cells does not work # Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=66484 66484]: Missing Range Chooser Issue # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5432 5432]: F4 should repeat last command # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]: Color chooser do not show latest color # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]: [http://specs.openoffice.org/calc/features/Print_Output_Scaling_Factor.odt]: Print Output Scaling Factor Usability problems # {{Bug|87999}}: (11 votes) In "standard" data type CSV import should never convert items with one dot to dates :: Users very often struggle with this problem. Some issues from the issue tracker: {{Bug|6315}} {{Bug|7606}} {{Bug|13156}} {{Bug|18458}} {{Bug|20804}} {{Bug|23024}} {{Bug|25201}} {{Bug|31326}} {{Bug|59339}} {{Bug|65142}} {{Bug|67813}} {{Bug|69097}} {{Bug|72449}} {{Bug|82196}} {{Bug|88243}}. They are all closed as "worksforme" or "invalid" or "duplicate", but they show that the import of CSV files needs improvement. The issue is related to {{Bug|33723}} but not the same. == short term planning == === which defect needs to go into the next release === None at the moment, but we agreed to be flexible for any incoming new issues if any, especially those with patches. === which features will be worked on for the half year === # ODFF formula changes # Excel 2007 import # Calc collaboration (extend change tracking for formatting and attributes) # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=14893 14893]: (3) Excel displays Grid lines on a per sheet basis, Calc on a per document basis # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=85305 85305]: (1) Dynamically grow a filtered range for autofilter, standard filter, and advanced filter # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=86856 86856]:Show Formula Syntax in tip help. # Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]:Adding scaling factor on page preview in calc. === which issues needs an assignment === == mid/long term planning == === which features/bugfixes needs to be addressed in the next two/three years === === unassigned feature/bugfixes === === long-term suggestions === #; separate functional units: #* split Calc into 2 functional units / separate applications #* one broad '''table/canvas''' application for general users, similar to [http://www.apple.com/iwork/numbers/ Apple's Numbers] #* one application focused on '''professional spreadsheet''' users #*; # '''general use:''' #* modalities for easier and more productive table input: a lot of brainstorming needed #*; professional users would benefit as well #** create input templates, e.g. see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingcheckboxesandsliders_20070807_640x360.mov Apple's iWork tutorial] and any decent statistical application (e.g. [http://www.cdc.gov/epiinfo/ Epi Info]) #** data validation #* ease table formatting: #** [http://www.openoffice.org/issues/show_bug.cgi?id=78181 issue 78181] and Apple's iWorks Tutorial [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_customizingtables_20070807_640x360.mov movie 1] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingtablesheadersfooters_20070807_640x360.mov movie 2]: table styles, striped tables, highlight current row, headers and footer rows (results row) #** advanced canvas formatting: #*** add various elements/objects to spreadsheets, see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov iWorks tutorial] and [http://www.openoffice.org/issues/show_bug.cgi?id=83767 issue 83767: Company Logos] #*** merge Draw-features into the spreadsheet application (see previous iWorks tutorial) #* ease and implement automatic analysis features (very basic ones - like correct descriptive statistics) #** [http://www.openoffice.org/issues/show_bug.cgi?id=89980 '''SUMMARY()'''] function: compute automatically all needed results for descriptive statistics purposes and export results adapted as for publication needs (e.g. in academic settings)(see also the discussion on the [http://lists.oasis-open.org/archives/office-comment/200806/msg00003.html OASIS mailing list]) #*; # '''professional use:''' #* catch numerous errors by implementing strong typing: see [http://www.openoffice.org/issues/show_bug.cgi?id=79924 issue 79924] #* prepare for multidimensional spreadsheets / OLAP functionality: #** split table into functional layers #** separate data layer from formula layer (see next section: multidimensional spreadsheets) #** separate general definitions of constants, variables, and names into a separate spreadsheet header: see [http://www.openoffice.org/issues/show_bug.cgi?id=67499 issue 67499] and [http://www.openoffice.org/issues/show_bug.cgi?id=66886 issue 66886] #** separate spreadsheet and table headings from data layer: see [http://www.openoffice.org/issues/show_bug.cgi?id=83767 Company Logo] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov Apple's iWorks tutorial] on adding various elements to the canvas #** separate results from Data Layer: issue not yet filed #* implement multidimensional spreadsheets: see [http://www.openoffice.org/issues/show_bug.cgi?id=85825 issue 85825] [[Category:Calc]] [[Category:To-Do]] [[Category:Releases]]

Return to 2008 Q2 Review of Spreadsheet Project.