1. 05 Jul, 2000 1 commit
    • Michael Meeks's avatar
      implement. (write_mem_to_storage): implement. (create_xml_bonobo_stream): · ed8df623
      Michael Meeks authored
      2000-07-05  Michael Meeks  <michael@helixcode.com>
      
      	* src/bonobo-io.c (write_stream_to_storage): implement.
      	(write_mem_to_storage): implement.
      	(create_xml_bonobo_stream): create.
      	(xml_input_read_cb):
      	(xml_input_close_cb):
      	(hack_xmlSAXParseFile): copy from libxml.
      
      	* src/sheet-object.c (sheet_object_drop_file): update; this should
      	be totaly re-written.
      
      	* src/sheet-object-bonobo.c (sheet_object_bonobo_load): clean up.
      
      	* src/sheet-object-item.c (sheet_object_item_new): remove,
      	redundant; re-tool calls to sheet_object_container_new_object.
      
      	* src/sheet-object.c (create_object): rename the one use.
      
      	* src/sheet-object-container.c (sheet_object_container_new_from_object_id):
      	remove activation logic.
      
      	* src/sheet-object-bonobo.c (sheet_object_bonobo_destroy): free
      	object_id. (sheet_object_bonobo_construct): do activation in here.
      	(sheet_object_bonobo_get_object_iid): implement.
      
      	* src/sheet-object-container.c (sheet_object_container_new_from_goadid):
      	rename to (sheet_object_container_new_object): this.
      
      	* src/xml-io.c (xml_write_sheet_object): add bonobo io.
      	(xml_read_sheet_object): add bonobo and re-scope vars.
      	(xml_parse_ctx_new_full): implement.
      
      	* src/main.c (gnumeric_main): add bonobo_io_init.
      
      	* src/xml-io.c (xml_parse_ctx_init): implement,
      	(xml_parse_ctx_shutdown): ditto.
      	(xml_workbook_write): moved
      	(gnumeric_xml_write_workbook): s/parse_xml_context_t/XmlParseContext/
      
      	* src/xml-io.c (xml_workbook_read): publicise.
      	(xml_workbook_write): ditto.
      
      2000-07-04  Michael Meeks  <michael@helixcode.com>
      
      	* src/about.c (dialog_about): sort alphabeticaly.
      ed8df623
  2. 04 Jul, 2000 1 commit
    • Jukka-Pekka Iivonen's avatar
      Implemented basis 0 for COUPDAYBS. · 9a7d6d65
      Jukka-Pekka Iivonen authored
      2000-07-04  Jukka-Pekka Iivonen  <iivonen@iki.fi>
      
      	* src/functions/fn-financial.c: Implemented basis 0 for COUPDAYBS.
      
      	* src/functions/fn-financial.c (coupdays): Implemented frequency 1
       	for basis 1 (frequences 2 and 4 are still not done).
      9a7d6d65
  3. 03 Jul, 2000 4 commits
    • Morten Welinder's avatar
      Don't add one to the number of lines if the last line is empty. · 332034ff
      Morten Welinder authored
      2000-07-03  Morten Welinder  <terra@diku.dk>
      
      	* src/stf-parse.c (stf_parse_get_rowcount): Don't add one to the
       	number of lines if the last line is empty.
      
      	* src/sheet.c (sheet_cell_set_text): Plug leak.
      
      	* src/workbook-format-toolbar.c
       	(do_sheet_selection_apply_number_format): Avoid double translation
       	of format.
      
      	* src/mstyle.c (mstyle_set_format_text): Renamed from
       	mstyle_set_format.
      	(mstyle_set_format): New function taking a StyleFormat *.
      332034ff
    • Jody Goldberg's avatar
      Begin the Name menu. · 672ded42
      Jody Goldberg authored
      
      2000-07-03  Jody Goldberg <jgoldberg@home.com>
      
      	* src/workbook.c : Begin the Name menu.
      
      	* src/workbook-edit.c (workbook_edit_set_sensitive) : New function.
      	(workbook_finish_editing) : Use here.
      	(workbook_start_editing_at_cursor) : And here.
      	(workbook_edit_attach_guru) : And here.
      	(workbook_edit_detach_guru) : And here.
      	(workbook_edit_entry_redirect_p) : New function.
      
      	* src/item-grid.c (item_grid_button_1) : If we have a guru up, but are
      	  not selecting a region ignore clicks.
      	(item_grid_event) : Ditto.
      
      	* src/gnumeric-sheet.c (gnumeric_sheet_can_select_expr_range) : It is
      	  possible to have a guru up without selecting regions.
      
      	* src/expr-name.c (expr_name_list) : Doh!
      
      2000-07-02  Jody Goldberg <jgoldberg@home.com>
      
      	* src/expr.c (expr_rewrite) : Names can contain relative references,
      	  we need to check them too.
      
      	* src/parser.y (exp) : Add production for sheet specific names.
      	  eg Sheet2!name
      
      2000-07-01  Jody Goldberg <jgoldberg@home.com>
      
      	* src/functions/fn-string.c (parse_search_strin) : Use g_strdup.
      672ded42
    • Jukka-Pekka Iivonen's avatar
      Implemented `Histogram' tool (mostly). · 275dc86f
      Jukka-Pekka Iivonen authored
      2000-07-03  Jukka-Pekka Iivonen  <iivonen@iki.fi>
      
      	* src/analysis-tools.c: Implemented `Histogram' tool (mostly).
      
      	* src/dialogs/tools.h: Related changes.
      
      	* src/dialogs/analysis-tools.glade,
      	src/dialogs/dialog-analysis-tools.c: Added dialogs for `Histogram'
      	and `Fourier Analysis' tools.  The later is not implemented yet.
      275dc86f
    • Jukka-Pekka Iivonen's avatar
      Implemented COUPNUM(). · 7dc4e081
      Jukka-Pekka Iivonen authored
      2000-07-03  Jukka-Pekka Iivonen  <iivonen@iki.fi>
      
      	* src/functions/fn-financial.c: Implemented COUPNUM().
      
      	* src/analysis-tools.c: Started the implementation of the third
      	anova tool (two-factor with replication).
      
      	* src/dialogs/analysis-tools.glade: Added dialog for the new
      	tool.  Fixed the `Correlation' dialog.
      
      	* src/dialogs/dialog-analysis-tools.c: Added
      	dialog_anova_two_factor_without_r_tool().
      
      	* src/dialogs/tools.h: Related changes.
      
      	* TODO: Added `Data analysis tools' section.
      7dc4e081
  4. 30 Jun, 2000 4 commits
    • Morten Welinder's avatar
      Forgot to remove these. · 307b939f
      Morten Welinder authored
      307b939f
    • Morten Welinder's avatar
      Get rid of old plugins. · 43074ed0
      Morten Welinder authored
      43074ed0
    • Jody Goldberg's avatar
      It is possible to have a guru up without editing. · 69d6d36b
      Jody Goldberg authored
      
      2000-06-30  Jody Goldberg <jgoldberg@home.com>
      
      	* src/gnumeric-sheet.c (gnumeric_sheet_can_select_expr_range) : It is
      	  possible to have a guru up without editing.
      	(gnumeric_sheet_key_press) : rename from gnumeric_sheet_key.
      	(gnumeric_sheet_size_allocate) : rename from gnumeric_size_allocate.
      	(gnumeric_sheet_focus_in) : Enable the input context.
      	(gnumeric_sheet_focus_out) : Disable the input context.
      	(gnumeric_sheet_realize) : Create the input context.
      	(gnumeric_sheet_unrealize) : Destroy the input context.
      	(gnumeric_sheet_class_init) : Register the new methods.
      	(gnumeric_sheet_init) : Init the input context.
      
      	* src/clipboard.c (x_selection_handler) : Adjust to changes in
      	  application_clipboard_clear.
      	(x_selection_clear) : Ditto.
      	* src/cmd-edit.c (cmd_paste) : Ditto.
      	* src/sheet.c (sheet_destroy) : Ditto.
      
      	* src/application.c (application_clipboard_clear) : Make dropping the
      	  selection optional.  This removes the kludges necessary to handle
      	  changing the clipboard when we already have the selection.
      
      	* src/functions/fn-logical.c (gnumeric_true, gnumeric_false) :
      	  fix signatures.
      69d6d36b
    • Jukka-Pekka Iivonen's avatar
      Added FALSE(). · 4beddd14
      Jukka-Pekka Iivonen authored
      2000-06-30  Jukka-Pekka Iivonen  <iivonen@iki.fi>
      
      	* src/functions/fn-logical.c: Added FALSE().
      4beddd14
  5. 29 Jun, 2000 2 commits
  6. 28 Jun, 2000 1 commit
    • Jody Goldberg's avatar
      new function. · 93f11589
      Jody Goldberg authored
      
      2000-06-28  Jody Goldberg <jgoldberg@home.com>
      
      	* src/functions/fn-sheet.c (GNUMERIC_VERSION) : new function.
      
      	* src/workbook.c (workbook_do_destroy) : No need to release the
      	  clipboard here.  The Sheet does it for us.
      
      	* src/workbook-format-toolbar.c : Add Fill to the default money
      	  format.
      
      	* src/symbol.c : The only symbols are functions.  The global table
      	  should not be world visible.
      
      	* src/sheet.c (sheet_flag_status_update_cell) : Take a CellPos.
      	(sheet_get_extent_cb) : Use Cell::pos rather than adding an
      	  indirection.
      	(cb_set_cell_content) : Use StyleFormat.
      	(sheet_cell_set_value) : Call sheet_flag_status_update_cell.
      	(sheet_cell_set_value) : Ditto.
      	(sheet_destroy) : Prepare to clear out named expressions.
      	(colrow_move) : Handle changes in cell_relocate signature.
      	(sheet_move_range) : Ditto.
      
      	* src/sheet-autofill.c : Use StyleFormats.
      
      	* src/position.c (parse_pos_init) : Global position are permitted.
      
      	* src/parser.y : Large change.  Do not automaticlly look for function
      	  names or named expressions in the lexer.  The lexer returns STRING
      	  and QUOTED_STRING.  The parser then does the appropriate lookups to
      	  potentially convert to something else.  This allows us to have sheet
      	  names that are the same as functions.
      
      	* src/parse-util.c (cellref_name) : Add flag to optionally disable the
      	  addition of the sheet name.  This is useful when printing
      	  Sheet2!A1:A3 rather than Sheet2!A1:Sheet2!A3.
      
      	* src/number-match.c (format_create_regexp) : Handle fill formats.
      
      	* src/mstyle.c (mstyle_get_border) : Fix constness.
      
      	* src/mathfunc.c (combin, fact) : Moved these here from
      	  functions/fn-math.c
      
      	* src/main.c (gnumeric_main) : No more constants_init, or
      	  global_symbol_init.
      
      	* src/func.c () : Reorg.  Remove some dead code.  Begin adding
      	  workbook local function support, Begin adding volatile, and
      	  semi-volatile functions.  Move the use of SymbolTable internal
      	  in preparation for eliminating it.
      
      	* src/format.c (format_number) : Improve support for pound, yen, and euro.
      	  Remember to produce a number when we hit spacing.
      
      	* src/expr.c : Have ExprFunc refer directly to the FunctionDefinition
      	  We still use a SymbolTable internally, but that will be merged out
      	  later.
      
      	* src/expr-name.c : Major reorg.  Not complete.
      
      	* src/corba-sheet.c (fill_corba_value) : Adjust to changes in
      	  cellref_name signature.
      
      	* src/commands.c (cmd_set_date_time_undo) : No need to manually call
      	  update_cell_flag.  cell_remove, and cell_set_text do that for us.
      	(cmd_set_date_time_redo) : Ditto.
      	  Use StyleFormat.
      
      	* src/clipboard.c (paste_cell) : Take the ExprRewriteInfo as an
      	  argument.
      	(clipboard_paste_region) : Init the ExprRewriteInfo.  We need to do
      	  this here rather than in cell_relocate because we may be moving a
      	  region, not just a single cell, and references within the region
      	  should not be changed.
      
      	* src/cell.c (cell_relocate) : Take the relocation info as an
      	  argument.  Non NULL indicates a request to check bounds.  We can not
      	  do this at the cell level. becuase we may be moving a block rather
      	  than just a single cell, and references into the block should NOT be
      	  rewritten.
      	(cell_set_text_and_value) : Take a StyleFormat.
      	(cell_assign_value) : Ditto.
      	(cell_set_value) : Ditto.
      	(cell_set_expr_internal) : Ditto.
      	(cell_set_expr_unsafe) : Ditto.
      	(cell_set_expr) : Ditto.
      
      	* src/auto-format.c (do_af_suggest) : Expression now refers directly
      	  to functionDef.
      93f11589
  7. 27 Jun, 2000 2 commits
    • JP Rosevear's avatar
      Undo transposition of find_bound_walk parameters. · c6075c55
      JP Rosevear authored
      2000-06-27  JP Rosevear  <jpr@arcavia.com>
      
      	* src/functions/fn-lookup.c (find_index_bisection): Undo
      	transposition of find_bound_walk parameters.
      
      	* samples/excel/lookfuns2.xls: Add type mismatch tests.
      c6075c55
    • Jukka-Pekka Iivonen's avatar
      Fixed copy-paste bug in documentation. · aa8a7aa8
      Jukka-Pekka Iivonen authored
      2000-06-27  Jukka-Pekka Iivonen  <iivonen@iki.fi>
      
      	* src/functions/fn-stat.c (help_finv): Fixed copy-paste bug in
       	documentation.
      
      	* src/functions/fn-logical.c: Added TRUE() function since it is
       	also a function in Excel.
      
      	* TODO: Updated the status of the build-in functions.
      aa8a7aa8
  8. 26 Jun, 2000 2 commits
    • JP Rosevear's avatar
      New function that doesn't require an error variable - use only if · 6b68e93d
      JP Rosevear authored
      2000-06-26  JP Rosevear  <jpr@arcavia.com>
      
      	* src/value.c (value_get_as_checked_bool): New function that
      	doesn't require an error variable - use only if confident that
      	the value does actually exist.
      
      	* src/value.h: Add new prototype.
      
      	* src/functions/fn-lookup.c: Clean up cruft
      	(find_type_valid): See if the value is a string or is gnumeric.
      	(find_compare_type_valid): See if the types are comparable.
      	(find_bound_walk): Walk an integer range first in one direction
      	and then in the other direction.
      	(find_index_linear): Do a linear search on a range or array.
      	(find_index_bisection): Do a bisection search on a range or array
      	that also follows excel rules for for handling type mismatches
      	during the search and finding the first and last item matching
      	the search.
      	(gnumeric_vlookup): Use new functions and implement undocumented
      	excel behaviour.
      	(gnumeric_hlookup): ditto
      	(gnumeric_lookup): ditto
      	(gnumeric_match): ditto
      6b68e93d
    • Jukka-Pekka Iivonen's avatar
      Implemented COUPDAYS for basis 0, 2, 3, and 4 (basis 1 is still not · b02f342f
      Jukka-Pekka Iivonen authored
      2000-06-26  Jukka-Pekka Iivonen  <iivonen@iki.fi>
      
      	* src/functions/fn-financial.c: Implemented COUPDAYS for basis 0,
       	2, 3, and 4 (basis 1 is still not implented).
      b02f342f
  9. 23 Jun, 2000 1 commit
  10. 22 Jun, 2000 1 commit
    • Jon K Hellan's avatar
      Ensure that black with index 8 can't be swapped out. (fixup_fill_colors): · 9303241d
      Jon K Hellan authored
      2000-06-21  Jon K Hellan  <hellan@acm.org>
      
      	* ms-excel-write.c (palette_put_defaults): Ensure that black with
      	index 8 can't be swapped out.
      	(fixup_fill_colors): Use index 8 instead of 0 for black in
      	foreground. Excel is unable to open the cell format dialog for
      	cells where foreground pattern color or border color is index 0.
      	(build_xf_data): Borders: Use index 8 instead of 0 for black.
      
      	* ms-excel-read.c (ms_excel_read_cell): Add more references to BIFF
      	documentation.
      	(ms_excel_read_workbook): Ditto
      9303241d
  11. 21 Jun, 2000 1 commit
  12. 20 Jun, 2000 1 commit
  13. 19 Jun, 2000 3 commits
    • Jody Goldberg's avatar
      Fix crash. This is not the real cause but it is the symptom. · 76720896
      Jody Goldberg authored
      A typo in sheet_get_extent must be fixed to truely solve the problem.
      
      2000-06-19  Jody Goldberg <jgoldberg@home.com>
      
      	* ms-excel-write.c (excel_cell_get) : Add some invariants as
      	  protection.
      	(pre_cell) : Be more careful about handling cells that are potentially
      	  out of bounds.
      76720896
    • Jody Goldberg's avatar
      Release 0.55 · c2928e92
      Jody Goldberg authored
      c2928e92
    • Jody Goldberg's avatar
      bug 14550 · 8ed700aa
      Jody Goldberg authored
      2000-06-18  Jody Goldberg <jgoldberg@home.com>
      
      	* ms-excel-read.c (biff_boundsheet_data_new) : Guess at some
      	  undocumented behavior.  It appears that when a sheet has a NULL
      	  name it is actually 'Sheet#'.
      8ed700aa
  14. 16 Jun, 2000 2 commits
    • Valek Frob's avatar
      Fixed some typos in func descriptions. · cb4812a2
      Valek Frob authored
      cb4812a2
    • Jody Goldberg's avatar
      Move error and boolean handling to the value level. · 6b2218b0
      Jody Goldberg authored
      2000-06-15  Jody Goldberg <jgoldberg@home.com>
      
      	* src/value-sheet.c (value_is_error) : No need for 'offset' parm.
      
      	* src/number-match.c (format_match) : Parse TRUE/FALSE as this level.
      
      	* src/value-sheet.c (constants_init) : TRUE/FALSE are not symbols.
      	  They are values.  A symbol only has value in an expression.
      	  A value operates at a lower level.  eg
      	A1 : '=TRUE' will work as a value or a symbol
      	A1 : 'TRUE' will only work as a value
      
      2000-06-15  Jody Goldberg <jgoldberg@home.com>
      
      	* src/format.c (lookup_color) : Handle translated colours.
      6b2218b0
  15. 15 Jun, 2000 5 commits
  16. 14 Jun, 2000 3 commits
    • Jody Goldberg's avatar
      45432962
    • Jody Goldberg's avatar
      Bug 12042 · aba702b5
      Jody Goldberg authored
      2000-06-13  Jody Goldberg <jgoldberg@home.com>
      
      	* src/functions/fn-math.c (callback_function_sumproduct) : Handle
      	  empty.
      	(gnumeric_sumproduct) : Handle blank cells correctly, correct error
      	  handling slightly.
      
      	* src/func.c (iterate_cellrange_callback) : Handle empty cells.
      	(function_iterate_do_value) : Add a new argument to control the
      	  handling of empty cells.
      	(function_iterate_argument_values) : Hard code the ignore_blanks
      	  argument to TRUE the same as the previous behavior.
      aba702b5
    • Jody Goldberg's avatar
      No need to malloc memory for an int. Fix the logic to handle empty cells · 1b9ee9c0
      Jody Goldberg authored
      
      2000-06-13  Jody Goldberg <jgoldberg@home.com>
      
      	* src/functions/fn-math.c (callback_function_sumif) : No need to
      	  malloc memory for an int.  Fix the logic to handle empty cells
      	  properly.
      1b9ee9c0
  17. 13 Jun, 2000 2 commits
  18. 08 Jun, 2000 2 commits
    • Jody Goldberg's avatar
      Do not make the edge visible, the scroll time will take care of that. · f4b6302b
      Jody Goldberg authored
      
      2000-06-08  Jody Goldberg <jgoldberg@home.com>
      
      	* src/sheet-view.c (sheet_view_{col,row}_selection_changed) :
      	  Do not make the edge visible, the scroll time will take care of
      	  that.
      	(sheet_view_{col,row}_size_changed) : Use the new undo wrappers.
      	(cb_colrow_resize) : Use the new undo wrappers.
      	(sheet_view_init) : Init the scroll timers.
      	(sheet_view_stop_sliding) : Based on the version from item_grid.
      	(sheet_view_start_sliding) : Ditto.
      	(sheet_view_sliding_callback) : Ditto.  Added callback support.
      	  tuned scroll parameters.
      
      	* src/number.h : Clear out unused cruft.
      
      	* src/item-grid.c : Move support for scroll timers into sheet-view.
      
      	* src/item-bar.c (get_element_from_pixel) : Renamed from
      	  get_col_from_pos.
      	(cb_extend_selection) : New function.
      	(item_bar_event) : Use the sliding scroll mechanism in sheet_view.
      
      	* src/item-cursor.c (item_cursor_selection_event) : Adapt to changes in
      	  item_grid_find_{col,row}.
      	(item_cursor_drag_event) : Ditto.
      
      	* src/sheet.c (sheet_foreach_colrow) : renamed and moved to.
      	* src/colrow.c (col_row_foreach) here.
      
      	* src/gnumeric-sheet.c (gnumeric_sheet_find_{col,row}) : Moved here
      	  and renamed from.
      	* src/item-grid.c (item_grid_find_{col,row}) : here.
      
      	* src/value.c (value_equal) : deleted.
      	(value_compare) : Moved and renamed from
      	* src/expr.c (compare) : here.
      	(expr_dump_tree) : Delete replicated function.
      
      	* src/colrow.c (col_row_size_list_destroy) :
      	(col_row_index_list_destroy) : New function.
      	(col_row_get_index_list) : New function.
      	(col_row_set_sizes) : New function.
      	(col_row_restore_sizes_group) : New function.
      
      	(col_row_save_sizes) : Moved from sheet.c
      	col_row_restore_sizes : Ditto.
      	cb_set_row_height : Ditto.
      	rows_height_update : Ditto.
      
      	src/commands.c (cmd_resize_row_col*) : Implement.
      f4b6302b
    • Ariel Rios's avatar
      Removal of unused code. Found some nasty problems that need to be addresed · ca016474
      Ariel Rios authored
      2000-06-07  Ariel Rios  <ariel@arcavia.com>
      
      * plugin.c: Removal of unused code. Found some nasty problems
      that need to be addresed urgently in ranges and arrays.
      
      * doc/guile-gnumeric.txt: Updated.
      ca016474
  19. 07 Jun, 2000 2 commits
    • Morten Welinder's avatar
      Plug leak. · dc3feb4b
      Morten Welinder authored
      2000-06-14  Morten Welinder  <terra@diku.dk>
      
      	* ms-formula-write.c (ms_excel_write_formula): Plug leak.
      
      	* ms-excel-write.c (ms_excel_check_write): In case of error, clear
       	out the state.
      	(ms_excel_write_free_state): "New" function.
      	(write_workbook): Don't free workbook here.
      	(ms_excel_write_workbook): Do it here and plug a leak.
      
      	* boot.c (excel_save): Free the state.
      dc3feb4b
    • Jody Goldberg's avatar
      FORMAT records supercede the internal table. · d1b4f46f
      Jody Goldberg authored
      
      2000-06-07  Jody Goldberg <jgoldberg@home.com>
      
      	* ms-excel-read.c (biff_format_data_lookup) : FORMAT records supercede
      	  the internal table.
      d1b4f46f