TODO 6.03 KB
Newer Older
Arturo Espinosa's avatar
Arturo Espinosa committed
1
-*-outline-*-
Arturo Espinosa's avatar
Arturo Espinosa committed
2

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
3 4 5 6
Gnumeric Spread Sheet task list
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

The bugs are listed in a separate file -> BUGS
7

Jody Goldberg's avatar
update  
Jody Goldberg committed
8 9 10 11
Project
    - Switch hard coded states on SAX in to use dynamic 
    - add a parallel i/o mechanism for SAX based i/o to sheet object
    - a SAXOut struct and utils as a wrapper for FILE/gnome-vfs & indent info
Jody Goldberg's avatar
Jody Goldberg committed
12
    - xml_sax out using ^^
Jody Goldberg's avatar
update  
Jody Goldberg committed
13

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
14 15 16 17 18

Optimizations, Polish and Extensions
====================================
This section lists various optimizations/extensions that can be done
to features that already work.
Arturo Espinosa's avatar
Arturo Espinosa committed
19

20
* Component
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
21 22 23

   + Remove the hard-coded workbook hooks from the sheet.
     Initialize the hooks on the workbook_new routine.
24

Arturo Espinosa's avatar
Arturo Espinosa committed
25
* Cell editing
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
26 27

   + Colouring a parsed formula for editing.
Jody Goldberg's avatar
Update.  
Jody Goldberg committed
28

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
29
* Functions
30

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
31 32
   + Implement more functions :
     - AREAS and GETPIVOTDATA
jpekka's avatar
jpekka committed
33
       ODDFYIELD, and VDB.
34

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
35
   + Fix or finish the following functions :
jpekka's avatar
jpekka committed
36
     - ODDFPRICE, ODDLPRICE, ODDLYIELD, XIRR, XNPV, YIELD, and YIELDDISC.
37

Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
38
* Data Analysis Tools
39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
  - Exponential smoothing
    + Implement standard errors
    + Chart output
  - Histogram
    + Chart output
  - Moving Average:
    + Chart output
  - Random number generation
    + Implement patterned distribution
    + Random Seed input
  - Regression
    + Residuals
    + Standardized Residuals
    + Residual Plots
    + Line Fit Plots
Jukka-Pekka Iivonen's avatar
Jukka-Pekka Iivonen committed
54

Arturo Espinosa's avatar
Arturo Espinosa committed
55
* Printing
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
56 57 58 59 60 61 62 63 64

   + Preview
     - Stroke support for zoom etc.
   + Print setup: 
     - Options buttons
     - Improve layout 
   + Add the missing options to the Print Dialog
   + Display printing status (pages to go).
   + Add column/row title printing
Arturo Espinosa's avatar
Arturo Espinosa committed
65

66 67
* Font dialog

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
68 69 70 71 72 73 74 75 76
   + Get the list of *valid* fonts from GnomePrint
   + Filter font list by font encoding.
   + Create a simplistic dialog (to map to font-bold yes/no).

* Cut&Paste

   + when cuting & pasting a cell that is inside a range on another cell grow
     the range of the formula if the cell is pasted in a place where it grows
     it boundaries.
77

Miguel de Icaza's avatar
Miguel de Icaza committed
78
* Number formatting
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
79 80 81 82 83 84 85 86 87 88 89 90 91 92

   + FIXME : The formating is incomplete.
     - It does not support seconds fractions.
     - It incorrectly accepts mmm:ss as some sort of minute spec.
     - Add/remove decimal buttons on the toolbar are screwed for
       items with different formats for negatives.
     - There is too much replicated code for generating formats
       and recognizing them in the format dialog.

   + TODO :
     - Too much parsing is taking place when formating.  We should
       have set all that up beforehand when the format was parsed.
       A methodology similar to that used by the regexp compiler should
       be used.
93

Arturo Espinosa's avatar
Arturo Espinosa committed
94
* Sheet
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
95 96 97 98

   + Column sizes
     Columns should have an "auto-grow-up-to-this-point" feature.  Beyond that
     size, it would truncate as it does now.
