GitLab

- Fix a problem with zooming caused by the new item-bar enhancements.
- Remove gnumeric-sheet.h from a number of places that it had no reason to be.
- Move all of the row/col pos/offset cache into GnumericSheet.  WARNING
  I do not populate all of it yet.

2000-01-26  Jody Goldberg <jgoldberg@home.com>

	* src/sheet-view.c (sheet_view_set_zoom_factor) : Keep the cursor in
	  the same place and recompute the alignments for everything.

	* src/item-cursor.c (item_cursor_set_bounds) : New function.

	* src/gnumeric-sheet.h : Add more orthogonal structure for caching
	  common row/col bounds and their canvas offsets.

	* src/gnumeric-sheet.c (gnumeric_sheet_create) : Init the new members.
	(gnumeric_sheet_filenames_dropped) : Keep the canvas private.
	(gnumeric_sheet_make_cell_visible) : Add 'force_scroll' argument.

	* src/clipboard.c (clipboard_release) : It is possible to have no
	  styles associated with a region.

	* src/item-grid.c : Remove overlapping cache of bounding rows/cols and
	  offsets.  Use the superset in GnumericSheet.
	 (item_grid_find_{row, col}) : Support sliding backwards.

2000-01-22  Jody Goldberg <jgoldberg@home.com>

	* src/sheet-view.c (sheet_view_redraw_headers) : New function that
	  will redraw a subset of an itembar.
	(sheet_view_redraw_columns) : Delete.
	(sheet_view_redraw_rows) : Delete.

	* src/sheet.c (sheet_redraw_headers) : Call sheet_view_redraw_headers.
	(sheet_redraw_columns) : Delete.
	(sheet_redraw_rows) : Delete.

	* src/gnumeric-sheet.h (GnumericSheet) : Remove unused member item_bar_col.

	* src/colrow.c (col_row_set_visiblity) : Use sheet_redraw_headers
	  in place of sheet_redraw_{cols,row}.
	* src/selection.c (sheet_selection_append_range) : Ditto.
	(sheet_select_all) : Ditto.
	(sheet_selection_reset_only) : Ditto.  Clear the selection internally.

	* src/sheet.c (sheet_{col,row}_get_distance) : Handle from > to.

	* src/item-cursor.c (item_cursor_get_pixel_coords) : Use the
	  precalculated offsets.
	* src/item-edit.c (item_edit_get_pixel_coords) : Ditto.

	* src/gnumeric-sheet.c (gnumeric_sheet_bar_set_top_row) : Update the
	  item_grid's notion of the top.  Calculate the new distance using the
	  previous top as the start point.
	(gnumeric_sheet_bar_set_left_col) : Rename from top_col.  Ditto.

2000-01-21  Jody Goldberg <jgoldberg@home.com>

	* src/item-bar.c (item_bar_draw) : Remove minor drawing glitch when
	  drawing at the edge of the sheet.
	(item_bar_class_init) : Remove the unsed 'First' argument.

	* src/item-grid.c (item_grid_draw) : Draw gridlines even at the
	  outer edges.

2000-01-17  Jody Goldberg <jgoldberg@home.com>

	* src/workbook.c : Menu items for sheet and workbook preferences.

	* src/sheet-view.c (sheet_view_adjust_preferences) : New function.
	* src/sheet.c (sheet_adjust_preferences) : New function.
	(sheet_new) : Init the new preferences.
	(sheet_set_text) : Avoid leaking in the failure case.

	* src/selection.c (sheet_selection_paste) : Pass a context.

	* src/cell.c (cell_render_value) : display_fomulas is now a sheet
	  level preference.
	(cell_is_number) : return boolean.
	(cell_is_zero) : New function.

	* src/item-grid.c (item_grid_draw_cell) : honour display_zero.

2000-01-13  Jody Goldberg <jgoldberg@home.com>

	* src/sheet-view.c (horizontal_scroll_event,
			    vertical_scroll_event) : Mice with middle scroll
	  wheels frequently send just button release events, dont assume there
	  was a button_press.

