BUGS 18.6 KB
Newer Older
1
   To report Gnumeric bugs, please visit bugzilla.gnome.org.
2

3
    This file is used as a scratch pad by developers.  It is a list of known
4 5 6
issues that need to be addressed.  Divided into, things that will prevent
release, and longer term bugs.

7
-------------------------------------------------------------------------------
8

9 10
Release Critical
----------------
Jody Goldberg's avatar
Jody Goldberg committed
11 12
    - hidding col/row headers should not hide outline symbols
    - header selection broken when there are groups
13

14 15 16
In Progress
-----------
    Jody
17 18
	- xlsx chart axis export
	- data slicers
Jody Goldberg's avatar
Jody Goldberg committed
19 20 21
	- CELL translation & array handling
	- INDEX range res, iteration
	- ExprEntry extensions
Jody Goldberg's avatar
Jody Goldberg committed
22
	- Tool to filter dups
Jody Goldberg's avatar
Jody Goldberg committed
23
	- python wrapper for libspreadsheet
24 25 26
	- mis-export of array expr
	    http://bugzilla.gnome.org/show_bug.cgi?id=322096

27 28
    : s/range_equal/gnm_range_eq/

29 30
Review
------
Jody Goldberg's avatar
Jody Goldberg committed
31
    - func name translation		{Manny}
32
    - merge libgda port
33

34 35 36 37 38 39 40 41
Target Features
---------------
- insert cut
- clipboard handlers in plugins
- load/save of external references
- all the merged cell singleton bugs
- scripting

Jody Goldberg's avatar
Jody Goldberg committed
42 43
Short term goals
----------------
44
    - Use go_glade_signal_connect (and friends)
45
    - ={A1:A3+rand()}	only calls rand() once.
46

47 48 49 50 51 52
Misc stuff that should be fixed
-------------------------------

