TODO 7.31 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
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
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
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 33 34 35
   + Implement more functions :
     - AREAS and GETPIVOTDATA
       AMORDEGRC, AMORLINC, COUPDAYSNC, COUPPCD, CUMIPMT, CUMPRINC, MDURATION,
       ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, VDB, YIELD,
       YIELDDISC, and YIELDMAT.
36

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
37
   + Fix or finish the following functions :
38
     - COUPDAYBS, COUPDAYS, and DURATION
39

40
* Data Analysis Tools
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
41

42
   + Finish `Histogram' tools
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
43 44 45 46 47
   + Implement `Patterned distribution' for `Random Number Generation'
   + Implement new tools:
     - `Exponential Smoothing'
     - `Fourier Analysis' (the dialog is implemented)
   + Finish the documentation
48

Arturo Espinosa's avatar
Arturo Espinosa committed
49
* Printing
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
50 51 52 53 54 55 56 57 58

   + 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
59

60 61
* Font dialog

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
62 63 64 65 66 67 68 69 70
   + 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.
71

72
* Number formatting
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
73 74 75 76 77 78 79 80 81 82 83 84 85 86

   + 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.
87

Arturo Espinosa's avatar
Arturo Espinosa committed
88
* Sheet
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
89 90 91 92

   + Naming
     Should be possible to bind a name by typing the name on the
     region box and applying it to the selection
93
   
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
94 95 96
   + Column sizes
     Columns should have an "auto-grow-up-to-this-point" feature.  Beyond that
     size, it would truncate as it does now.
97

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

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
101 102 103
   + Cell comments
     Cell comments should be wrapped - at least so that they do not run
     off the screen.
104
   
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
105 106 107 108
   + 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. 
109

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

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

116 117
* Auditing

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
118
   + Write the sheet auditing code.
119

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
120
* Editing
Miguel de Icaza's avatar
Miguel de Icaza committed
121

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
122 123 124
   + 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
125

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
126 127 128
   + Object properties

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

   + Style
     Protection: Bloqued/Hidden.
133
     (Don't forget to update the CELL function after this is implemented)
134 135

* File Load/Save
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
136 137 138 139 140 141 142 143 144 145 146 147
   + 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.
148

149 150
* Workbooks:

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

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

* Office compatibility
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
159 160 161

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

Jody Goldberg's avatar
Jody Goldberg committed
163
* Parser
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
164 165

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

* Internals
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
168 169 170 171 172

   + When filling large regions (ie, select, enter data, control-enter),
     we are taking ages.  In those cases, we could probably:
     1. Start using speciallized allocators for Cell, ExprTree, Value.
     2. Do async rendering of cells. eg when they are being displayed or during an idle handler.
173 174

* Calculation
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
175 176 177 178 179 180 181 182 183
   + 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.
184

185
* Excel Import
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
186 187 188

   + Localise sheet/workbook Name import.
   + Import names even if they arn't referenced.
189

190
* Excel Export
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
191 192 193 194 195 196 197 198 199 200 201

   + Detect large style ranges and correctly set the default row/col/sheet styles.

1.0
===
These are features that need to be implemented before a 1.0 
release can be made. Some of these features are already being
worked on, others are partially finished. But none is finished
to an extent that it can be actually "used".
Items marked (!) are open for someone to step in.

Jody Goldberg's avatar
Jody Goldberg committed
202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221
* Graphs

   + Large parts of this are done. Most of the work related to
     this will be in Guppi (cvs module guppi3). It's needs
     to be tested tidied and generally needs love :-)

Post - 1.0
==========
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
222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257
* Global Preferences Dialog (!)
  
   + Needs to be adopted.

* Conditional Formatting

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

* Data Validation

   + This is in the works. Some other things need to be finished
     first before this can be fully implemented. The dialog is
     already there.

* 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

   + ?