1999-12-19  Jody Goldberg <jgoldberg@home.com>

	* src/selection.c (sheet_selection_cut) : Fix Typo.

	* src/item-bar.c (item_bar_start_resize) : Don't bother setting the
	  location of the line here.  Instead we set the correctly zoomed
	  bounds of the static-dimension.
	(item_bar_end_resize) : Clear the saved points.
	(item_bar_init) : Init the guide and points to NULL;
	(item_bar_event) : No need to call canvas to world.  We zoom manually.
	(item_bar_get_line_points) : Delete.

1999-11-21  Jody Goldberg <jgoldberg@home.com>

	* src/file.c (workbook_save) : Use needs_name flag rather than
	  checking the filename.  All books now have file names.

	* src/workbook.c (workbook_new_with_sheets) : Move default name
	  assignment.
	(workbook_new) : Here.  Make the default name end in .gnumeric.
	  Add a needs_name flag marking this name as auto generated.
	(workbook_set_filename) : Clear the needs_name flag.

The trick is ....
   Dont't Zoom :-)

We are already scaling everything manually.  Don't scale the canvas too.
That way we avoid being auto centered when zoomed.

fix some small drawing glitches.

more verbose colour selection.

Better dialog layout in the presence of big fonts.

support applying coloured borders.

Partial implementation of interbook references.
Slight improvement to grid redraws.

- Beautify the scrollbar tooltips a bit and move some of their utility
  routines into gnumeric-utility.
- Add width/height tooltips on col/row resize.
- Fix bug that would loose the end of resize event when the cursor had
  not moved.

1999-10-06  Miguel de Icaza  <miguel@gnu.org>

	* src/workbook-format-toolbar.c (change_selection_font): Remove
	ants when we change the font.
	(set_selection_halign): And when we change the alignment.

	Many more left to be removed.  Left as an excercise to Jody :-)

	* src/sheet.c (sheet_start_editing_at_cursor): remove ants when we
	start entering new text.

	* src/sheet-view.c (sheet_view_selection_unant): Destroys the
	anted cursors from the sheet view.
	(sheet_view_selection_ant): Adds cursors to the sheetview.
	(sheet_view_construct): New group that is used to hold the
	selection-ant items.

	* src/gnumeric-sheet.c (gnumeric_sheet_key_mode_sheet): Kill ants
	on escape.
	(gnumeric_sheet_key_mode_object): ditto.

	* src/selection.c (sheet_selection_unant): New function, kills the
	selection ants.
	(sheet_selection_ant): New function, adds an anted selection to
	all the selected regions.

	* src/clipboard.c (do_clipboard_paste_cell_region): Do not paste
	beyond sheet boundaries.

	* src/item-grid.c (item_grid_find_row): Do not go beyond sheet boundaries.
	(item_grid_find_col): ditto.

	* configure.in: Generate gnumeric.desktop

	* gnumeric.desktop.in: New file, used to choose the correct
	gnumeric/gnumeric-bonobo executable name.

	* src/sheet-object-item.c: Updated to fit with the new Bonobo
	changes.

1999-10-06  Jody Goldberg <jgoldberg@home.com>

  keeping cols rows in segmented arrays.

- Large speed improvement in exit by operating on the entire sheet rather than
  cell by cell.

- Large speed improvement in Col/Row auto-fills.  they're still too damn slow
  and we use too much memory, but its a start.

- Insert/delete/Shift rows/cols now correctly adjusts references to and from
  the region.

- Code in place to restructure 'copy'

- A few minor dialog adjustments, some from me, some from the mailing list.

1999-09-17  Miguel de Icaza  <miguel@gnu.org>

	* src/workbook-cmd.c: New file.  Moved a bunch of commands here,
	and move to be moved.
	Implemented the set money format;   Implemented the percent formt.

