$Id: TODO,v 1.13 1998/10/25 23:40:08 cthulhu Exp $ TODO: Make a way to test the Abacus effectively: * Make it able to run tcl scripts at startup and make test scripts for all commands exported via tcl_interf.cc * Improve allfuncs sheet in regressive to include all functions available and test them all * Make a spreadsheet with all possible formats and test them * Spreadhseet with complicated dependence lists to test possible cycles TODO: Abacus must become Y2K TODO: When editing formulas via keyboard, we should allow user to use cursor keys to reference other cells. Plus add bindings for pageup and pagedown. TODO: Macro documentation on the help files for each macro. TODO: Cleanup obsolete topics (inc. RCS) from help browser. BUG: Date manipulation is not possible - once a date is entered, one can only manipulate it's reference number - entry widget should parse internal date format to human readable format to edit, and then reconvert back for cellsets. BUG: Make rearrangement of cell alignment display blue line boxes correctly -> Get x_coord(textPtr->leftEdge and start scanning from then on, redisplaying all rectangles without border until textPtr->rightEdge?) Also, if text exceeds cell and there is a cell to the right with text, text shouldn't be overwritten. BUG: When text exceeds cell width and we are exporting Postscript, Postscript output is wrong, with line too large. Probably fixed by setting line_width to 0 in tkcanvps.c. ??? Problem only ocurrs when printing and I'm out of inkjet paint! :( BUG: Reference manipulation is wrong when cells are copied. BUG: When saving a sheet with other name, col and row formats are lost. BUG: Column widths are not preserved after a save as. BUG: Range definitions with mixed absolute and relative refs fail. BUG: When default in accepted in query menu, focus doesn't return to canvas. BUG: Using columns with width bigger than visible part of sheet makes horizontal scrolling provoque vertical "flicker" and vice-versa. Problem is that when NeedToScroll (from tcl_interf.cc) is called from user_interf.tcl there is no way to know if we are doing a vertical/horizontal scroll, which would partially solve the problem since we would restrict scrolling to said dimension. However, the first time the cell was scrolled there would still be some "flicker". TODO: Switching bold on and off within a range makes all range members have the same font and size - applyFontToSelection is setting all members with all active font options (bold,italics,font name,size,etc) what it should do is change _only_ the swapped property and not all of them. TODO: Add matrix functions. TODO: Make column width and row height dialogues equal. TODO: Redo makefiles of all kind. Make should stop at first error, have a file to include with global defines instead of repeating defs all over and respect user preferences instead of overriding them. TODO: Redo macro error messages in checkargs.cc with object structure so each argument is only parsed once and not twice (once to check, once to get) proper way should involve a constructor that received argv as a parameter and returned and object with arguments properly cast or error. TODO: Saving and loading sheets with tcl scripts - add a method GetCode to each event from Undo/Redo and dump parts of the list (aka macro recording :) ) or the whole list as a script. TODO: Check functions - seems most of them don't check args and segfault or don't work properly. TODO: Make each sheet remember its active cell - should be done as a property of the sheet object and accessed whenever change_active_sheet (tcl) is called. TODO: Put build method and config methods under gnu autoconf TODO: Redo Canvas from scratch so it works fast and proper like a spreadsheet, not a drawing widget. TODO: Make column selection handle scrolling TODO: Make selection work with multiple non-adjacent cells/columns/row ?? Handle CTRL Events TODO: Make complete switch from XXL to Abacus TODO: Get some nice icons for the toolbars TODO: Graph editing. TODO: Cells with errors are not saved and loaded correctly. TODO: Redo borders of all kind. Check that it prints out correctly. TODO: Implement remaining functions in formulas. TODO: Implement cell styles: colors. TODO: @count function does not work properly when sheet is exported to Excel. TODO: Remove warnings with gcc -Wall (lots!)