1. 30 Aug, 2000 3 commits
    • Morten Welinder's avatar
      Fixup IRR same as RATE. · 6fb55943
      Morten Welinder authored
      6fb55943
    • Morten Welinder's avatar
      Fix a few type errors. · a9807ec1
      Morten Welinder authored
      2000-08-30  Morten Welinder  <terra@diku.dk>
      
      	* src/print-cell.c (print_show_iso8859_1): Fix a few type errors.
      
      	* src/functions/fn-financial.c (gnumeric_rate): Respect the sign
       	of the guess.  Work much harder at getting an answer.
      
      	* src/goal-seek.c (goal_seek_point): New function.
      a9807ec1
    • Jon K Hellan's avatar
      Wrapper around gnome_print_show which accepts iso8859.1. We use this until · 8d35ac15
      Jon K Hellan authored
      2000-08-30  Jon K Hellan  <hellan@acm.org>
      
      	* src/print-cell.[ch] (print_show_iso8859_1): Wrapper around
      	gnome_print_show which accepts iso8859.1. We use this until we
      	switch to UTF-8 internally.
      
      	* src/print-cell.c (print_text): Use print_show_iso8859_1.
      
      	* src/print.c (print_hf): Ditto.
      
      2000-08-30  Jon K Hellan  <hellan@acm.org>
      
      	* src/print.c (print_page, print_job_info_get): Header/footer are
      	measured from top/bottom of sheet, not from inside top/bottom
      	margin.
      	(print_page): Correct placement when centering horizontally or
      	vertically.
      
      2000-08-30  Jon K Hellan  <hellan@acm.org>
      
      	* src/dialogs/dialog-printer-setup.c (get_printable_height):
      	Remove misleading comment.
      8d35ac15
  2. 29 Aug, 2000 2 commits
  3. 17 Aug, 2000 1 commit
    • Chema Celorio's avatar
      Merge Chema's copy sheet patch. · c93bc712
      Chema Celorio authored
      2000-08-16  Chema Celorio  <chema@celorio.com>
      
      	* src/sheet.c (sheet_duplicate
      		       sheet_clone_cells,
      		       cb_sheet_cell_copy,
      		       sheet_clone_objects,
      		       sheet_clone_names,
      		       sheet_clone_selection,
      		       sheet_clone_styles,
      		       sheet_clone_style_region,
      		       sheet_clone_colrow_info,
      		       sheet_clone_colrow_info_item) : New.
      
      	* src/solver-lp.c (solver_lp_copy) : New func.
      
      	* src/print-info.c (print_info_copy) : New func.
      	(print_info_margin_copy) : Ditto.
      	* src/workbook.c (sheet_action_clone_sheet) : New.
      
      2000-08-16  Jody Goldberg <jgoldberg@home.com>
      
      	* src/sheet.c (sheet_cell_insert) : Add a flag to disable span
      	  recalculation.
      
      	* src/sheet-style.c (sheet_get_style_list) : const.
      
      	* src/position.c (parse_pos_init_cell) : Use Cell::pos.
      
      	* src/clipboard.c (paste_cell_with_operation) : Changes to
      	  sheet_cell_insert.
      	(paste_cell) : Ditto.
      
      	* src/analysis-tools.c (prepare_output) : Changes to
      	  workbook_sheet_get_free_name.
      	* src/workbook.c (insert_sheet_cmd) : ditto.
      	(workbook_sheet_name_strip_number) : New.
      	(workbook_sheet_get_free_name) : Handle names of the form 'bobo (2)'.
      c93bc712
  4. 14 Aug, 2000 1 commit
    • Jody Goldberg's avatar
      Bug #20900 · 331cc9ff
      Jody Goldberg authored
      2000-08-14  Jody Goldberg <jgoldberg@home.com>
      
      	* src/print-cell.c (print_cell) : Sync with
      	* src/cell-draw.c (cell_draw) : and clear out a few usages of
      	  Cell:{row,col})_info.
      331cc9ff
  5. 11 Aug, 2000 1 commit
  6. 08 Aug, 2000 1 commit
    • Jody Goldberg's avatar
      Handle blanks as 0. (callback_function_make_list) : Ditto. · c644804f
      Jody Goldberg authored
      
      2000-08-07  Jody Goldberg <jgoldberg@home.com>
      
      	* src/functions/fn-stat.c (callback_function_stat) : Handle blanks as 0.
      	(callback_function_make_list) : Ditto.
      	(callback_function_ttest) : Ditto.
      	(gnumeric_mode) : Explicitly ignore blanks.
      	(gnumeric_count) : Ditto.
      	(gnumeric_ztest) : Ditto.
      	(gnumeric_counta) : Ditto.
      	(gnumeric_percentile) : Ditto.
      	(gnumeric_quartile) : Ditto.
      	(gnumeric_prob) : DO NOT IGNORE BLANKS.
      	(gnumeric_ftest) : Ditto.
      	(gnumeric_ttest) : Ditto.
      	(gnumeric_frequency) : Ditto.
      
      	* src/functions/fn-logical.c (gnumeric_and) : Handle
      	  changes to function_iterate_argument_values.
      	(gnumeric_or) : Ditto.
      	* src/functions/fn-math.c (gnumeric_lcm) : Ditto.
      	(gnumeric_multinomial) : Ditto.
      	(gnumeric_seriessum) : Ditto.
      
      	* src/functions/fn-financial.c (gnumeric_mirr) : Use the old
      	  behavior of ignoring blanks.
      	(gnumeric_irr) : Ditto.
      	(gnumeric_npv) : Ditto.
      
      	* src/functions/fn-eng.c (gnumeric_improduct) : Handle
      	  changes to function_iterate_argument_values.
      	(gnumeric_imsum) : Ditto.
      
      	* src/func.c (function_iterate_argument_values) : Add ignore_blank
      	  flag.
      
      	* src/collect.c (callback_function_collect) : Support new collect flag
      	  COLLECT_IGNORE_BLANKS.
      	(collect_floats) : change to function_iterate_argument_values.
      	(float_range_function2) : Use COLLECT_IGNORE_BLANKS.
      
      2000-08-01  Jody Goldberg <jgoldberg@home.com>
      
      	* src/sheet-autofill.c (fill_item_new) : It is legal to have 'D' and 'M'
      	  for day or month fields.
      
      2000-08-01  Jody Goldberg <jgoldberg@home.com>
      	For : John N S Gill <bmrg@gofree.indigo.ie>
      
      	* src/item-cursor.c (item_cursor_autofill_event) : Implement support
      	  for double click on autofill button.
      c644804f
  7. 03 Aug, 2000 1 commit
    • Morten Welinder's avatar
      Handle large bit counts. Handle negative counts. (func_bitxor): New · 6de925bc
      Morten Welinder authored
      2000-08-03  Morten Welinder  <terra@diku.dk>
      
      	* numtheory.c (func_bitlshift, func_bitrshift): Handle large bit
       	counts.  Handle negative counts.
      	(func_bitxor): New function.
      	(gnumeric_nt_mu): New function from Pablo De Napoli
      	<pdenapo@mate.dm.uba.ar>.
      	(walk_factorization): Return an error code.  All callers changed.
      6de925bc
  8. 27 Jul, 2000 1 commit
    • Morten Welinder's avatar
      Make xbase plugin work as intended. · 9d685688
      Morten Welinder authored
      2000-07-27  Morten Welinder  <terra@diku.dk>
      
      	* boot.c (xbase_field_as_value): Plug huge leaks.  Fix 'I' case.
      	Partially fix 'B' case.
      	(xbase_load): Plug leak.
      
      	* xbase.c (xbase_read_field): It looks like '\0' is a terminator
       	too.  Sounds reasonable.
      	(xbase_close): Plug another huge leak.
      
      2000-07-26  Morten Welinder  <terra@diku.dk>
      
      	* xbase.c (deref_le_guint16, deref_le_guint32): New functions.
      	(xbase_open): Initialise ans->offset.
      	(xbase_read_header): Fix huge amounts of bogusities.
      	(xbase_read_field): Ditto.
      
      	* boot.c (xb_setdouble): Don't define until such time as it gets
       	used.
      9d685688
  9. 22 Jul, 2000 1 commit
  10. 17 Jul, 2000 1 commit
    • Jody Goldberg's avatar
      Improve the look of diagonal double borders. They still handle · a4ba034b
      Jody Goldberg authored
      
      2000-07-16  Jody Goldberg <jgoldberg@home.com>
      
      	* src/border.c (style_border_draw) : Improve the look of diagonal double
      	  borders.  They still handle intersections poorly, but this improves
      	  things a bit.
      	(style_border_print) : Ditto.
      
      2000-07-16  Jody Goldberg <jgoldberg@home.com>
      	For : Matt Bissiri <bissiri@eecs.umich.edu>
      
      	* src/clipboard.c: Implemented 'paste link' and 'skip blanks' for paste special.
      	(paste_link): New function.
      	(paste_cell): Do not clear the target cells if PASTE_SKIP_BLANKS is specified.
      	Call paste_link if PASTE_LINK is specified.
      
      	* src/clipboard.h:
      	Added PASTE_LINK and PASTE_SKIP_BLANKS flags.
      
      	* src/dialogs/dialog-paste-special.c:
      	(transpose_cb): Rename transpose_cb -> checkbutton_toggled.
      	(dialog_destroy): New function.
      	(paste_link_set_sensitive): New function.
      	(dialog_paste_special): Add 'paste link' and 'skip blanks' to the dialog.
      a4ba034b
  11. 13 Jul, 2000 1 commit
    • Matt Bissiri's avatar
      Implement the arithmetic operators for paste special. · ff3fd66a
      Matt Bissiri authored
      2000-07-12  Matt Bissiri <bissiri@eecs.umich.edu>
      
      	* src/clipboard.c Implemented arithmetic operations for paste special.
      	(cell_has_expr_or_number_or_blank) : New function.
      	(cell_get_contents_as_expr_tree) : New function.
      	(paste_oper_to_expr_oper) : New function.
      	(apply_paste_oper_to_values) : New function.
      	(paste_cell_with_operation) : New function.
      	(paste_cell) : Call paste_cell_with_operation if paste_flags
      	indicates an arithmetic operation.
      ff3fd66a
  12. 09 Jul, 2000 2 commits
  13. 08 Jul, 2000 1 commit
    • Morten Welinder's avatar
      Change traversal order for ranges. · 16ad54ce
      Morten Welinder authored
      2000-07-08  Morten Welinder  <terra@diku.dk>
      
      	* src/sheet.c (sheet_cell_foreach_range): Change traversal order
       	for ranges.
      
      	* src/func.c (function_iterate_do_value): Fix traversal order for
       	arrays.
      16ad54ce
  14. 07 Jul, 2000 1 commit
    • Morten Welinder's avatar
      Rewrite with lots of care in error handling. · 8b9837b3
      Morten Welinder authored
      2000-07-07  Morten Welinder  <terra@diku.dk>
      
      	* src/functions/fn-math.c (gnumeric_sumproduct): Rewrite with lots
       	of care in error handling.
      
      	* src/value-sheet.c (value_area_get_width): Make it official that
       	scalars have width 1.
      	(value_area_get_height): Likewise.
      	(value_area_get_x_y): Likewise.
      8b9837b3
  15. 06 Jul, 2000 1 commit
  16. 05 Jul, 2000 1 commit
  17. 04 Jul, 2000 2 commits
    • 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
    • Almer. S. Tigelaar's avatar
      Fix column mangling in fixed width import. · f1ab3f8d
      Almer. S. Tigelaar authored
      2000-07-04  Almer. S. Tigelaar.  <almer1@dds.nl>
      
      	* src/dialogs/dialog-stf.c, src/dialogs/dialog-stf-fixed-page.c :
      	Fix column mangling in fixed width import.
      
      	* src/dialogs/dialog-stf-format-page.c :
      	Fix USB (==Ugly Selection Bug).
      
      	* src/stf-parse.c, src/stf-parse.h :
      	(stf_parse_options_fixed_autodiscover) : New!
      	Column autodiscovery for fixed width.
      
      	* src/dialogs/dialog-stf.glade :
      	Add clear and autodiscovery buttons
      
      	* src/dialogs/dialog-stf-fixed-page.c :
      	(fixed_page_autodiscover) : Autodiscovery routine.
      	(fixed_page_clear_clicked) : Clear click handler
      	(fixed_page_auto_clicked) : Autodiscovery click handler
      f1ab3f8d
  18. 03 Jul, 2000 2 commits
    • 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
  19. 30 Jun, 2000 2 commits
  20. 24 Jun, 2000 1 commit
  21. 23 Jun, 2000 1 commit
    • Morten Welinder's avatar
      Constify. (set_group_option_signals): Constify. (new_frame): Constify. · 9379ee6e
      Morten Welinder authored
      2000-06-23  Morten Welinder  <terra@diku.dk>
      
      	* src/dialogs/dialog-analysis-tools.c (set_output_option_signals):
       	Constify.
      	(set_group_option_signals): Constify.
      	(new_frame): Constify.
      	(error_in_entry): Constify.
      	(new_dialog): Constify.
      
      	* src/analysis-tools.c: major cleanup.  Eliminate fixed-size
       	buffers that might overflow; constify; plug leaks; improve
       	precision; produce numbers without going through strings.
      	(set_cell_float, set_cell_int, set_cell_na, set_cell_printf): New
       	functions.
      
      	* src/xml-io.c (xml_write_range): Constify.
      	(xml_get_gnome_canvas_points): Mark code as bogus.
      	(xml_set_gnome_canvas_points): Constify.  Improve space checks.
      	(xml_set_value_int): Improve buffer sizing.
      	(xml_set_value_string): Constify.
      	(xml_set_color_value): Improve buffer sizing.
      
      	* src/ranges.c (parse_range): Constify, simplify, optimise, and
       	secure.
      	(range_parse): Fix strict case.
      
      	* src/parse-util.c (parse_cell_name_or_range): Remove bogus cast.
      9379ee6e
  22. 13 Jun, 2000 3 commits
    • Jody Goldberg's avatar
      - Initial version of formula guru · 489a4201
      Jody Goldberg authored
      - Some extensions to auto-fill
      - Slight reorg of Bonobo support.
      
      2000-06-13  Jody Goldberg <jgoldberg@home.com>
      
      	* src/workbook.c : Enable the formula guru, make WorkbookPrivate hold
      	  the BonoboObject in the ENABLED_BONOBO case.
      
      	* src/workbook-edit.c (workbook_finish_editing) : Disconnect any gurus
      	  that may be up.
      	(entry_changed) : Do not autocomplete expressions.  Gurus play havoc
      	  with this.
      	(workbook_edit_auto_complete_init) : Delete unused.
      	(workbook_get_entry_logical) : New function.
      	(workbook_set_entry) : New function.
      	(workbook_edit_attach_guru) : New function.
      	(workbook_edit_detach_guru) : New function.
      	(workbook_editing_expr) : When a guru is up we are always editing an
      	  expression. TODO, tune this.
      	(workbook_edit_load_value) : Moved from Sheet, and renamed from
      	  sheet_load_cell_val.
      	(workbook_edit_init) : Handle gurus.
      
      	* src/sheet.c (sheet_destroy_cell_select_cursor) : Make clearing optional.
      
      	* src/sheet-vector.c (sheet_vector_new) : The vectors are
      	  BonoboObjects, destroy them correctly.
      	(sheet_vectors_shutdown) : Ditto.
      
      	* src/sheet-object.c (sheet_set_mode_type_full) : Silence warning.
      	(sheet_object_insert) : Renamed from sheet_insert_object and moved
      	  from sheet.c
      
      	* src/pixmaps.h : Enable the Formula guru.
      
      	* src/parser.y (arg_list) : Improve handling of empty arguments.
      
      	* src/gnumeric-sheet.c (selection_remove_selection_string) : Use
      	  workbook_get_entry_logical.
      	(selection_insert_selection_string) : Ditto.
      	(start_cell_selection_at) : Ditto.
      	(gnumeric_sheet_key_mode_sheet) : Ditto.
      
      	* src/workbook-private.[ch] : Make this into a Bonobo Object for now.
      
      	* src/embeddable-grid.c (embeddable_grid_init_anon) : Use
      	  workbook_new_with_sheets.
      	(embeddable_grid_new) : WorkbookPrivate is temporarily the bonobo
      	  object.
      
      	* src/history.c (history_menu_item_create) : Ditto.
      	(history_menu_locate_separator) : Ditto.
      	(history_menu_insert_separator) : Ditto.
      	(history_menu_remove_items) : Ditto.
      
      	* src/sheet-object-bonobo.c (sheet_object_bonobo_construct) : Ditto.
      	* src/sheet-object-container.c (sheet_object_container_realize) : Ditto.
      
      	* src/workbook-view.c (workbook_view_set_paste_special_state) : Ditto.
      	(change_menu_label) : Ditto.
      
      	* src/file.c (workbook_try_read) : Workbook is now always just a
      	  GtkObject.
      	(workbook_import) : Ditto.
      
      	* src/formats.c (cell_format_date) : Add some new formats.
      
      	* src/format.c (find_decimal_char) : Restore constness.
      	(format_remove_decimal) : Fix the const correctly.
      
      	* src/commands.c (cmd_ins_del_row_col_redo) : Fix to use the new
      	  semantics.
      
      2000-06-12  Jody Goldberg <jgoldberg@home.com>
      
      	* src/sheet-autofill.c (fill_item_destroy) : Free the format.
      	(fill_item_new) : Handle filling by month and year.
      	(autofill_compute_delta) : Ditto.
      	(autofill_cell) : Ditto.
      
      	* src/formats.c (cell_format_is_number) : currently handle the single
      	  character currencies.
      	(cell_format_date) : year only formats.
      
      2000-06-10  Jody Goldberg <jgoldberg@home.com>
      
      	* src/gnumeric-sheet.c (gnumeric_sheet_make_cell_visible) : Minor
      	  optimization.
      489a4201
    • Jon Kåre Hellan's avatar
      My brag sheet · 58eef504
      Jon Kåre Hellan authored
      58eef504
    • Morten Welinder's avatar
      Round properly. · 47ed11e8
      Morten Welinder authored
      2000-06-13  Morten Welinder  <terra@diku.dk>
      
      	* src/functions/fn-math.c (gnumeric_round): Round properly.
      47ed11e8
  23. 12 Jun, 2000 1 commit
    • JP Rosevear's avatar
      Adjust if the range to be sorted has a header. · 18bcb4e0
      JP Rosevear authored
      2000-06-12  JP Rosevear  <jpr@arcavia.com>
      
      	* src/workbook.c (sort_cmd): Adjust if the range to be sorted
      	has a header.
      
      	* NEWS: Update.
      
      	* src/ranges.h: New prototype.
      
      	* src/ranges.c (range_has_header): New function to determine if
      	a region has a header row.
      18bcb4e0
  24. 10 Jun, 2000 1 commit
  25. 06 Jun, 2000 1 commit
  26. 31 May, 2000 2 commits
  27. 28 May, 2000 2 commits
  28. 27 May, 2000 2 commits
    • Jody Goldberg's avatar
      Move the handling of singletons and the setting of the selection here. · 984592e7
      Jody Goldberg authored
      
      2000-05-27  Jody Goldberg <jgoldberg@home.com>
      
      	* src/commands.c (cmd_paste_copy) : Move the handling of singletons
      	  and the setting of the selection here.
      	* src/clipboard.c (clipboard_paste_region) : From here.
      
      	* src/cmd-edit.c (cmd_paste_to_selection) : Remove incorrect
      	  precondition.
      984592e7
    • Almer. S. Tigelaar's avatar
      New function. (stf_parse_csv_cell): Modified so it can trim spaces in · c20793a2
      Almer. S. Tigelaar authored
      2000-05-27  Almer. S. Tigelaar.  <almer1@dds.nl>
      
      	* src/dialogs/stf-parse.c:
      	(stf_parse_options_set_trim_spaces): New function.
      	(stf_parse_csv_cell): Modified so it can trim spaces in
      	several ways
      	(stf_parse_fixed_cell): Ditto.
      	(stf_parse_get_longest_row_width) : Fixed small bug which
      	caused incorrect width to be returned.
      
      	* src/dialogs/dialog-stf.glade:
      	Added trim spaces option and did some general polishing.
      
      	* src/dialogs/dialog-stf.h:
      	Added new member to DruidPageData_t which indicates weather
      	the user wants to trim spaces and in which way.
      
      	* src/dialogs/dialog-stf-main-page.c:
      	(stf_dialog_main_page_init): Modified so it loads the trim optionmenu.
      	(main_page_trim_menu_deactivate): New.
      
      	* src/dialogs/dialog-stf-csv-page.c:
      	(stf_dialog_csv_page_prepare): Now sets the trim member of the parse
      	options struct.
      
      	* src/dialogs/dialog-stf-fixed-page.c:
      	(stf_dialog_fixed_page_prepare): Now sets the trim member of the
      	parse options struct.
      	(stf_dialog_fixed_page_prepare): Did not honor the from/to line
      	settings.
      	(fixed_page_remove_clicked): Added gnumeric_clist_moveto to make
      	selection visible.
      	(fixed_page_add_clicked): Ditto.
      
      	* src/dialogs/dialog-stf-format-page.c:
      	(format_page_canvas_button_press_event): Modified to use
      	gnumeric_clist_moveto
      	(format_page_collist_select_row): Ditto.
      	(format_page_format_changed): Ditto.
      	(stf_dialog_format_page_prepare): Ditto.
      
      	* src/gnumeric-util.c, src/gnumeric-util.h:
      	(gnumeric_option_menu_get_selected_index): New function, Returns
      	the selected index of a GtkOptionMenu. (Originally from
      	dialog-stf-export-format-page.c)
      
      	* src/dialogs/dialog-stf-export-format-page.c:
      	(stf_export_dialog_option_menu_index): Removed.
      	(sheet_page_separator_menu_deactivate): Modified to use the new
      	gnumeric_option_menu_get_selected_index.
      	(stf_export_dialog_format_page_result): Ditto.
      
      	* doc/stf-parser.txt:
      	Update documentation.
      c20793a2