1999-09-16  Miguel de Icaza  <miguel@gnu.org>

	* src/sheet.c (sheet_update_controls, cell_is_homogeneous):
	Include checks for font name and font size.

	* src/dialogs/dialog-printer-setup.c (dialog_printer_setup): Add
	call to gnome_dialog_set_parent here.

	* src/tools.h: New file, moved here all the tools declarations.
	Please, try to keep indentation for public functions as the rest
	of the Gnumeric ones.

	* src/workbook.c: Enable comands Format/Column, Format/Row and
	Format/Sheet.
	(create_format_toolbar): Add font selector toolbar widget.
	(change_font_in_selection_cmd): New routine.  Applies a font to a
	selection in the workbook.
	(workbook_feedback_set): Upgraded feedback interface

	* src/sheet-view.c (sheet_view_row_size_changed): There is no need
	to call gnumeric_compute_visible_ranges, the sheet_row_set_height
	code does this.

	* src/item-bar.c (item_bar_event): Support also row-autosizing.

	* src/sheet.c (sheet_col_size_fit): Add this routine.
	(sheet_col_set_internal_width): New function.  Similar to its
	counterpart

	* src/dialogs/dialog-cell-format.c (dialog_cell_format): Change
	call to g_list_free for sheet_cell_list_free.

	* src/selection.c (sheet_cell_list_free): New routine.

	* src/workbook.c: Reworked toolbars again.  We now only have 2
	toolbars instead of 8 or so.

	* src/sheet.h (SHEET_MAX_ROWS): New excel supports 64k rows, mimic this.

	* src/widgets/gnumeric-toolbar.c: Added new file.  Handles the
	Gnumeric toolbars.

Array input fixed for wierd locales,
bug in header read fixed,
sheet-object window_to_world cleaned,
my D&D stuff moved to more sensible place,

    1st stab at scrollbars adjusting to visible region.
    Move selection code into a new file, no changes.
    Minor const fixups.

Re-vamped & improved D&D code moved around too :-)

Fix Bug 1732, 1638.

Add more Biff record types in excel.

1999-07-09  Miguel de Icaza  <miguel@gnu.org>

	* src/sheet-view.c (sheet_view_construct): Reverted last plan.  We
	do need a sheet_view_construct, as we require sheet_view->sheet to
	be set.

1999-07-08  Miguel de Icaza  <miguel@gnu.org>

	* src/cell.c (calc_text_dimensions): Use gdk_fonts for measuring
	the strings on the screen.  Basically, back out using GnomeFont here.

	* src/print-info.c (render_date, render_time): Finished
	implementing.
	(render_opcode): Enable argument mechanism to extend the number of
	possible formats.  Excel accepts stuff like &[DATE], we extend
	this to accept &[DATE:mmmm-yyyy].  The argument for &[DATE] and
	&[TIME] is a regular Gnumeric formatting code (ie, compattible
	with the cell formating in Excel).

	* src/sheet-view.h: Change style to suit forward declaration
	structure.

	* src/sheet.h: Use forward declaration for SheetView.

	* src/sheet.c (sheet_new_sheet_view, sheet_destroy_sheet_view):
	New routines for managing the sheet views.

	* src/sheet-view.c: Killed sheet_view_construct, there was nothing
	really required there.  Moved all the code to sheet_view_init.
	(sheet_view_scrollbar_display, sheet_view_set_header_visibility):
	New routines that control the visibility of the various gadgets of
	a SheetView.

	* embeddable-grid.c, embeddable-grid.h: New files.  They implement
	the Bonobo GnomeEmbeddable interfaces for embedding Gnumeric in
	applications.

	* src/workbook.c (workbook_new, workbook_core_new): Split this
	routine in two:  GUI independant and GUI dependant.  The next step
	is to provide multiple views of a workbook (although, I am not
	sure I want this).
	(workbook_new_with_sheets): Kill dead code.

	* src/corba-sheet.c (Sheet_row_height, Sheet_col_width,
	Sheet_max_cols_used, Sheet_max_rows_used): New methods.

	* src/Gnumeric.idl (Sheet): new methods max_cols_used,
	max_rows_used, col_width, row_height.

	(Grid): New interface for embeddable grids.

	* src/print-info.c (hf_format_render): Rendering routine for the
	header and footers formats.

