1. 06 Jul, 2011 1 commit
    • Andreas J. Guelzow 's avatar
      Add an interface for conditional background formatting. · 151d870a
      Andreas J. Guelzow authored
      2011-07-06  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* component/Gnumeric-embed.xml.in: add menu item
      	* src/GNOME_Gnumeric-gtk.xml.in: ditto
      	* src/HILDON_Gnumeric-gtk.xml.in: ditto
      	* src/sheet-control-gui.c
      	* src/style-conditions.c (gnm_style_conditions_dup): new
      	(gnm_style_cond_is_valid): not all conditions need an expression
      	(gnm_style_conditions_eval): not all conditions need an expression
      	* src/style-conditions.h (gnm_style_conditions_dup): new
      	* src/wbc-gtk-actions.c (cb_format_cells_cond): new
      
      2011-07-06  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* cell-format-cond-def.ui: new
      	* cell-format-cond.ui: new
      	* dialog-cell-format-cond.c: new
      	* Makefile.am: add new files
      	* cell-format.ui: remove conditions tab
      	* dialog-cell-format.c: remove handling of deleted conditions tab moving
      	it to dialog-cell-format-cond.c
      	(dialog_cell_format_select_style): new
      	(dialog_cell_format_init): new
      	(dialog_cell_format): use dialog_cell_format_init
      	* dialogs.h (dialog_cell_format_select_style): new
      	(dialog_cell_format_cond): new
      	(dialog_cell_format_style_added): new
      	* help.h (GNUMERIC_HELP_LINK_CELL_FORMAT_COND): new
      151d870a
  2. 05 Jul, 2011 1 commit
  3. 03 Jul, 2011 1 commit
  4. 01 Jul, 2011 4 commits
    • Andreas J. Guelzow 's avatar
      document properties: improve handling of boolean, add more known property names · 94722397
      Andreas J. Guelzow authored
      2011-07-01  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* dialog-doc-metadata.c (dialog_doc_metadata_get_value_type_from_name):
      	add items
      	(dialog_doc_metadata_transform_str_to_boolean): new
      	(dialog_doc_metadata_transform_boolean_to_str): new
      	(dialog_doc_metadata_init): connect above transforms
      
      2011-07-01  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write-docprops.c (xlsx_map_prop_name_to_output_fun):
      	use GSF_META_NAME_MM_CLIP_COUNT
      	* xlsx-read-docprops.c: use GSF_META_NAME_MM_CLIP_COUNT
      94722397
    • Andreas J. Guelzow 's avatar
      Ensure that the main properties cannot be created with unusual type · 43e833ce
      Andreas J. Guelzow authored
      2011-06-30  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* dialog-doc-metadata.c (dialog_doc_metadata_get_value_type_from_name):
      	rewrite, add default argument and change all callers
      	(dialog_doc_metadata_show_all_types): new
      	(dialog_doc_metadata_show_this_type): new
      	(cb_dialog_doc_metadata_ppt_changed): move part into
      	(cb_dialog_doc_metadata_ppt_name_changed): new
      43e833ce
    • Andreas J. Guelzow 's avatar
      support decimal properties · 22d7ff9c
      Andreas J. Guelzow authored
      2011-06-30  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* dialog-doc-metadata.c (dialog_doc_metadata_transform_str_to_float): new
      	(dialog_doc_metadata_transform_float_to_str): new
      	(cb_dialog_doc_metadata_value_edited):preserve type
      	(dialog_doc_metadata_init_properties_page): allow decimal properties
      	(dialog_doc_metadata_init): register above transforms
      22d7ff9c
    • Andreas J. Guelzow 's avatar
      Permit addition of various property types · 138a3426
      Andreas J. Guelzow authored
      2011-06-30  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* doc-meta-data.ui: add GtkTreeModelFilter
      	* dialog-doc-metadata.c (dialog_doc_metadata_set_gsf_prop): add
      	argument change all callers
      	(dialog_doc_metadata_set_prop): ditto
      	(dialog_doc_metadata_set_gsf_prop): use selected type
      	(cb_dialog_doc_metadata_add_clicked): use selected type
      	(cb_dialog_doc_metadata_ppt_changed): check combobox
      	(cb_dialog_doc_metadata_ppt_type_changed): new
      	(dialog_doc_metadata_init_properties_page): setup combo box
      	(dialog_doc_metadata_init_widgets): handle new store
      138a3426
  5. 30 Jun, 2011 1 commit
    • Andreas J. Guelzow 's avatar
      Make timestamp doc properties editable · cce1bb90
      Andreas J. Guelzow authored
      2011-06-29  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* dialog-doc-metadata.c (dialog_doc_metadata_get_prop_val): add
      	argument and change all callers
      	(dialog_doc_metadata_transform_str_to_timestamp): implement
      	(time2str_go): new
      	(dialog_doc_metadata_add_prop): timestamps are now editable
      	(cb_dialog_doc_metadata_tree_prop_selected): ditto
      cce1bb90
  6. 29 Jun, 2011 2 commits
    • Andreas J. Guelzow 's avatar
      Allow document properties to be added. · 25e9b90c
      Andreas J. Guelzow authored
      2011-06-29  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* doc-meta-data.ui: add value entry and warning label
      	* dialog-doc-metadata.c (cb_dialog_doc_metadata_value_edited): new
      	(cb_dialog_doc_metadata_add_clicked): implement
      	(cb_dialog_doc_metadata_ppt_changed): new
      	(dialog_doc_metadata_init_properties_page): connect callbacks
      	(dialog_doc_metadata_init_widgets): handle new widgets
      25e9b90c
    • Andreas J. Guelzow 's avatar
      Allow document properties to be edited. · c295220d
      Andreas J. Guelzow authored
      2011-06-29  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* doc-meta-data.ui: really remove keywords from description tab
      	* dialog-doc-metadata.c (dialog_doc_metadata_get_value_type): new
      	(dialog_doc_metadata_get_value_type_from_name): new
      	(dialog_doc_metadata_add_prop): add argument, change all callers
      	and store more info
      	(dialog_doc_metadata_get_gsf_prop_val_type): use the *_get_value_type*
      	(dialog_doc_metadata_set_gsf_prop): fix property comparison
      	(dialog_doc_metadata_set_prop): use the converted string to show
      	(cb_dialog_doc_metadata_value_edited): new
      	(cb_dialog_doc_metadata_tree_prop_selected): set instruction label
      	(dialog_doc_metadata_init_properties_page): use more columns in the
      	store and set some info editable
      c295220d
  7. 28 Jun, 2011 6 commits
    • Andreas J. Guelzow 's avatar
      Hide misleading label · dfab8a0d
      Andreas J. Guelzow authored
      2011-06-28  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* doc-meta-data.ui: name the instruction label
      	* dialog-doc-metadata.c (dialog_doc_metadata_init_widgets):
      	initialize instruction label
      	(cb_dialog_doc_metadata_tree_prop_selected): hide instruction label
      	(dialog_doc_metadata_init_properties_page): trigger selection change
      dfab8a0d
    • Andreas J. Guelzow 's avatar
      Part 1 of changes to the properties tab in the document properties dialog · fb95f61f
      Andreas J. Guelzow authored
      2011-06-28  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* doc-meta-data.ui: restructure properties tab
      	* dialog-doc-metadata.c (dialog_doc_metadata_add_prop): remove argument,
      	change all callers, del;ete reference to names combo
      	(dialog_doc_metadata_set_prop): Don't act on new properties widgets
      	(cb_dialog_doc_metadata_keywords_sel_changed): simplify
      	(cb_dialog_doc_metadata_remove_clicked): simplify, don't act on new
      	properties widgets
      	(cb_dialog_doc_metadata_combo_prop_selected): deleted
      	(cb_dialog_doc_metadata_tree_prop_selected): simplify
      	(cb_dialog_doc_metadata_apply_clicked): deleted
      	(dialog_doc_metadata_init_properties_page): adjust for changes in
      	widgets
      	(dialog_doc_metadata_init_widgets): ditto
      fb95f61f
    • Andreas J. Guelzow 's avatar
      Import keywords from xlsx · 20b9e57d
      Andreas J. Guelzow authored
      2011-06-28  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write-docprops.c (xlsx_read_core_keys): implement
      
      2011-06-28  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* dialog-doc-metadata.c (dialog_doc_metadata_update_keywords_changed):
      	fix leak
      	(dialog_doc_metadata_transform_str_to_docprop_vect): fix leak
      20b9e57d
    • Andreas J. Guelzow 's avatar
      whitespace · 86e8fa0e
      Andreas J. Guelzow authored
      86e8fa0e
    • Andreas J. Guelzow 's avatar
      more keyword handling fixes · a6ae6df4
      Andreas J. Guelzow authored
      2011-06-27  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write-docprops.c (xlsx_map_to_keys): new
      	(xlsx_map_prop_name_to_output_fun): connect xlsx_map_to_keys
      	(xlsx_meta_write_props): depend on xlsx_map_prop_name_to_output_fun
      	even for keywords
      
      2011-06-27  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* dialog-doc-metadata.c (dialog_doc_metadata_get_gsf_prop_val_type):
      	GSF_META_NAME_KEYWORDS is of GSF_DOCPROP_VECTOR_TYPE
      a6ae6df4
    • Andreas J. Guelzow 's avatar
      Fix keyword handling in properties dialog. [#653378] · 7e800d4f
      Andreas J. Guelzow authored
      2011-06-27  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* doc-meta-data.ui: add a keyword tab, remove keywords from
      	description tab
      	* dialog-doc-metadata.c (dialog_doc_metadata_transform_str_to_docprop_vect):
      	implement
      	(gnm_docprop_vector_as_string): new
      	(dialog_doc_metadata_transform_docprop_vect_to_str): use
      	gnm_docprop_vector_as_string
      	(dialog_doc_metadata_get_gsf_prop_val_type): a GSF_DOCPROP_VECTOR has
      	its own type
      	(dialog_doc_metadata_set_gsf_prop_val): check the error value
      	(dialog_doc_metadata_set_prop): do not add unnecessary empty properties
      	(cb_dialog_doc_metadata_keywords_changed): deleted
      	(dialog_doc_metadata_init_description_page): remove keyword support
      	(dialog_doc_metadata_update_keywords_changed): new
      	(cb_dialog_doc_metadata_keywords_sel_changed): new
      	(dialog_doc_metadata_update_keyword_list): new
      	(cb_dialog_doc_metadata_keywords_add_clicked): new
      	(cb_dialog_doc_metadata_keywords_remove_clicked): new
      	(cb_dialog_doc_metadata_keyword_edited): new
      	(dialog_doc_metadata_init_keywords_page): new
      	(dialog_doc_metadata_update_prop): add argument, change all callers,
      	call dialog_doc_metadata_update_keyword_list
      	(dialog_doc_metadata_init_widgets): handle new widgets
      7e800d4f
  8. 27 Jun, 2011 2 commits
  9. 26 Jun, 2011 5 commits
    • Andreas J. Guelzow 's avatar
      read custom properties from xlsx files · ac284625
      Andreas J. Guelzow authored
      2011-06-26  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-utils.h (XL_NS_PROP_CUSTOM): new
      	* xlsx-read.c (XLSXReadState): new field meta_prop_name
      	(XL_NS_PROP_CUSTOM): new namespace
      	* xlsx-read-docprops.c (xlsx_read_property_begin): new
      	(xlsx_read_property_end): new
      	(xlsx_read_custom_property_type): new
      	(xlsx_read_custom_property): new
      	(xlsx_read_property_date): new
      	(xlsx_docprops_custom_dtd): new
      	(xlsx_docprops_extended_dtd): add elements
      	(xlsx_read_docprops_custom): new
      	(xlsx_read_docprops): call xlsx_read_docprops_custom
      ac284625
    • Andreas J. Guelzow 's avatar
      Write custom properties in xlsx export · 19f0979f
      Andreas J. Guelzow authored
      2011-06-26  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write.c: new includes (for xlsx-write-docprops.c)
      	* xlsx-write-docprops.c (xlsx_map_time_to_int): new
      	(xlsx_map_to_int): new
      	(xlsx_map_to_bool): new
      	(xlsx_map_to_date_core): new
      	(xlsx_map_prop_name_to_output_fun): new
      	(xlsx_meta_write_props_extended): use xlsx_map_prop_name_to_output_fun
      	(xlsx_map_prop_type): replaced by xlsx_map_prop_name_to_output_fun
      	(xlsx_meta_write_props): use xlsx_map_prop_name_to_output_fun
      	(xlsx_map_to_pid): new
      	(xlsx_meta_write_props_custom): new
      	(xlsx_write_docprops_custom): call xlsx_meta_write_props_custom
      19f0979f
    • Andreas J. Guelzow 's avatar
      Kspread needs the formats implied by Excel · 3503f221
      Andreas J. Guelzow authored
      2011-06-25  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write-docprops.c (xlsx_write_docprops_custom):
      	enable
      	* xlsx-write.c (ns_docprops_custom): new
      	(xlsx_write_fills): Kspread needs the formats implied by
      	Excel
      3503f221
    • Andreas J. Guelzow 's avatar
      fix AppVersion format in xlsx export · c8570e8a
      Andreas J. Guelzow authored
      2011-06-25  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write-docprops.c (xlsx_write_docprops_app): The
      	AppVersion format should really be d.dddd.
      c8570e8a
    • Andreas J. Guelzow 's avatar
      read extended properties from xlsx · 451d89ea
      Andreas J. Guelzow authored
      2011-06-25  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-read-docprops.c (xlsx_read_core_prop_type): renamed
      	to xlsx_read_prop_type
      	(xlsx_read_core_prop): renamed to xlsx_read_prop
      	(xlsx_read_core_prop_dt): renamed to xlsx_read_prop_dt
      	(xlsx_read_prop_int): new
      	(xlsx_read_prop_boolean): new
      	(xlsx_docprops_extended_dtd): new
      	(xlsx_read_docprops_extended): implement
      	* xlsx-read.c (xlsx_ns): add name spaces
      	* xlsx-utils.h (XL_NS_PROP): new
      	(XL_NS_PROP_VT): new
      	* xlsx-write-docprops.c (xlsx_write_docprops_app): The
      	AppVersion format is prescribed to d.dddd.
      451d89ea
  10. 25 Jun, 2011 4 commits
    • Andreas J. Guelzow 's avatar
      Write extended document properties to xlsx · 3d2dd979
      Andreas J. Guelzow authored
      2011-06-25  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write.c (ns_docprops_extended_vt): new
      	* xlsx-write-docprops.c (xlsx_map_prop_name_extended): new
      	(xlsx_meta_write_props_extended): new
      	(xlsx_write_docprops_app): write more properties
      	(xlsx_write_docprops_core): no need to remove the generator
      	meta data, we only write selected props anyways.
      3d2dd979
    • Andreas J. Guelzow 's avatar
      use the predefined fills in xlsx export · 7e210286
      Andreas J. Guelzow authored
      2011-06-25  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write.c (xlsx_write_predefined_fills): new
      	(xlsx_write_fills): use the above
      	(xlsx_find_predefined_fill): new
      	(xlsx_find_fill): use xlsx_find_predefined_fill
      7e210286
    • Andreas J. Guelzow 's avatar
      Read some document properties from XLSX. · 1550d39e
      Andreas J. Guelzow authored
      2011-06-25  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-read-docprops.c (new)
      	* Makefile.am: add xlsx-read-docprops.c
      	* xlsx-utils.h: add XL_NS_PROP_*
      	* xlsx-write.c (xlsx_write_fills): start with some fills
      	expected by Excel
      	(xlsx_write_style): apparently Excel writes apply*
      	attributes always. So do we now.
      	* xlsx-read.c: add some includes, including
      	xlsx-read-docprops.c
      	(xlsx_ns): som emore namespaces
      	(xlsx_file_open): call xlsx_read_docprops from
      	xlsx-read-docprops.c
      1550d39e
    • Andreas J. Guelzow 's avatar
      In xlsx expot povide a deault named style · 444ca6ac
      Andreas J. Guelzow authored
      2011-06-24  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write.c (xlsx_write_style): usually wrte an xfId,
      	write apply* attributes only if they are false (nobody
      	seems to write true ones)
      	(xlsx_write_cellStyleXfs): write a named style record to refer
      	to
      	(xlsx_write_cellXfs): adust call to xlsx_write_style
      	(xlsx_get_style_id): new, extracted from xlsx_write_cells
      	(xlsx_write_cells): use xlsx_get_style_id
      	(xlsx_write_workbook): make sure we write the default style
      	first
      444ca6ac
  11. 24 Jun, 2011 5 commits
  12. 23 Jun, 2011 5 commits
    • Andreas J. Guelzow 's avatar
      Write some document properties to XLSX. · 218fb38e
      Andreas J. Guelzow authored
      2011-06-23  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* xlsx-write.c (ns_docprops_core_cp): new
      	(ns_docprops_core_dc): new
      	(ns_docprops_core_dcmitype): new
      	(ns_docprops_core_dcterms): new
      	(ns_docprops_core_xsi): new
      	* xlsx-write-docprops.c (xlsx_map_prop_type): new
      	(xlsx_map_prop_name): new
      	(xlsx_meta_write_props): new
      	(xlsx_write_docprops_core): imlement
      218fb38e
    • Andreas J. Guelzow 's avatar
      Include generator name and version in xlsx export · 924e00eb
      Andreas J. Guelzow authored
      2011-06-23  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* Makefile.am: add xlsx-write-docprops.c
      	* xlsx-write.c (ns_docprops_extended): new
      	(xlsx_write_workbook): call xlsx_write_docprops
      	* xlsx-write-docprops.c: new
      924e00eb
    • Andreas J. Guelzow 's avatar
      Import print area from ODF · 2fd6f52a
      Andreas J. Guelzow authored
      2011-06-23  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* openoffice-read.c (odf_parse_range_address_or_expr): new, extracted from
      	oo_plot_series
      	(oo_table_start): read table:print and table:print-ranges
      	(odf_page_layout_properties): we will be using table:print instead of
      	do_not_print in gnm:style-print
      	* openoffice-write.c (odf_write_content): write table:print
      	(odf_write_page_layout): do not include do_not_print in gnm:style-print
      
      2011-06-23  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* developer/odf-foreign.txt: update
      2fd6f52a
    • Andreas J. Guelzow 's avatar
      Export repeating rows to ODF · 000a188b
      Andreas J. Guelzow authored
      2011-06-22  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* openoffice-read.c (opendoc_content_dtd): add more items
      	* openoffice-write.c (odf_write_sheet): write table:table-header-rows
      000a188b
    • Andreas J. Guelzow 's avatar
      Export repeating cols to ODF · 6e81cde7
      Andreas J. Guelzow authored
      2011-06-22  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* print.c (load_repeat_range): move from here to
      	* print-info.c (print_load_repeat_range): renaming as we go
      	* print-info.h (print_load_repeat_range): new
      
      2011-06-22  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* openoffice-read.c (oo_table_end): we may have repeating rows w/o
      	repeating columns and vice versa
      	(opendoc_content_dtd): add more items
      	* openoffice-write.c (odf_write_style_cell_properties): don't write
      	attributes outside of elements
      	(odf_write_sheet): write table:table-header-columns as appropriate
      6e81cde7
  13. 22 Jun, 2011 3 commits
    • Andreas J. Guelzow 's avatar
      Import repeating rows and cols from ODF · d634b2ce
      Andreas J. Guelzow authored
      2011-06-22  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* openoffice-read.c (OOParseState): add fields
      	(oo_table_start): initialize repeating rows/cols fields
      	(oo_table_end): save repeating rows/cols data
      	(odf_table_header_rows): new
      	(odf_table_header_rows_end): new
      	(odf_table_header_cols): new
      	(odf_table_header_cols_end): new
      	(opendoc_content_dtd): connect the last four
      d634b2ce
    • Andreas J. Guelzow 's avatar
      ODF import: group print items in state · d347c2db
      Andreas J. Guelzow authored
      2011-06-22  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* openoffice-read.c (OOParseState): group print items into a struct and
      	change references throughout the file
      d347c2db
    • Andreas J. Guelzow 's avatar
      add more elements to avoid the confusion of #653186 · bf669a8b
      Andreas J. Guelzow authored
      2011-06-22  Andreas J. Guelzow <aguelzow@pyrshep.ca>
      
      	* openoffice-read.c (opendoc_content_dtd): add more items
      bf669a8b