- Missing undo/redo for
    - Freeze panes (tricky this is a view attribute)
    - `Add Scenario' Portion of Solver
53
 
54 55 56 57 58 59 60
- cols/rows
    : Make unhide smarter to find hidden regions on either side of
      selected ranges.
    : drag based col/row resize should support negative sizes to
      correspond to hiding.
    : support delete for discontinuous ranges

61 62
Worries
-------
Jody Goldberg's avatar
Jody Goldberg committed
63
    : range_translate in stf.c looks suspicous.
64
    : Add bounds checking of integers on the xml based importers
65
    : do bounds check in excel_get_text
66 67 68
    : Select graph, Copy, and paste to Emacs: used to crash, but now it
      just g_barfs and pastes empty string.

69 70 71
    - Create new type string/double/int (not bool) for BIN2DEC etc.
    - Allow missing arguments that are not '?' for ACCRINT.

Jody Goldberg's avatar
Jody Goldberg committed
72 73 74 75 76 77 78 79
    - TestForBiffConsumer : #REF ??
    - accrint-test.xls : why fail ?
    - BAHT functions
    - broken-name.xls
    - database_test.xls
    - div0-xp.xls
    - edward~1.xls
    - eng.xls
80 81
	- XL returns real numbers as strings from complex functions
	- Check difference in besseli
Jody Goldberg's avatar
Jody Goldberg committed
82 83 84 85 86 87 88 89 90 91
    - errors.xls
	: calc of interest
	: #REF on sheet2
    - extract-clean-new.xls : loss of data in col A ?
    - furigana.xls : #NAME?
    - global_calling_placeholder.xls
    - named-expr-95.xls
    - named-expr-97.xls
    - operand.xls
    - pivot-edited.xls : odd colours in the 'the range that contains' box
92 93
    - store and persist view modes
    - fix bogosity of 'ant' cursors being in sheet_view and having the app contact them.
Jody Goldberg's avatar
Jody Goldberg committed
94

95
-------------------------------------------------------------------------------
96 97 98 99

Pending Patches
---------------

Jody Goldberg's avatar
Jody Goldberg committed
100
Blocked Patches
101
---------------
102

103
-------------------------------------------------------------------------------
Jody Goldberg's avatar
Jody Goldberg committed
104 105
Architecture Changes
--------------------
106

107
- Merge wb_control_init_state and wb_control_set_view
108
- Use gtk_window_group_new to keep wbcg's distinct
109

Jody Goldberg's avatar
Jody Goldberg committed
110
1) things to move into libgoffice
111 112
    1.1) plugin-manager dialog
    1.2) doc meta data
113
	1.2.1) doc meta data dialog	{Trelane and etrunko}
Jody Goldberg's avatar
Jody Goldberg committed
114 115
    1.3) Insert hyperlink dialog
	1.3.1) Integration with evo address book
116
    1.4) move password dialog to goffice
Jody Goldberg's avatar
Jody Goldberg committed
117

Jody Goldberg's avatar
Jody Goldberg committed
118
2) Font handling (move to GOFont)
Jody Goldberg's avatar
Jody Goldberg committed
119

120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209
4) AutoFilter [share functionality with slicers]
    4.19) Change value entries in expr dialog into combos
    4.4) 2nd value in expr dialog only if 1st is active
    4.25) Undo redo support for ins/del col/row with filters
    4.27) combo contains start to end of continuous region
           not just the end of the selected region
    4.34) Tooltip on combo with the current filter details
    4.35) Change icon in combo from arrow to filter instead
	    of changing colour
    4.36) Support Office 2007 toggle selection
    4.37) Add fun new types (std dev)
    4.38) Add new condition types from style-condition
    4.39) Look at merging style-condition and filter
    4.40) col selector to autofilter dialog ala OOo
    4.45) MOOX
	4.45.1) import
	    4.45.1.1) top10					(DONE)
	    4.45.1.2) items
	    4.45.1.3) custom
	    4.45.1.4) dynamic
	4.45.2) export
	    4.45.2.1) top10					(DONE)
	    4.45.2.2) items
	    4.45.2.3) custom
	    4.45.2.4) dynamic
    4.51) #383400 : '95' should match 95
    22.52) Clipboard ?? do we want this ?
    4.53) Support Office 2007 toggle date based buckets

5) Data Slicers
    5.1) I/O)
	5.1.1) MOOX						{David Thorne/Jody}
	    5.1.1.1) import
		5.1.1.1.1) Cache Definition			(DONE)
		    5.1.1.1.1.1) Groups				(DONE)
		    5.1.1.1.1.2) Sources			(DONE)
		5.1.1.1.2) Cache Records			(DONE)
		5.1.1.1.3) Table
		    5.1.1.1.3.1) Basic				(DONE)
	    5.1.1.2) export
		5.1.1.2.1) Cache Definition			(DONE)
		    5.1.1.2.1.1) Groups				(DONE)
		    5.1.1.2.1.2) Sources			(DONE)
		5.1.1.2.2) Cache Records			(DONE)
		5.1.1.2.3) Table
		    5.1.1.2.3.1) Basic
	5.1.2) xls						{Jody}
	    5.1.2.1) import
		5.1.1.1) Basics					(DONE)
		5.1.1.2) sources				(DONE)
		5.1.1.3) Groups					(DONE)
	    5.1.2.2) export pivot cache
		5.1.2.1) create streams				(DONE)
		5.1.2.2) records				(DONE)
		    5.1.2.2.1) SXDB				(DONE)
		    5.1.2.2.2) SXFDB				(DONE)
		    5.1.2.2.3) SXDDB				(DONE)
		5.1.2.3) streamId record
	5.1.3) ODF
    5.2) Data Structures
	5.2.1) Cache & Fields
	5.2.2) Slicer & fields
    5.3) Control Logic
	5.3.1) Sort by display fields				(DONE)
	5.3.2) dump as if all are row fields			(DONE)
	5.3.3) Grouping						(DONE)
	5.3.4) Aggregations
	5.3.5) Filters ('page')
    5.4) Undo/Redo
	5.4.1) refresh
	    5.4.1.1) stub					(DONE)
	5.4.2) reconfigure
	5.4.3) delete
	5.4.4) create
    5.5) UI
	5.5.1) actions						(DONE)
	    5.5.1.1) stub					(DONE)
	    5.5.1.2) context sensitive				(DONE)
	5.5.2) context menu
	    5.5.2.1) hook it up					(DONE)
	5.5.3) field dialog
	    5.5.3.1) stub					(DONE)
	    5.5.3.2) re-order fields
	    5.5.3.2) re-order fields
	5.5.4) cell combos
	    5.5.4.1) create					(DONE)
	    5.5.4.2) display for headers			(DONE)
	    5.5.4.3) support toggles				(DONE)
	    5.5.4.4) Add ok/cancel buttons
	    5.5.4.5) filter/sort options
Jody Goldberg's avatar
Jody Goldberg committed
210 211
    5.6) Functions
	5.6.1) GETPIVOTDATA signature
Jody Goldberg's avatar
Jody Goldberg committed
212

213
6) Undo/redo improvements
214
    6.1) Keep a .swp style log of user actions			{Dan Hall}
Jody Goldberg's avatar
Jody Goldberg committed
215
    6.2) Restore Row heights in CmdFormat::undo
216 217
    6.3) X-GNOME-Bugzilla-ExtraInfoScript=myscript

218
7) Drag and Drop						{Jon Kare}
Jon Kåre Hellan's avatar
Jon Kåre Hellan committed
219 220 221
    7.1) Common code framework for dnd and X/W32 clipboard
    7.2) Find a better place than SheetControlGUI for dnd code
    7.3) More formats, at least html and text
222
    7.6) Autoscroll in 1 dimension and movement in other
Jody Goldberg's avatar
Jody Goldberg committed
223

Jody Goldberg's avatar
Jody Goldberg committed
224
8) Rich Text
225
    8.13) xls
226
	8.13.3) collect fonts from markup for export
227 228
	    8.13.3.2) comments                                  (partial)
	    8.13.3.2) text boxes                                (partial)
Jody Goldberg's avatar
Jody Goldberg committed
229

Jody Goldberg's avatar
Jody Goldberg committed
230 231
9) RTL
    9.1) Drawing
Jody Goldberg's avatar
Jody Goldberg committed
232 233 234
	9.1.2) item-cursor
	    9.1.2.4) re-position the autofill handle
	9.1.4) item-edit
235 236
	    9.1.4.4) right alignment editing
	    9.1.4.4) center alignment editing
Jody Goldberg's avatar
Jody Goldberg committed
237
	    9.1.4.5) rotation
Jody Goldberg's avatar
Jody Goldberg committed
238 239 240
	9.1.5) wbcg/scg/pane
	    9.1.5.10) autoscroll
		9.1.5.10.3) object drags outside window
Jody Goldberg's avatar
Jody Goldberg committed
241 242 243
    9.2) spans
	9.2.2) Respect style selected dir
	9.2.3) add 'context' selected text dir
Jody Goldberg's avatar
Jody Goldberg committed
244
    9.3) Model
Jody Goldberg's avatar
Jody Goldberg committed
245 246
	9.3.10) swap action icon depending on state
	9.3.11) Add entry to format dialog to set text dir
247
    9.4) Persistence
248 249 250
	9.4.5) csv
	9.4.6) html
	9.4.7) latex
251
    9.5) Printing
Jody Goldberg's avatar
Jody Goldberg committed
252
	9.5.7) init preview scroll to right in rtl mode
253
        9.5.9) Patterns
Jody Goldberg's avatar
Jody Goldberg committed
254
    9.7) Add entry to tab context menu (do we need ?)
Jody Goldberg's avatar
Jody Goldberg committed
255 256
    9.11) sheet objects
	9.11.7) set direction of views
257 258
    9.12) preview grid ??
	9.12.1) do we need/want the autoformat examples to swap dir ?
259
 
260
10) Functions
261 262
    - Function range_min_k uses an O(n*log n) algorithm.  It should use O(n)
      algorithm, see Knuth.
263
    - Suport >100 style for SUBTOTAL
264 265 266 267 268 269 270 271 272 273 274 275 276 277
    - docs
	: Make 'func is foo compatible' a flag on the importers
	: need conventions for including markup
	    - simple bold/italic/font
	    - links
	    - embedded images ??
    - Support parsing and displaying locale specific function names.
    - When loading a function that already has a definition (such as a stub),
      we're in trouble: (a) we just overwrite the old definition in the symbol
      table, (b) both old and new owner want to remove the symbol on exit.

      We should somehow steal the old definition (and complain unless the old
      was a stub) without changing the GnmFunc address.  On exit we should
      explicitly check that it is ours to remove.
Jody Goldberg's avatar
Jody Goldberg committed
278 279
    - examples
	1) A registry of named data tables to reference from examples
280
	2) The example text should have the expr in C locale
Jody Goldberg's avatar
Jody Goldberg committed
281
		?? how to reference the sample data ??
282 283 284 285 286 287 288 289 290 291 292 293
    : HARMEAN with no arguments (or just strings/booleans) should yield N/A,
      not NUM.
    : MAXA,MINA with no arguments should yield N/A, not NUM.
    : STDEVPA,VARPA with no arguments should yield VALUE, not DIV0.
    : STDEVA,VARA with 0-1 arguments should yield DIV0, not VALUE.
    : DEVSQ with no arguments should yield #NUM, not zero.
	? How did you enter this.  xl-2k refuses to parse that
        ! Import from a .csv file.

    : tie the custom ui into action sensitivity pools
    : support array evaluation for =LARGE and friends
    : ISREF is a list function ?
294

295 296 297 298
11) Conditional formats
    11.1) Data Structures in the core
	11.1.5) Check re-merging on change
	11.1.6) Check merging of auto pattern colours on link
299 300
    11.2) Gnumeric XML
	11.2.3) Add to .xsd schema
301
    11.3) MOOX
302 303
	11.3.1) import
	11.3.2) export
304 305 306 307
    11.6) Evaluation
	11.6.3) Optimize constants (=1)
	11.6.4) Optimize non-position dependent (=$A$1>3)
    11.7) Rendering
308
	11.7.5) Long spans
Jody Goldberg's avatar
Jody Goldberg committed
309 310
    11.8) Printing
	11.8.5) Long spans
311

312 313 314 315 316
12) Input Messages
    12.1) Implement
	12.1.1) Data Structure to store it			(DONE)
	12.1.2) Display them
    12.2) UI to modify them
317 318
    12.6) ODF
	12.6.1) import
319

Jody Goldberg's avatar
Jody Goldberg committed
320
16) Protection limits for selection
321 322 323 324 325 326
    16.2) I/O
	16.2.1) Gnumeric
	    16.2.1.1) Extend XSD
	    16.2.1.2) SAX Export			{partial}
	    16.2.1.3) SAX Import
	    16.2.2.4) DOM Import
327 328 329
	16.2.3) ODF
	    16.2.3.1) Import
	    16.2.3.2) Export
Jody Goldberg's avatar
Jody Goldberg committed
330 331 332 333 334 335 336 337 338 339 340
    16.3) Honour flags for Return/Tab
	16.3.1) Return/Tab
	    16.3.1.1) Initial					(DONE)
	    16.3.1.2) Wrap around
	    16.3.1.3) Optimize finding next unlocked
	16.3.2) mouse click					(DONE)
	16.3.3) range selection					(DONE)
	16.3.4) keyboard range extension
	16.3.4) select all
	16.3.5) cols/rows

341
17) Explicit Page Breaks
Andreas J. Guelzow 's avatar
Andreas J. Guelzow committed
342
   17.3.3) ODF
343 344 345 346
    17.3.3.2) Export	{merge breaks and styles}
    17.3.4) Lotus ?
    17.3.5) Applix ?
    17.3.6) Create User Interface for them
347

348
2) stf
Morten Welinder's avatar
Morten Welinder committed
349 350 351
    2.4) Provide an optional mechanism for specifying the
	 target location useful for text to columns, and
	 import into sheet
352
    2.8) Make listed separators locale dependent (ie translators
353
         should be able to define separators)
Morten Welinder's avatar
Morten Welinder committed
354
    2.14) Implement format guessing.
355
    2.15) Put big "best guess" button on front page.
356
    2.17) Tabs: handle optional expansion.
357

358
3) hlinks
359 360 361 362 363
    3.4) XLS export (6.10)
      3.4.1) fix import of short names without long names
    3.5) ODF
	3.5.1) import
	3.5.2) export
364 365 366
    3.6) Entering text of the form scheme://blah or a@b.c
	    should insert hyperlinks
    3.7) HYPERLINK function should create link.
367

368
6) XL
369
    6.5) Intersection, union and set export
370 371
    6.12) Set operand classes
	6.12.3) check target type of range/intersect
372
    6.13) image export
Jody Goldberg's avatar
Jody Goldberg committed
373
	6.13.1) Excel95
374
    6.13) chart import
375 376 377
	6.13.8) Axis
	    6.13.8.5) double axis import on simple_bar2
	    6.13.8.6) high/low flag is for partner not self
378 379 380 381 382 383 384 385
	6.13.9) Gradients
	    6.13.9.5) From center
	    6.13.9.6) From corner
	    6.13.9.8) Two colour alpha (is this possible)
	    6.13.9.10) One colour alpha (is this possible)
	    6.13.9.11) presets
	6.13.10) override auto series indexing for xls
	6.13.11) error bars
Jody Goldberg's avatar
Jody Goldberg committed
386
    6.14) chart export
387 388 389 390 391
	6.14.1) Infrastructure
	    6.14.1.4) collect fonts
	    6.14.1.5) collect fmts
	    6.14.1.6) Create a NullRenderer for measurement
	    6.14.1.7) Handle multiple charts in a graph
392
	    6.14.1.8) spid group allocation for gradients
393 394 395 396 397 398 399 400 401 402 403 404 405 406 407
	6.14.5) Axes
	    6.14.5.2) discrete axis
	    6.14.5.4) handle area plot axes
	    6.14.5.5) radar plot axes
	    6.14.5.7) label fmt
	6.14.6) Area Formating
	    6.14.6.3) Gradient
	    6.14.6.3) Image
	6.14.8) labels
	    6.14.8.1) Content
	    6.14.8.2) Placement
	    6.14.8.3) Markup
	6.14.8) Legends
	    6.14.8.2) Exceptions
	6.14.9) error bars
408
	6.14.11) Singletons
Jody Goldberg's avatar
Jody Goldberg committed
409 410 411
	6.14.12) Grid lines
	    6.14.12.1) Import
	    6.14.12.2) Export
Jody Goldberg's avatar
Jody Goldberg committed
412
    6.15) Store and round trip macros (functional, but could be prettier)
413 414
	6.15.7) generate CompObj stream
	6.15.8) generate property streams to get the flags
415
	6.15.9) Look into Michael's vba compressor
416
    6.17) Excel95 object export
Jody Goldberg's avatar
Jody Goldberg committed
417

Jody Goldberg's avatar
Jody Goldberg committed
418 419 420 421 422 423 424 425 426
13) UI
    13.1) Zoom
	13.1.1) Add a 'global' flag for the zoom dialog
	13.1.2) Zoom to selection
    13.2) Formula Guru
	13.2.1) Fix keyboard interface
    13.3.1) Item Edit
	13.3.1) Mouse select range

Jody Goldberg's avatar
Jody Goldberg committed
427 428 429
14) Polish up Open and Save
    14.3) sort the file types by precedence and recently used
    14.4) do we want to persist recently used ?
430

Jody Goldberg's avatar
Jody Goldberg committed
431
22) Validate from List
432 433 434 435
    22.11) Odd .xls storage of aa,bb,cc
    22.13) ODF
	22.13.1) import
	22.13.2) export
436

437 438
29) gconf.
    29.1) Check for errors					(DONE)
Andreas J. Guelzow's avatar
Andreas J. Guelzow committed
439
    29.2) update on remote changes
440
    29.3) see if schema is installed				(DONE)
441
    29.4) Move the pref storage into app and compartmentalize	(DONE)
442
    	  the use of gconf.
443 444
    29.5) update the preference structure on local changes
          (this is an automatic consequence of 29.2)
445 446 447 448 449
    29.6) Lockdown
	    (from libgnome/schemas/desktop_gnome_lockdown.schemas)
	29.6.1) /desktop/gnome/lockdown/disable_save_to_disk
	29.6.2) /desktop/gnome/lockdown/disable_printing
	29.6.3) /desktop/gnome/lockdown/disable_print_setup
450

451 452 453
30) Cleanup importers/exporters
    30.1) multiple extensions for exporters, with a default
    30.2) flag/virtual for an imp/exp to flag viability with current context
454
   30.4) remove bogosity of function pointers that are unused
455
    	in the base instance.
456 457
    30.5) Allow import of multiple views			{jody}
    30.5) Allow export of multiple views			{jody}
458

Jody Goldberg's avatar
Jody Goldberg committed
459 460
31) sylk
    31.1) importer
461 462 463
	31.1.9) hidden cells
	31.1.10) cell protection
	31.1.11) comments
Jody Goldberg's avatar
Jody Goldberg committed
464
    31.2) exporter
465
	31.2.4) column widths
466
	31.2.5) formats
467 468 469 470 471
	31.2.6) fonts
	31.2.7) styles
	31.2.9) hidden cells
	31.2.10) cell protection
	31.2.11) comments
Jody Goldberg's avatar
Jody Goldberg committed
472
	31.2.12) array row sep ';;'
Jody Goldberg's avatar
Jody Goldberg committed
473

474 475 476 477 478 479 480 481 482
32) SheetObjects
    32.2) Add acetate_create virtual to handle shaped objects.
    32.5) Use delta from start of drag rather than previous movement
    32.8) Add ability to fix aspect ratio of drag resize
    32.10) research the other xl object flags.
    32.13) selecting object with other objects on top of it should
   	   hide them while editing
    32.14) ngettext for insert/delete objects undo message
    32.15) Check the stacking of ctrl pts when moving multiple selections
483 484 485
    32.17) Combos
	32.17.2) XLS
	    32.17.2.2) export
486
	32.17.3) MOOX
487 488 489 490 491
	    32.17.3.1) import
	    32.17.3.2) export
    32.18) Lists
	32.18.2) XLS
	    32.18.2.2) export
492
	32.18.3) MOOX
493 494
	    32.18.3.1) import
	    32.18.3.2) export
Jody Goldberg's avatar
Jody Goldberg committed
495 496 497 498
    32.19) SheetObjectGroup
    32.20) editing text boxes (do a derived FooCanvasEditableTextItem) we can
          steal some of the xim support from item-edit.
    32.21) rich text for objects
499

Morten Welinder's avatar
Morten Welinder committed
500 501 502
33) Rotated text
    33.2) Create new span type so drawing can overflow cells.
    33.3) Draw borders sheared.
503
    33.4) Draw background sheared when border present.
Morten Welinder's avatar
Morten Welinder committed
504

Jody Goldberg's avatar
Jody Goldberg committed
505 506 507 508 509
35) Accessibility
    We can use
	http://bugzilla.gnome.org/attachment.cgi?id=47315&action=view
    as a template

Jody Goldberg's avatar
Jody Goldberg committed
510
36) OpenDocument (ODF)
511
    36.2) Import
Jody Goldberg's avatar
Jody Goldberg committed
512
	36.2.4) col/row manual vs auto
Jody Goldberg's avatar
Jody Goldberg committed
513 514 515 516 517
    36.5) See 12.6 (Input Messages)
    36.7) See 22.13 (Validation)
    36.10) See 5.3 (pivots)
    36.11) See 17.2.5 (page breaks)

518
37) MOOX
Jody Goldberg's avatar
Jody Goldberg committed
519 520 521 522
    37.1) Import
	37.1.2) Named expressions
	37.1.3) Rich text
	37.1.6) More print settings
523
	    37.1.6.1) PI:{error_display,comment_placement}
Jody Goldberg's avatar
Jody Goldberg committed
524 525 526 527 528 529
	37.1.7) Comments
	37.1.8) Text direction in styles
    37.2) Export
	37.2.2) Named expressions
	37.2.3) Rich text
	37.2.6) More print settings
530
	    37.2.6.1) PI:{error_display,comment_placement}
Jody Goldberg's avatar
Jody Goldberg committed
531 532 533
	37.2.7) Comments
	37.2.8) Text direction in styles

534 535
38) Printing
    38.3) PI:comment_placement
536

537 538 539 540 541
39) Lotus filter
    39.1) http://www.openoffice.org/issues/show_bug.cgi?id=84496
	 Lots of juicey warnings.  Although we do seem to handle the sheet
	 names correctly.

542
41) win32
543
    41.1) Fix preview [#533795]
Jody Goldberg's avatar
Jody Goldberg committed
544
	41.1.1) port over evince based preview from unix
Jody Goldberg's avatar
Jody Goldberg committed
545
	    41.1.1.1) port it
Jody Goldberg's avatar
Jody Goldberg committed
546
	    41.1.1.2) patch glib [#566348]
547
    41.2) python installation [#549387]
Jody Goldberg's avatar
Jody Goldberg committed
548 549
	41.2.1) pygobject build fix
	41.2.2) automate pygobject build fix
Jody Goldberg's avatar
Jody Goldberg committed
550 551
	41.2.3) package pygobject
	41.2.4) install pygobject
552
    41.6) long pause between license and screen ?
Jody Goldberg's avatar
Jody Goldberg committed
553
    41.7) version dll.a the same way the .dll is handled
Jody Goldberg's avatar
Jody Goldberg committed
554 555
    41.8) Add MS Office processing instruction hooks for us
    41.10) Check registry/gconf wrapper
Andreas J. Guelzow's avatar
Andreas J. Guelzow committed
556

557 558
autoformat
----------
559 560 561 562
    - leaking styles when an edge is disabled
    - consider either using the users data as a sample, or at least making the
      sample adaptive based on which edges are disabled.

563 564
auto-fill
---------
565 566
    - The autocalc label should use a more readable format and should not get
      clipped.
567

568 569 570 571 572 573 574 575 576
    - Names
	: references in names do not get changed with cut/paste or ins/del row/col.
	  How to handle relative references in names ?? here.
	: Dialog
	    * We should start with the expr entry set to either the current cell,
	      or by selecting the first named expression in scope that contains the
	      current cell.
	: Handle pasting an expression with an un-qualified sheet local name into
	  another sheet
577

578 579
    - clean up the range_list codes to differentiate a list of ranges from a list
      of cellranges.
580

581
    - The max row/col canvas scroll size is still hard coded.
582

583
    - let's add simple commands like inc/dec font size and things like that.
584

585
    - Auto resize needs to handle empty cells.
586

587 588 589 590
    - Styles
	: improve uniform_get to handle full sheet more quickly.
	: Borders
	    * use new border code for cell format dialog (possibly preview-grid)
591

592 593 594 595 596
Import/Export
-------------
    : Look into octave/matlab filters
    : look into maxima
    : Talk to shaunm about mathematica
597

598 599
Clipboard
---------
600
    - May be not export html as table when just one cell is selected.
Jody Goldberg's avatar
Jody Goldberg committed
601 602 603 604 605

General Ideas
-------------
    - A connection to swivel (www.swivel.com)
    - Sugar/OLPC UI & collab
Jody Goldberg's avatar
Jody Goldberg committed
606
    - Add 'send a frown/smile' button
607
    - 'fish eye' zoom to around selection
608
    - treemap for hierarchical data
Jody Goldberg's avatar
Jody Goldberg committed
609 610 611 612
    - conditional / computed formats
	: referenced styles (eg for time sheets)
	: GnmColor computable to move the calculated aspect into the actual
	  selectors
Jody Goldberg's avatar
Jody Goldberg committed
613 614 615
    - 'Custom' autofilter type to eval expr per cell
    - autofilter : refresh
    - macro hook in validation to run proc if valid
Jody Goldberg's avatar
Jody Goldberg committed
616 617

/* vim : ai, ts=8, sw=4, expandtab */