1999-07-09  Miguel de Icaza  <miguel@gnu.org>

	* ms-excel-write.c (biff_put_text): Intiialize variable.

this breaks some peoples stuff, but I'll get on to that now...

1999-06-21  Miguel de Icaza  <miguel@gnu.org>

	* src/func.c: Do not pre-initialize them.  If they need to be
	pre-initialized something is wrong in some other place.  Fix that
	instead.

	* src/clipboard.c (do_clipboard_paste_cell_region): Implement
	transpose-on-paste command.  Change the increment steps for
	transpose and compute a different target column as well.

	(sheet_paste_selection): Swap the paste dimesions here if we are
	pasting/transpose.

1999-06-18  Miguel de Icaza  <miguel@gnu.org>

	* src/func.c: Remove static initialization of the error messages.

1999-06-14  Miguel de Icaza  <miguel@gnu.org>

	* src/clipboard.h: Define PASTE_TRANSPOSE.

	* src/dialog-paste-special.c (dialog_paste_special): Add new

1999-06-12  Miguel de Icaza  <miguel@gnu.org>

	* src/dialog-cell-comment.c (dialog_cell_comment): Process the
	return value from gnome_dialog_run correctly as well.  (ie we
	should catch the return value -1 as the "user closed dialog box"
 	message and avoid destroying the dialog box ourselves).

	* src/item-grid.c (context_paste_special_cmd): Handle a cancel
	operation from the dialog_paste_special dialog box.

	* src/dialog-paste-special.c (dialog_paste_special): Hanlde the
	case in which the window manager closed the dialog box.

	* src/cell.c (cell_comment_destroy): Changed invocation from
	gtk_object_destroy to gtk_object_unref.
	(cell_comment_unrealize): ditto.
	(cell_comment_clicked): ditto.
	* src/dialog-cell-sort.c (dialog_cell_sort): ditto.
	* src/dialog-function-select.c (dialog_function_select): ditto
	* src/dialog-function-wizard.c (dialog_function_wizard): ditto
	* src/dialog-paste-special.c (dialog_paste_special): ditto
	* src/dialog-solver.c (constr_add_click): ditto.
	(constr_add_click): ditto
	(dialog_solver_options): ditto
	* src/gnumeric-sheet.c (gnumeric_sheet_stop_cell_selection): ditto
	(destroy_item_editor): ditto.
	(gnumeric_sheet_key_mode_object): ditto, and clear the pointer to
	the current_object.
	* src/sheet-object-container.c (sheet_object_container_destroy): ditto.
	* src/item-cursor.c (item_cursor_drag_event): ditto.
	(item_cursor_autofill_event): ditto
	* src/item-bar.c (item_bar_event): ditto
	* src/workbook.c (workbook_setup_auto_calc): ditto.
	* src/widget-editable-label.c (el_stop_editing): ditto
	* src/sheet-object.c (sheet_object_destroy): ditto
	(sheet_view_object_unrealize): ditto
	(sheet_object_destroy_control_points): ditto
	* src/sheet-view.c (sheet_view_destroy): ditto

1999-06-10  Miguel de Icaza  <miguel@gnu.org>

	* src/pattern-selector.c (pattern_selector_init): Use the GNOME
	canvas fill_stipple feature instead of using the hack of creating
	the bitmap and setting the stipple on the realize handler.

1999-06-01  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* po/hr.po: Added croat translation from Vladimir Vuksan
	<vuksan@cs.unm.edu>.

1999-06-09  Nat Friedman  <nat@gnome-support.com>

	* src/sheet-view.c (sheet_view_insert_object): Commented out call
 	to gnome_bonobo_object_new_view since the API changed and this
 	function doesn't do anything anyways.

	* src/sheet-object-container.c: Include gnome-component-client.h
 	and view-frame.h.
	(sheet_object_container_land): Pass soc->client_site to
 	gnome_bonobo_object_new_view.  Get the view wrapper widget from
 	the view frame.
	(sheet_object_container_realize): Likewise.

