TODO 8.83 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

   + Support for entering multi-line cells, and <Alt-Enter> adding an
Jody Goldberg's avatar
Jody Goldberg committed
28 29
     embedded newline.

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
30
   + Colouring a parsed formula for editing.
Jody Goldberg's avatar
Jody Goldberg committed
31

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
32
   + C-Insert: Copy, S-Insert: Paste, S-Delete: cut; test.
33

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
34
* Functions
35

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
36 37 38 39 40
   + Implement more functions :
     - AREAS and GETPIVOTDATA
       AMORDEGRC, AMORLINC, COUPDAYSNC, COUPPCD, CUMIPMT, CUMPRINC, MDURATION,
       ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, VDB, YIELD,
       YIELDDISC, and YIELDMAT.
41

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
42
   + Fix or finish the following functions :
43
     - COUPDAYBS, COUPDAYS, and DURATION
44

45
* Data Analysis Tools
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
46 47 48 49 50 51 52

   + Finish `Anova: Two-Factor With Replication' and `Histogram' tools
   + Implement `Patterned distribution' for `Random Number Generation'
   + Implement new tools:
     - `Exponential Smoothing'
     - `Fourier Analysis' (the dialog is implemented)
   + Finish the documentation
53

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

   + Preview
     - Stroke support for zoom etc.
   + Print setup: 
     - Options buttons
     - Improve layout 
     - Provide preview of the headers/footers
     - Make sure scaling works.
   + Add the missing options to the Print Dialog
   + Display printing status (pages to go).
   + Add column/row title printing
   + Patterns.
Arturo Espinosa's avatar
Arturo Espinosa committed
67

68 69
* Font dialog

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
70 71 72 73 74 75 76 77 78
   + 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.
79

80
* Number formatting
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

   + The formatting code should take the current GtkFont for the cell
     being formatted as well as the width allowed and take this into
     account to render the number as well as possible given the space so
     that for small regions, numbers in scientific notation are displayed.

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

Arturo Espinosa's avatar
Arturo Espinosa committed
101
* Sheet
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
102 103 104 105

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

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
111 112
   + Cell data entry
     double click on cell allows editing as in main editing box.
113

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
114 115 116
   + Cell comments
     Cell comments should be wrapped - at least so that they do not run
     off the screen.
117
   
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
118 119 120 121
   + 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. 
122

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
123 124 125
   + Captions (ItemBar)
     It should be possible to set the dimensions of the cols, rows to
     contain information as "min_points", "max_points".  
126

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

129 130
* Auditing

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
131
   + Write the sheet auditing code.
132

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
133
* Editing
Miguel de Icaza's avatar
Miguel de Icaza committed
134

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
135 136 137
   + 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
138

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
139 140 141 142 143 144 145
   + Object properties

   + Objects
     Load / save, print of all objects + Bonobo objects.

   + Style
     Protection: Bloqued/Hidden.
146
     (Don't forget to update the CELL function after this is implemented)
147 148

* File Load/Save
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
149 150 151 152 153 154 155 156 157 158 159 160 161 162
   + 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 error handling and display in file_read routines.
   + Add ability to send warnings, and progress while loading.
   + Improve handling of unknown fonts and functions when importing.

* Unicode

   + Support throughout Gnumeric.
163

164 165
* Workbooks:

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
166 167
   + Consider addition of a cursor warping operation to jump between
     open workbooks.
168

Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
169 170 171
   + Notebook
     - Decrease flicker when paging between sheets.
     - Enable capability to select multiple sheets.
172 173

* Office compatibility
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
174 175 176

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

Jody Goldberg's avatar
Jody Goldberg committed
178
* Parser
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
179 180 181

   + fully support R[-1]C[3] type references.
   + Improve error reporting.
182 183

* Internals
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
184 185 186 187 188

   + 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.
189 190

* Calculation
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214
   + 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.
   + Rethink 'generation' mechanism.  It currently forces all cells to
     be recalculated when the value of any of them change.
     i.e.

     a1 : sum (b2:c3)
     changing b2 bumps the generation of the workbook.
     All 4 cells b2,b3,c2,c3 get recalculated even though
     only b2 needed it.

     Functions taking ranges as arguments are forced to do their own
     recalc checking for elements of the range.  They cheat and use
     the generation to test for recalc.  This is wrong!  It should be sufficent
     to only manually recalc a cell that has its recalc flag set.  However,
     in order to support that we need mark all cells that directly or indirectly
     depend on a cell as requiring recalc when a cell changes.

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

216
* Excel Import
Almer S. Tigelaar's avatar
Almer S. Tigelaar committed
217 218 219

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

221
* Excel Export
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 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299

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

* 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.

* Split/Frozen panes

   + In the works.

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

* 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 :-)

* Scripting (!)

   + Needs to be adopted.

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

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.

* Consolidate
   
   + ?

* Subtotals

   + This will really need to wait for a while.

* Autofilter

   + ?