99

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
100 101
   + Cell data entry
     double click on cell allows editing as in main editing box.
102

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
103 104 105
   + Cell comments
     Cell comments should be wrapped - at least so that they do not run
     off the screen.
Jon Kåre Hellan's avatar
Jon Kåre Hellan committed
106
   
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
107 108 109 110
   + Headers for Columns and Rows
     The captions should be customizable, ie instead of "A1", it should
     be possible to display "Sales".  We can use this with Michael's
     name support. 
111

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
112 113 114
   + Captions (ItemBar)
     It should be possible to set the dimensions of the cols, rows to
     contain information as "min_points", "max_points".  
115

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
116
     Interesting side effect: min_points == max_points means "fixed". 
117

118 119
* Auditing

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
120
   + Write the sheet auditing code.
121

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
122
* Editing
Miguel de Icaza's avatar
New:  
Miguel de Icaza committed
123

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
124 125 126
   + Object Clipboard
     If sheet->mode is OBJECT_SELECTED cut/copy/paste should operate on
     the object.
Miguel de Icaza's avatar
Miguel de Icaza committed
127

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
128 129 130
   + Object properties

   + Objects
131
     Load / save of Bonobo objects.
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
132

133
* File Load/Save
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
134 135 136 137 138 139 140 141 142 143 144 145
   + Support for popular formats.  
     I have the specs for the XS3 format.  SC should be
     trivial to support as well (from the guile sources)
   + star office, kspread ?
   + Add "hints" to the file save routine based on the registered
     formats.
   + Supply default extension to use with a write operation.
   + Improve handling of unknown fonts and functions when importing.

* Unicode

   + Support throughout Gnumeric.
146

147 148
* Workbooks:

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
149 150
   + Consider addition of a cursor warping operation to jump between
     open workbooks.
151

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
152 153 154
   + Notebook
     - Decrease flicker when paging between sheets.
     - Enable capability to select multiple sheets.
155 156

* Office compatibility
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
157 158 159

   + Write an XML plugin to output 'Publish as Web' style XML for
     Office 2000 and 'explorer' compatibility.
160

Jody Goldberg's avatar
Jody Goldberg committed
161
* Parser
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
162 163

   + fully support R[-1]C[3] type references.
164

165
* Calculation
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
166 167 168 169 170 171 172 173 174
   + Rework 'Name' dependencies so we can re-express names.
   + Dependancies for - CELL, INDIRECT functions.
   + Implicit iteration.  For an array expression that returns scalar results.
     which takes a range as a scalar argument, apply the expression to each element
     of the input range.

   + Make checks for inserting rows/cols more intelligent in the face of multiple selections.
     Currently it just checks the first selected range for infiniteness we need to check all
     selected ranges.
Jody Goldberg's avatar
Jody Goldberg committed
175

176
* Excel Import
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
177 178

   + Localise sheet/workbook Name import.
179

Jody Goldberg's avatar
typo.  
Jody Goldberg committed
180
1.1
Jody Goldberg's avatar
update  
Jody Goldberg committed
181 182 183 184 185 186 187 188 189 190 191 192 193
==========
These section lists features that are for post 1.0 versions
and are mostly just ideas or things that can't be implemented
yet (on short term) for technical reasons. Feel free to step in
and try to implement them, but remember that the things listed
under "1.0" are more important.

* Page Borders

   + These are border that should be visible on the sheet and
     indicate where new pages start when printing. Jody has been
     doing work on this.

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218
* Conditional Formatting

   + Conceptual progress being made, nothing concrete yet.
    Very tightly coupled with Data Validation, see below.

* Pivot Tables (!)
  
   + Needs to be adopted. Look at other implementations of this
     feature to get an idea what needs to be done.

* Scripting (!)

   + Needs to be adopted.

* Function Documentation
  
   + There is some function documentation already, but
     it's incomplete.

* Subtotals

   + This will really need to wait for a while.

* Autofilter

219 220 221
   + Most of the major elements are there to support in place
   filters.  All we'd need is a new Dependent type to manage the
   filter results.