1999-05-31  Matt Loper  <matt@gnome-support.com>

	* src/sheet-view.c: Because GNOME::Component was renamed to
	GNOME::BonoboObject, some bonobo function call names needed to be
	changed here (ex. gnome_component_new_view to
	gnome_bonobo_object_new_view).

	* src/sheet-object-container.c (sheet_object_container_land):
	likewise.
	(sheet_object_container_realize): likewise.

Warning fixes;  Keep up with Bonobo changes;  Render the views in all
of the graphic wizard view bits.

Miguel

1999-04-12  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/clipboard.c (x_selection_to_cell_region): Fixed the
	computation of columns in the paste code.

1999-04-11  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/workbook.c (insert_object_cmd): Add sample bonobo support.
	Still lacking an object server selector.

	* src/sheet.c (sheet_insert_object): Add Bonobo support.

	* src/sheet-view.c (sheet_view_insert_object): Add basic Bonobo
	support.  I need to reuse the SheetObject stuff to add control
	points to the objects and to handle repositioning.

1998-12-16  Federico Mena Quintero  <federico@nuclecu.unam.mx>

	* src/workbook.c (workbook_setup_status_area): Do not set_usize()
	on the info item.

	* src/sheet-view.c (new_canvas_bar): Set the width or height to -1
	in set_usize().

	* src/gnumeric-sheet.c (gnumeric_sheet_new): Do not set_usize() on
	the sheet.

1998-12-02  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/gnumeric-sheet.c (gnumeric_sheet_set_top_row,
	gnumeric_sheet_set_top_col): New functions to set the sheet top
	column and row respectively.

	(gnumeric_sheet_bar_set_top_row, gnumeric_sheet_bar_set_top_col):
	Renamed from their old names to reflect their actual action.

	* src/item-cursor.c (item_cursor_autofill_event): Do not pass
	negative numbers to item_grid_find_col and item_grid_find_row.

	* src/item-grid.c (item_grid_find_row, item_grid_find_col): Check
	for possitive numbers. I think the right fix is to accept negative
	numbers and find the column even if the number is negative instead
	of this ugly restriction.

Two things that have been on my hard disk for a long time:

1. Comments-on-cells code is working.  We just need the nice dialog to
actually type something in.

It needs xml-io.c support though, hopefully Daniel will add this soon.

2. Dropped cell->entered_text.  We now only store the parsed version
of the cell (either as an ExprTree or as a Value).  This should help
mmeeks with his Excel-formula importing code, it should be possible
to do the right thing now instead of constructing a string representation
of the formula and re-parsing it.

Various fixes here and there as well.

Miguel

1998-11-10  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/sheet-view.c (sheet_view_comment_get_points): Scale properly
	the points to be in window cordinates.

	* src/sheet.c (sheet_col_set_width): Move comments on column
	change.

	* src/cell.c (cell_copy): Duplicated cells get col, row and sheet
	values set to NULL.

1998-11-05  Miguel de Icaza  <miguel@nuclecu.unam.mx>

	* src/fn-misc.c: Add ctype.h

	* src/sheet-view.c (sheet_view_comment_get_points): New utility
	routine used.
	(sheet_view_comment_relocate): New function used to relocate a
	comment canvas item in a cell to its new location.

	* src/cell.c (cell_relocate): Move the comments with the cell.
	(cell_realize, cell_unrealize, cell_comment_realize,
	cell_comment_unrealize): New functions used to create and destroy
	view-specific cell components (the comments are canvas objects
	that need to be created on a per-view basis).

Get the Excel plugin incorporated into the build process (right now
it is not a real plugin, it gets loaded directly into gnumeric address
space, I guess we can fix this).

Cell comments are working, but still need some work.

Miguel.