Functions

acot (x)

acoth (x)

action_group_add_action (group, act)

action_group_add_actions (group, actions, n, user)

advanced_filter (wbc, dao, database, criteria, unique_only_flag)

agm (a, b)

analysis_tool_advanced_filter_engine (gcc, dao, specs, selector, result)

analysis_tool_anova_single_engine (gcc, dao, specs, selector, result)

analysis_tool_anova_two_factor_engine (gcc, dao, specs, selector, result)

analysis_tool_auto_expression_engine (gcc, dao, specs, selector, result)

analysis_tool_calc_length (info)

analysis_tool_chi_squared_engine (gcc, dao, specs, selector, result)

analysis_tool_correlation_engine (gcc, dao, specs, selector, result)

analysis_tool_covariance_engine (gcc, dao, specs, selector, result)

analysis_tool_descriptive_engine (gcc, dao, specs, selector, result)

analysis_tool_exponential_smoothing_engine (gcc, dao, specs, selector, result)

analysis_tool_fourier_engine (gcc, dao, specs, selector, result)

analysis_tool_frequency_engine (gcc, dao, specs, selector, result)

analysis_tool_ftest_engine (gcc, dao, specs, selector, result)

analysis_tool_generic_b_clean (specs)

analysis_tool_generic_clean (specs)

analysis_tool_get_function (name, dao)

analysis_tool_histogram_engine (gcc, dao, specs, selector, result)

analysis_tool_kaplan_meier_engine (gcc, dao, specs, selector, result)

analysis_tool_moving_average_engine (gcc, dao, specs, selector, result)

analysis_tool_normality_engine (gcc, dao, specs, selector, result)

analysis_tool_one_mean_test_engine (gcc, dao, specs, selector, result)

analysis_tool_principal_components_engine (gcc, dao, specs, selector, result)

analysis_tool_ranking_engine (gcc, dao, specs, selector, result)

analysis_tool_regression_engine (gcc, dao, specs, selector, result)

analysis_tool_sampling_engine (gcc, dao, specs, selector, result)

analysis_tool_sign_test_engine (gcc, dao, specs, selector, result)

analysis_tool_sign_test_two_engine (gcc, dao, specs, selector, result)

analysis_tool_signed_rank_test_engine (gcc, dao, specs, selector, result)

analysis_tool_signed_rank_test_two_engine (gcc, dao, specs, selector, result)

analysis_tool_table (dao, info, title, functionname, full_table)

analysis_tool_ttest_eqvar_engine (gcc, dao, specs, selector, result)

analysis_tool_ttest_neqvar_engine (gcc, dao, specs, selector, result)

analysis_tool_ttest_paired_engine (gcc, dao, specs, selector, result)

analysis_tool_wilcoxon_mann_whitney_engine (gcc, dao, specs, selector, result)

analysis_tool_ztest_engine (gcc, dao, specs, selector, result)

analysis_tools_write_label (val, dao, info, x, y, i)

analysis_tools_write_label_ftest (val, dao, x, y, labels, i)

annual_year_basis (value_date, basis, date_conv)

auto_style_format_suggest (texpr, epos)

autocorrect_tool (input)

autofill_fill (sheet, default_increment, base_col, base_row, w, h, end_col, end_row)

autofill_hint (sheet, default_increment, base_col, base_row, w, h, end_col, end_row)

bd0 (x, M)

bessel_i (x, alpha)

bessel_j (x, alpha)

bessel_k (x, alpha)

bessel_y (x, alpha)

beta (a, b)

canvas_get_position (canvas, x, y, px, py)

canvas_get_screen_position (canvas, x, y, ix, iy)

cell_set_array (sheet, r, texpr)

cell_set_array_formula_undo (sr, texpr)

cell_set_comment (sheet, pos, author, text, markup)

cellpos_equal (a, b)

cellpos_hash (key)

cellpos_init_cellref (cp, cr, pos, base_sheet)

cellpos_init_cellref_ss (res, cell_ref, pos, ss)

cellregion_cmd_size (cr)

cellregion_invalidate_sheet (cr, sheet)

cellregion_ref (cr)

cellregion_to_string (cr, only_visible, date_conv)

cellregion_to_xml (cr)

cellregion_unref (cr)

check_for_plugins_missing (ids, parent)

clipboard_copy_obj (sheet, objects)

clipboard_copy_range (sheet, r)

clipboard_copy_range_undo (sheet, r)

clipboard_copy_ranges_undo (sheet, ranges)

clipboard_paste_region (cr, pt, cc)

cmd_area_set_array_expr (wbc, sv, new_texpr)

cmd_area_set_text (wbc, sv, text, markup)

cmd_autofill (wbc, sheet, default_increment, base_col, base_row, w, h, end_col, end_row, inverse_autofill)

cmd_autofilter_add_remove (wbc)

cmd_autofilter_set_condition (wbc, filter, i, cond)

cmd_autofit_selection (wbc, sv, sheet, fit_width, selectionlist)

cmd_cell_range_is_locked_effective (sheet, range, wbc, cmd_name)

cmd_change_meta_data (wbc, changes, removed)

cmd_colrow_std_size (wbc, sheet, is_cols, new_default)

cmd_context_error_calc (cc, msg)

cmd_context_error_splits_array (cc, cmd, array)

cmd_context_error_splits_merge (cc, merge)

cmd_copyrel (wbc, dx, dy, name)

cmd_create_data_table (wbc, sheet, r, col_input, row_input)

cmd_data_shuffle (wbc, sc, sheet)

cmd_define_name (wbc, name, pp, texpr, descriptor)

cmd_delete_cols (wbc, sheet, start_col, count)

cmd_delete_rows (wbc, sheet, start_row, count)

cmd_generic (wbc, text, undo, redo)

cmd_generic_with_size (wbc, text, size, undo, redo)

cmd_global_outline_change (wbc, is_cols, depth)

cmd_goal_seek (wbc, cell, ov, nv)

cmd_insert_cols (wbc, sheet, start_col, count)

cmd_insert_rows (wbc, sheet, start_row, count)

cmd_merge_cells (wbc, sheet, selection, center)

cmd_merge_data (wbc, sheet, merge_zone, merge_fields, merge_data)

cmd_object_raise (wbc, so, dir)

cmd_objects_delete (wbc, objects, name)

cmd_objects_move (wbc, objects, anchors, objects_created, name)

cmd_page_break_toggle (wbc, sheet, is_vert)

cmd_page_breaks_clear (wbc, sheet)

cmd_paste (wbc, pt)

cmd_paste_copy (wbc, pt, content)

cmd_paste_cut (wbc, info, move_selection, cmd_descriptor)

cmd_paste_to_selection (wbc, dest_sv, paste_flags)

cmd_print_setup (wbc, sheet, pi)

cmd_remove_name (wbc, nexpr)

cmd_rename_sheet (wbc, sheet, new_name)

cmd_reorganize_sheets (wbc, old_state, undo_sheet)

cmd_rescope_name (wbc, nexpr, scope)

cmd_resize_colrow (wbc, sheet, is_col, selection, new_size)

cmd_resize_sheets (wbc, sheets, cols, rows)

cmd_scenario_mngr (wbc, sc, undo)

cmd_search_replace (wbc, sr)

cmd_selection_autoformat (wbc, ft)

cmd_selection_clear (wbc, clear_flags)

cmd_selection_colrow_hide (wbc, is_cols, visible)

cmd_selection_format (wbc, style, borders, opt_translated_name)

cmd_selection_format_toggle_font_style (wbc, style, t)

cmd_selection_group (wbc, is_cols, group)

cmd_selection_hyperlink (wbc, style, opt_translated_name, opt_content)

cmd_selection_outline_change (wbc, is_cols, index, depth)

cmd_set_comment (wbc, sheet, pos, new_text, attr, new_author)

cmd_set_text (wbc, sheet, pos, new_text, markup, autocorrect)

cmd_shift_cols (wbc, sheet, start_col, end_col, row, count)

cmd_shift_rows (wbc, sheet, col, start_row, end_row, count)

cmd_slicer_refresh (wbc)

cmd_so_component_config (wbc, so, n_obj, o_obj)

cmd_so_graph_config (wbc, sog, n_graph, o_graph)

cmd_so_set_adjustment (wbc, so, lnk, horizontal, lower, upper, step, page, undo_label)

cmd_so_set_button (wbc, so, lnk, old_label, new_label)

cmd_so_set_checkbox (wbc, so, lnk, old_label, new_label)

cmd_so_set_frame_label (wbc, so, old_label, new_label)

cmd_so_set_links (wbc, so, output, content, as_index)

cmd_so_set_radio_button (wbc, so, lnk, old_label, new_label, old_value, new_value)

cmd_so_set_value (wbc, text, pref, new_val, sheet)

cmd_sort (wbc, data)

cmd_tabulate (wbc, data)

cmd_text_to_columns (wbc, src, src_sheet, target, target_sheet, content)

cmd_toggle_rtl (wbc, sheet)

cmd_trunc_descriptor (src, truncated)

cmd_unmerge_cells (wbc, sheet, selection)

cmd_zoom (wbc, sheets, factor)

collect_floats_value (val, ep, flags, n, error)

collect_floats_value_with_info (val, ep, flags, n, info, error)

colrow_autofit (sheet, r, is_cols, ignore_strings, min_current, min_default, indices, sizes)

colrow_autofit_col (sheet, r)

colrow_autofit_row (sheet, r)

colrow_compute_pixel_scale (sheet, horizontal)

colrow_compute_pixels_from_pts (cri, sheet, horizontal, scale)

colrow_compute_pts_from_pixels (cri, sheet, horizontal, scale)

colrow_find_outline_bound (sheet, is_cols, index, depth, inc)

colrow_free (cri)

colrow_get_index_list (first, last, list)

colrow_index_list_copy (list)

colrow_index_list_to_string (list, is_cols, is_single)

colrow_set_visibility (sheet, is_cols, visible, first, last)

colrow_set_visibility_list (sheet, is_cols, visible, list)

colrow_state_group_destroy (set)

colrow_state_list_destroy (list)

colrow_state_list_foreach (list, sheet, is_cols, base, callback, *user_data)

colrow_vis_list_length (list)

combin (n, k)

complex_fact (z)

complex_from_string (dst, src)

complex_gamma (z)

complex_igamma (a, z, lower, regularized)

complex_invalid_p (src)

complex_to_string (src, imunit)

conf_get_autocorrect_dir_node ()

conf_get_autocorrect_first_letter ()

conf_get_autocorrect_first_letter_list ()

conf_get_autocorrect_first_letter_list_node ()

conf_get_autocorrect_first_letter_node ()

conf_get_autocorrect_init_caps ()

conf_get_autocorrect_init_caps_list ()

conf_get_autocorrect_init_caps_list_node ()

conf_get_autocorrect_init_caps_node ()

conf_get_autocorrect_names_of_days ()

conf_get_autocorrect_names_of_days_node ()

conf_get_autocorrect_replace ()

conf_get_autocorrect_replace_node ()

conf_get_autoformat_dir_node ()

conf_get_autoformat_extra_dirs ()

conf_get_autoformat_extra_dirs_node ()

conf_get_autoformat_sys_dir ()

conf_get_autoformat_sys_dir_node ()

conf_get_autoformat_usr_dir ()

conf_get_autoformat_usr_dir_node ()

conf_get_core_defaultfont_bold ()

conf_get_core_defaultfont_bold_node ()

conf_get_core_defaultfont_dir_node ()

conf_get_core_defaultfont_italic ()

conf_get_core_defaultfont_italic_node ()

conf_get_core_defaultfont_name ()

conf_get_core_defaultfont_name_node ()

conf_get_core_defaultfont_size ()

conf_get_core_defaultfont_size_node ()

conf_get_core_file_save_def_overwrite ()

conf_get_core_file_save_def_overwrite_node ()

conf_get_core_file_save_dir_node ()

conf_get_core_file_save_extension_check_disabled ()

conf_get_core_file_save_extension_check_disabled_node ()

conf_get_core_file_save_single_sheet ()

conf_get_core_file_save_single_sheet_node ()

conf_get_core_gui_cells_dir_node ()

conf_get_core_gui_cells_extension_markers ()

conf_get_core_gui_cells_extension_markers_node ()

conf_get_core_gui_cells_function_markers ()

conf_get_core_gui_cells_function_markers_node ()

conf_get_core_gui_editing_autocomplete ()

conf_get_core_gui_editing_autocomplete_min_chars ()

conf_get_core_gui_editing_autocomplete_min_chars_node ()

conf_get_core_gui_editing_autocomplete_node ()

conf_get_core_gui_editing_dir_node ()

conf_get_core_gui_editing_enter_moves_dir ()

conf_get_core_gui_editing_enter_moves_dir_node ()

conf_get_core_gui_editing_function_argument_tooltips ()

conf_get_core_gui_editing_function_argument_tooltips_node ()

conf_get_core_gui_editing_function_name_tooltips ()

conf_get_core_gui_editing_function_name_tooltips_node ()

conf_get_core_gui_editing_recalclag ()

conf_get_core_gui_editing_recalclag_node ()

conf_get_core_gui_editing_transitionkeys ()

conf_get_core_gui_editing_transitionkeys_node ()

conf_get_core_gui_screen_dir_node ()

conf_get_core_gui_screen_horizontaldpi ()

conf_get_core_gui_screen_horizontaldpi_node ()

conf_get_core_gui_screen_verticaldpi ()

conf_get_core_gui_screen_verticaldpi_node ()

conf_get_core_gui_toolbars_dir_node ()

conf_get_core_gui_toolbars_format_position ()

conf_get_core_gui_toolbars_format_position_node ()

conf_get_core_gui_toolbars_format_visible ()

conf_get_core_gui_toolbars_format_visible_node ()

conf_get_core_gui_toolbars_object_position ()

conf_get_core_gui_toolbars_object_position_node ()

conf_get_core_gui_toolbars_object_visible ()

conf_get_core_gui_toolbars_object_visible_node ()

conf_get_core_gui_toolbars_standard_position ()

conf_get_core_gui_toolbars_standard_position_node ()

conf_get_core_gui_toolbars_standard_visible ()

conf_get_core_gui_toolbars_standard_visible_node ()

conf_get_core_gui_window_dir_node ()

conf_get_core_gui_window_x ()

conf_get_core_gui_window_x_node ()

conf_get_core_gui_window_y ()

conf_get_core_gui_window_y_node ()

conf_get_core_gui_window_zoom ()

conf_get_core_gui_window_zoom_node ()

conf_get_core_sort_default_ascending ()

conf_get_core_sort_default_ascending_node ()

conf_get_core_sort_default_by_case ()

conf_get_core_sort_default_by_case_node ()

conf_get_core_sort_default_dir_node ()

conf_get_core_sort_default_retain_formats ()

conf_get_core_sort_default_retain_formats_node ()

conf_get_core_sort_dialog_dir_node ()

conf_get_core_sort_dialog_max_initial_clauses ()

conf_get_core_sort_dialog_max_initial_clauses_node ()

conf_get_core_workbook_autosave_time ()

conf_get_core_workbook_autosave_time_node ()

conf_get_core_workbook_dir_node ()

conf_get_core_workbook_n_cols ()

conf_get_core_workbook_n_cols_node ()

conf_get_core_workbook_n_rows ()

conf_get_core_workbook_n_rows_node ()

conf_get_core_workbook_n_sheet ()

conf_get_core_workbook_n_sheet_node ()

conf_get_core_xml_compression_level ()

conf_get_core_xml_compression_level_node ()

conf_get_core_xml_dir_node ()

conf_get_cut_and_paste_dir_node ()

conf_get_cut_and_paste_prefer_clipboard ()

conf_get_cut_and_paste_prefer_clipboard_node ()

conf_get_detachable_toolbars ()

conf_get_dialogs_rs_dir_node ()

conf_get_dialogs_rs_unfocused ()

conf_get_dialogs_rs_unfocused_node ()

conf_get_functionselector_dir_node ()

conf_get_functionselector_num_of_recent ()

conf_get_functionselector_num_of_recent_node ()

conf_get_functionselector_recentfunctions ()

conf_get_functionselector_recentfunctions_node ()

conf_get_long_desc (node)

conf_get_page_setup ()

conf_get_plugin_glpk_dir_node ()

conf_get_plugin_glpk_glpsol_path ()

conf_get_plugin_glpk_glpsol_path_node ()

conf_get_plugin_latex_dir_node ()

conf_get_plugin_latex_use_utf8 ()

conf_get_plugin_latex_use_utf8_node ()

conf_get_plugin_lpsolve_dir_node ()

conf_get_plugin_lpsolve_lpsolve_path ()

conf_get_plugin_lpsolve_lpsolve_path_node ()

conf_get_plugins_activate_newplugins ()

conf_get_plugins_activate_newplugins_node ()

conf_get_plugins_active ()

conf_get_plugins_active_node ()

conf_get_plugins_dir_node ()

conf_get_plugins_extra_dirs ()

conf_get_plugins_extra_dirs_node ()

conf_get_plugins_file_states ()

conf_get_plugins_file_states_node ()

conf_get_plugins_known ()

conf_get_plugins_known_node ()

conf_get_print_settings ()

conf_get_printer_decoration_font ()

conf_get_printsetup_across_then_down ()

conf_get_printsetup_across_then_down_node ()

conf_get_printsetup_all_sheets ()

conf_get_printsetup_all_sheets_node ()

conf_get_printsetup_center_horizontally ()

conf_get_printsetup_center_horizontally_node ()

conf_get_printsetup_center_vertically ()

conf_get_printsetup_center_vertically_node ()

conf_get_printsetup_dir_node ()

conf_get_printsetup_footer ()

conf_get_printsetup_footer_node ()

conf_get_printsetup_gtk_setting ()

conf_get_printsetup_gtk_setting_node ()

conf_get_printsetup_header ()

conf_get_printsetup_header_node ()

conf_get_printsetup_hf_font_bold ()

conf_get_printsetup_hf_font_bold_node ()

conf_get_printsetup_hf_font_italic ()

conf_get_printsetup_hf_font_italic_node ()

conf_get_printsetup_hf_font_name ()

conf_get_printsetup_hf_font_name_node ()

conf_get_printsetup_hf_font_size ()

conf_get_printsetup_hf_font_size_node ()

conf_get_printsetup_hf_left ()

conf_get_printsetup_hf_left_node ()

conf_get_printsetup_hf_middle ()

conf_get_printsetup_hf_middle_node ()

conf_get_printsetup_hf_right ()

conf_get_printsetup_hf_right_node ()

conf_get_printsetup_margin_bottom ()

conf_get_printsetup_margin_bottom_node ()

conf_get_printsetup_margin_gtk_bottom ()

conf_get_printsetup_margin_gtk_bottom_node ()

conf_get_printsetup_margin_gtk_left ()

conf_get_printsetup_margin_gtk_left_node ()

conf_get_printsetup_margin_gtk_right ()

conf_get_printsetup_margin_gtk_right_node ()

conf_get_printsetup_margin_gtk_top ()

conf_get_printsetup_margin_gtk_top_node ()

conf_get_printsetup_margin_top ()

conf_get_printsetup_margin_top_node ()

conf_get_printsetup_paper ()

conf_get_printsetup_paper_node ()

conf_get_printsetup_paper_orientation ()

conf_get_printsetup_paper_orientation_node ()

conf_get_printsetup_preferred_unit ()

conf_get_printsetup_preferred_unit_node ()

conf_get_printsetup_print_black_n_white ()

conf_get_printsetup_print_black_n_white_node ()

conf_get_printsetup_print_even_if_only_styles ()

conf_get_printsetup_print_even_if_only_styles_node ()

conf_get_printsetup_print_grid_lines ()

conf_get_printsetup_print_grid_lines_node ()

conf_get_printsetup_print_titles ()

conf_get_printsetup_print_titles_node ()

conf_get_printsetup_repeat_left ()

conf_get_printsetup_repeat_left_node ()

conf_get_printsetup_repeat_top ()

conf_get_printsetup_repeat_top_node ()

conf_get_printsetup_scale_height ()

conf_get_printsetup_scale_height_node ()

conf_get_printsetup_scale_percentage ()

conf_get_printsetup_scale_percentage_node ()

conf_get_printsetup_scale_percentage_value ()

conf_get_printsetup_scale_percentage_value_node ()

conf_get_printsetup_scale_width ()

conf_get_printsetup_scale_width_node ()

conf_get_root ()

conf_get_searchreplace_change_cell_expressions ()

conf_get_searchreplace_change_cell_expressions_node ()

conf_get_searchreplace_change_cell_other ()

conf_get_searchreplace_change_cell_other_node ()

conf_get_searchreplace_change_cell_strings ()

conf_get_searchreplace_change_cell_strings_node ()

conf_get_searchreplace_change_comments ()

conf_get_searchreplace_change_comments_node ()

conf_get_searchreplace_columnmajor ()

conf_get_searchreplace_columnmajor_node ()

conf_get_searchreplace_dir_node ()

conf_get_searchreplace_error_behaviour ()

conf_get_searchreplace_error_behaviour_node ()

conf_get_searchreplace_ignore_case ()

conf_get_searchreplace_ignore_case_node ()

conf_get_searchreplace_keep_strings ()

conf_get_searchreplace_keep_strings_node ()

conf_get_searchreplace_preserve_case ()

conf_get_searchreplace_preserve_case_node ()

conf_get_searchreplace_query ()

conf_get_searchreplace_query_node ()

conf_get_searchreplace_regex ()

conf_get_searchreplace_regex_node ()

conf_get_searchreplace_scope ()

conf_get_searchreplace_scope_node ()

conf_get_searchreplace_search_results ()

conf_get_searchreplace_search_results_node ()

conf_get_searchreplace_whole_words_only ()

conf_get_searchreplace_whole_words_only_node ()

conf_get_short_desc (node)

conf_get_stf_export_dir_node ()

conf_get_stf_export_encoding ()

conf_get_stf_export_encoding_node ()

conf_get_stf_export_format ()

conf_get_stf_export_format_node ()

conf_get_stf_export_locale ()

conf_get_stf_export_locale_node ()

conf_get_stf_export_quoting ()

conf_get_stf_export_quoting_node ()

conf_get_stf_export_separator ()

conf_get_stf_export_separator_node ()

conf_get_stf_export_stringindicator ()

conf_get_stf_export_stringindicator_node ()

conf_get_stf_export_terminator ()

conf_get_stf_export_terminator_node ()

conf_get_stf_export_transliteration ()

conf_get_stf_export_transliteration_node ()

conf_get_toolbar_position (name)

conf_get_toolbar_style ()

conf_get_toolbar_style_dir_node ()

conf_get_toolbar_visible (name)

conf_get_undo_dir_node ()

conf_get_undo_max_descriptor_width ()

conf_get_undo_max_descriptor_width_node ()

conf_get_undo_maxnum ()

conf_get_undo_maxnum_node ()

conf_get_undo_show_sheet_name ()

conf_get_undo_show_sheet_name_node ()

conf_get_undo_size ()

conf_get_undo_size_node ()

conf_set_autocorrect_first_letter (x)

conf_set_autocorrect_first_letter_list (x)

conf_set_autocorrect_init_caps (x)

conf_set_autocorrect_init_caps_list (x)

conf_set_autocorrect_names_of_days (x)

conf_set_autocorrect_replace (x)

conf_set_autoformat_extra_dirs (x)

conf_set_autoformat_sys_dir (x)

conf_set_autoformat_usr_dir (x)

conf_set_core_defaultfont_bold (x)

conf_set_core_defaultfont_italic (x)

conf_set_core_defaultfont_name (x)

conf_set_core_defaultfont_size (x)

conf_set_core_file_save_def_overwrite (x)

conf_set_core_file_save_extension_check_disabled (x)

conf_set_core_file_save_single_sheet (x)

conf_set_core_gui_cells_extension_markers (x)

conf_set_core_gui_cells_function_markers (x)

conf_set_core_gui_editing_autocomplete (x)

conf_set_core_gui_editing_autocomplete_min_chars (x)

conf_set_core_gui_editing_enter_moves_dir (x)

conf_set_core_gui_editing_function_argument_tooltips (x)

conf_set_core_gui_editing_function_name_tooltips (x)

conf_set_core_gui_editing_recalclag (x)

conf_set_core_gui_editing_transitionkeys (x)

conf_set_core_gui_screen_horizontaldpi (x)

conf_set_core_gui_screen_verticaldpi (x)

conf_set_core_gui_toolbars_format_position (x)

conf_set_core_gui_toolbars_format_visible (x)

conf_set_core_gui_toolbars_object_position (x)

conf_set_core_gui_toolbars_object_visible (x)

conf_set_core_gui_toolbars_standard_position (x)

conf_set_core_gui_toolbars_standard_visible (x)

conf_set_core_gui_window_x (x)

conf_set_core_gui_window_y (x)

conf_set_core_gui_window_zoom (x)

conf_set_core_sort_default_ascending (x)

conf_set_core_sort_default_by_case (x)

conf_set_core_sort_default_retain_formats (x)

conf_set_core_sort_dialog_max_initial_clauses (x)

conf_set_core_workbook_autosave_time (x)

conf_set_core_workbook_n_cols (x)

conf_set_core_workbook_n_rows (x)

conf_set_core_workbook_n_sheet (x)

conf_set_core_xml_compression_level (x)

conf_set_cut_and_paste_prefer_clipboard (x)

conf_set_dialogs_rs_unfocused (x)

conf_set_functionselector_num_of_recent (x)

conf_set_functionselector_recentfunctions (x)

conf_set_page_setup (setup)

conf_set_persistence (persist)

conf_set_plugin_glpk_glpsol_path (x)

conf_set_plugin_latex_use_utf8 (x)

conf_set_plugin_lpsolve_lpsolve_path (x)

conf_set_plugins_activate_newplugins (x)

conf_set_plugins_active (x)

conf_set_plugins_extra_dirs (x)

conf_set_plugins_file_states (x)

conf_set_plugins_known (x)

conf_set_print_settings (settings)

conf_set_printsetup_across_then_down (x)

conf_set_printsetup_all_sheets (x)

conf_set_printsetup_center_horizontally (x)

conf_set_printsetup_center_vertically (x)

conf_set_printsetup_footer (x)

conf_set_printsetup_gtk_setting (x)

conf_set_printsetup_header (x)

conf_set_printsetup_hf_font_bold (x)

conf_set_printsetup_hf_font_italic (x)

conf_set_printsetup_hf_font_name (x)

conf_set_printsetup_hf_font_size (x)

conf_set_printsetup_hf_left (x)

conf_set_printsetup_hf_middle (x)

conf_set_printsetup_hf_right (x)

conf_set_printsetup_margin_bottom (x)

conf_set_printsetup_margin_gtk_bottom (x)

conf_set_printsetup_margin_gtk_left (x)

conf_set_printsetup_margin_gtk_right (x)

conf_set_printsetup_margin_gtk_top (x)

conf_set_printsetup_margin_top (x)

conf_set_printsetup_paper (x)

conf_set_printsetup_paper_orientation (x)

conf_set_printsetup_preferred_unit (x)

conf_set_printsetup_print_black_n_white (x)

conf_set_printsetup_print_even_if_only_styles (x)

conf_set_printsetup_print_grid_lines (x)

conf_set_printsetup_print_titles (x)

conf_set_printsetup_repeat_left (x)

conf_set_printsetup_repeat_top (x)

conf_set_printsetup_scale_height (x)

conf_set_printsetup_scale_percentage (x)

conf_set_printsetup_scale_percentage_value (x)

conf_set_printsetup_scale_width (x)

conf_set_searchreplace_change_cell_expressions (x)

conf_set_searchreplace_change_cell_other (x)

conf_set_searchreplace_change_cell_strings (x)

conf_set_searchreplace_change_comments (x)

conf_set_searchreplace_columnmajor (x)

conf_set_searchreplace_error_behaviour (x)

conf_set_searchreplace_ignore_case (x)

conf_set_searchreplace_keep_strings (x)

conf_set_searchreplace_preserve_case (x)

conf_set_searchreplace_query (x)

conf_set_searchreplace_regex (x)

conf_set_searchreplace_scope (x)

conf_set_searchreplace_search_results (x)

conf_set_searchreplace_whole_words_only (x)

conf_set_stf_export_encoding (x)

conf_set_stf_export_format (x)

conf_set_stf_export_locale (x)

conf_set_stf_export_quoting (x)

conf_set_stf_export_separator (x)

conf_set_stf_export_stringindicator (x)

conf_set_stf_export_terminator (x)

conf_set_stf_export_transliteration (x)

conf_set_toolbar_position (name, x)

conf_set_toolbar_style (x)

conf_set_toolbar_visible (name, x)

conf_set_undo_max_descriptor_width (x)

conf_set_undo_maxnum (x)

conf_set_undo_show_sheet_name (x)

conf_set_undo_size (x)

convert_to_tooltip (ref_widget, widget)

cot (x)

coth (x)

cpp (src, vars)

create_popup_menu (elements, handler, user_data, display_filter, sensitive_filter, event)

create_tooltip (ref_widget)

css_debug_color (name, color)

css_debug_int (name, i)

data_shuffling_free (st)

data_shuffling_redo (st)

date_add_days (d, n)

date_add_months (d, n)

date_add_years (d, n)

datetime_allow_negative ()

datetime_value_to_g (res, v, conv)

datetime_value_to_seconds (v, conv)

datetime_value_to_serial (v, conv)

datetime_value_to_serial_raw (v, conv)

dbeta (x, a, b, give_log)

dbinom (x, n, psuc, give_log)

dbinom_raw (x, n, p, q, give_log)

dcauchy (x, location, scale, give_log)

dchisq (x, df, give_log)

debug_flag (flag)

dependent_managed_get_expr (dep)

dependent_managed_init (dep, sheet)

dependent_managed_set_expr (dep, texpr)

dependent_managed_set_sheet (dep, sheet)

dependent_type_register (klass)

dependent_types_init ()

dependent_types_shutdown ()

dependents_dump (wb)

dependents_invalidate_sheet (sheet, destroy)

dependents_link (deps)

dependents_relocate (info)

dependents_revive_sheet (sheet)

dependents_workbook_destroy (wb)

dexp (x, scale, give_log)

df (x, n1, n2, give_log)

dgamma (x, shape, scale, give_log)

dgeom (x, psuc, give_log)

dhyper (x, r, b, n, give_log)

dialog_about (wbcg)

dialog_advanced_filter (wbcg)

dialog_anova_single_factor_tool (wbcg, sheet)

dialog_anova_two_factor_tool (wbcg, sheet)

dialog_auto_filter (wbcg, f, i, is_expr, cur)

dialog_autoformat (wbcg)

dialog_autosave (wbcg)

dialog_autosave_prompt (wbcg)

dialog_average_tool (wbcg, sheet)

dialog_cell_comment (wbcg, sheet, pos)

dialog_cell_format (wbcg, pageno, pages)

dialog_cell_format_cond (wbcg)

dialog_cell_format_select_style (wbcg, pages, w, style, closure)

dialog_cell_format_style_added (closure, style)

dialog_cell_sort (wbcg)

dialog_chi_square_tool (wbcg, sheet, independence)

dialog_col_width (wbcg, set_default)

dialog_consolidate (wbcg)

dialog_correlation_tool (wbcg, sheet)

dialog_covariance_tool (wbcg, sheet)

dialog_data_slicer (wbcg, create)

dialog_data_table (wbcg)

dialog_define_names (wbcg)

dialog_delete_cells (wbcg)

dialog_descriptive_stat_tool (wbcg, sheet)

dialog_doc_metadata_new (wbcg, page)

dialog_exp_smoothing_tool (wbcg, sheet)

dialog_fill_series (wbcg)

dialog_formula_guru (wbcg, func)

dialog_fourier_tool (wbcg, sheet)

dialog_frequency_tool (wbcg, sheet)

dialog_ftest_tool (wbcg, sheet)

dialog_function_select (wbcg, key)

dialog_function_select_help (wbcg)

dialog_function_select_paste (wbcg, from_, to)

dialog_get_password (parent, filename)

dialog_goal_seek (wbcg, sheet)

dialog_goto_cell (wbcg)

dialog_histogram_tool (wbcg, sheet)

dialog_hyperlink (wbcg, sc)

dialog_insert_cells (wbcg)

dialog_kaplan_meier_tool (wbcg, sheet)

dialog_merge (wbcg)

dialog_new_view (wbcg)

dialog_normality_tool (wbcg, sheet)

dialog_one_mean_test_tool (wbcg, sheet)

dialog_paste_names (wbcg)

dialog_paste_special (wbcg)

dialog_plugin_manager (wbcg)

dialog_preferences (wbcg, page)

dialog_principal_components_tool (wbcg, sheet)

dialog_printer_setup (wbcg, sheet)

dialog_quit (wbcg)

dialog_raise_if_exists (wbcg, key)

dialog_random_cor_tool (wbcg, sheet)

dialog_random_tool (wbcg, sheet)

dialog_ranking_tool (wbcg, sheet)

dialog_recent_used (wbcg)

dialog_regression_tool (wbcg, sheet)

dialog_row_height (wbcg, set_default)

dialog_sampling_tool (wbcg, sheet)

dialog_scenario_add (wbcg)

dialog_scenarios (wbcg)

dialog_search (wbcg)

dialog_search_replace_query (wbcg, sr, location, old_text, new_text)

dialog_setup_destroy_handlers (dialog, wbcg, what)

dialog_sheet_compare (wbcg)

dialog_sheet_order (wbcg)

dialog_sheet_rename (wbcg, sheet)

dialog_sheet_resize (wbcg)

dialog_shuffle (wbcg)

dialog_sign_test_tool (wbcg, sheet, type)

dialog_sign_test_two_tool (wbcg, sheet, type)

dialog_simulation (wbcg, sheet)

dialog_so_list (wbcg, so)

dialog_so_size (wbcg, so)

dialog_so_styled (wbcg, so, default_style, title, extent)

dialog_solver (wbcg, sheet)

dialog_tabulate (wbcg, sheet)

dialog_tool_preset_to_range (state)

dialog_ttest_tool (wbcg, sheet, test)

dialog_wilcoxon_m_w_tool (wbcg, sheet)

dialog_workbook_attr (wbcg)

dialog_zoom (wbcg, sheet)

diff_sheets (actions, user, old_sheet, new_sheet)

diff_workbooks (actions, user, old_wb, new_wb)

digamma (x)

discpfuncinverter (p, shape, lower_tail, log_p, xlow, xhigh, x0, pfunc)

dlnorm (x, logmean, logsd, give_log)

dnbinom (x, n, psuc, give_log)

dnorm (x, mu, sigma, give_log)

do_tabulation (wbc, data)

dpois (x, lambda_, give_log)

dpois_raw (x, lambda_, give_log)

drayleigh (x, scale, give_log)

dt (x, n, give_log)

dweibull (x, shape, scale, give_log)

editable_enters (window, editable)

entry_to_float_with_format (entry, the_float, update, format)

entry_to_float_with_format_default (entry, the_float, update, format, num)

entry_to_int (entry, the_int, update)

error_array ()

error_calc ()

error_in_entry (state, entry, err_str)

eval_info_get_arg_count (ei)

eval_info_get_func (ei)

excel_search_impl (needle, haystack, skip)

expmx2h (x)

expr_cell_deriv (y, x)

expr_cell_deriv_value (y, x)

expr_conv_quote (convs, str)

expr_deriv_shutdown_ ()

expr_lex_all (str, pp, flags, convs)

expr_list_as_string (argc, argv, out)

expr_list_copy (list)

expr_list_unref (list)

expr_name_add_dep (nexpr, dep)

expr_name_as_string (nexpr, pp, fmt)

expr_name_check_for_loop (name, texpr)

expr_name_cmp_by_name (a, b)

expr_name_downgrade_to_placeholder (nexpr)

expr_name_eval (nexpr, pos, flags)

expr_name_in_use (nexpr)

expr_name_is_active (nexpr)

expr_name_is_placeholder (ne)

expr_name_lookup (pos, name)

expr_name_name (nexpr)

expr_name_new (name)

expr_name_perm_add (sheet, name, texpr, is_editable)

expr_name_ref (nexpr)

expr_name_remove (nexpr)

expr_name_remove_dep (nexpr, dep)

expr_name_set_expr (nexpr, texpr)

expr_name_set_expr_undo_new (nexpr)

expr_name_set_is_placeholder (nexpr, is_placeholder)

expr_name_set_name (nexpr, new_name)

expr_name_set_pos (nexpr, pp)

expr_name_unref (nexpr)

expr_name_validate (name)

expr_parse_str (str, pp, flags, convs, error)

fact (x)

fact2 (x)

factx (x, expb)

file_saver_common_export_option (fs, wb, key, value)

file_saver_get_sheet (fs, wbv)

file_saver_get_sheets (fs, wbv, default_all)

fill_series_engine (gcc, dao, specs, selector, result)

filter_show_all (wbc)

find_column_of_field (ep, database, field)

find_rows_that_match (sheet, first_col, first_row, last_col, last_row, criterias, unique_only)

float_equal (a, b)

float_hash (d)

float_range_function (argv, ei, func, flags, func_error)

float_range_function2 (val0, val1, ei, func, flags, func_error)

float_range_function2d (val0, val1, ei, func, flags, func_error, *data)

float_to_entry (entry, the_float)

focus_on_entry (entry)

font_equal (v, v2)

font_hash (v)

font_override_codepage (font_name)

format_for_date_editing (cell)

format_frob_slashes (s)

format_has_hour (fmt, value)

format_import (fmt, flags)

format_is_date_for_value (fmt, value)

format_is_time_for_value (fmt, value)

format_layout (result, metrics, format, value, col_width, date_conv, unicode_minus)

format_match (text, cur_fmt, date_conv)

format_match_datetime (text, date_conv, month_before_day, add_format, presume_date)

format_match_decimal_number_with_locale (text, family, curr, thousand, decimal)

format_match_number (text, cur_fmt, date_conv)

format_match_simple (text)

format_month_before_day (fmt, value)

format_sel_new ()

format_sel_set_value (nfs, value)

format_specialize (fmt, value)

format_value (format, value, col_width, date_conv)

format_value_gstring (str, format, value, col_width, date_conv)

format_value_layout (layout, format, value, col_width, date_conv)

free_criterias (criterias)

ft_category_group_cmp (a, b)

ft_category_group_list_free (category_groups)

ft_category_group_list_get ()

ft_compare_name (a, b)

func_group_fetch (name, translation)

func_group_get_nth (n)

function_call_with_exprs (ei)

function_call_with_values (ep, name, argc, values)

function_def_call_with_values (ep, fn, argc, values)

function_iterate_argument_values (ep, callback, callback_closure, argc, argv, strict, iter_flags)

gamma (x)

gammax (x, expb)

get_argv0 ()

get_link_color (widget, res)

get_pango_attributes_from_buffer (buffer)

global_range_contained (sheet, a, b)

global_range_list_foreach (gr_list, ep, flags, handler, closure)

global_range_list_parse (sheet, str)

global_range_name (sheet, r)

go_data_foreach_dep (dat, so, func, user)

go_data_get_expr (dat)

go_data_get_sheet (dat)

go_data_set_sheet (dat, sheet)

go_error_info_dialog_create (error)

go_error_info_dialog_show (parent, error)

go_error_info_list_dialog_show (parent, errs)

goal_seek_bisection (f, data, *user_data)

goal_seek_cell (data, celldata)

goal_seek_eval_cell (x, data)

goal_seek_initialize (data)

goal_seek_newton (f, df, data, user_data, x0)

goal_seek_point (f, data, user_data, x0)

goal_seek_trawl_normally (f, data, user_data, mu, sigma, points)

goal_seek_trawl_uniformly (f, data, user_data, xmin, xmax, points)

gtk_builder_load (uifile, domain, cc)

gtk_print_cell_range (context, sheet, range, base_x, base_y, pinfo)

gtk_radio_group_get_selected (radio_group)

gui_clipboard_test (fmt)

gui_file_export_repeat (wbcg)

gui_file_open (wbcg, type, default_format)

gui_file_read (wbcg, file_name, optional_format, optional_encoding)

gui_file_save (wbcg, wbv)

gui_file_save_as (wbcg, wbv, type, default_format)

gui_file_template (wbcg, uri)

gui_group_value (gui, group)

gui_wb_view_show (wbcg, wbv)

gutils_init ()

gutils_shutdown ()

hash_table_foreach_ordered (h, callback, order, user)

history_item_label (uri, accel_number)

ifs_func (data, crits, vals, fun, err, ep, flags)

ilog (x, b)

init ()

init_help_button (w, lnk)

insert_meta_date (doc, name)

int_to_entry (entry, the_int)

keyed_dialog (wbcg, dialog, key)

lambert_w (x, k)

lbeta (a, b)

lbeta3 (a, b)

lgamma1p (a)

linear_solve (A, b, x)

linear_solve_multiple (A, B)

linear_solve_posdef (A, b, x)

link_button_and_entry (button, entry)

load_pango_attributes_into_buffer (markup, buffer, str)

locale_dir ()

log1pmx (x)

logcf (x, i, d, tol)

logspace_add (logx, logy)

logspace_sub (logx, logy)

make_cellref (dx, dy)

make_rangeref (dx0, dy0, dx1, dy1)

mathfunc_init ()

matrix_from_value (v, ep)

message_dialog_create (parent, flags, type, primary_message, secondary_message)

object_get_bool (o, name)

object_has_readable_prop (obj, property, typ)

owent (h, a)

page_break_type_from_str (str)

page_setup_get_paper (page_setup)

page_setup_set_paper (page_setup, paper)

pango_attr_list_equal (l1, l2)

pango_context_get ()

parse_criteria (crit_val, date_conv, anchor_end)

parse_database_criteria (ep, database, criteria)

parse_text_value_or_expr (pos, text)

parse_util_init ()

parse_util_shutdown ()

parsepos_as_string (pp)

pattern_background_set (mstyle, cr, is_selected, ctxt)

pbeta (x, a, b, lower_tail, log_p)

pbinom (x, n, psuc, lower_tail, log_p)

pbinom2 (x0, x1, n, p)

pcauchy (x, location, scale, lower_tail, log_p)

pchisq (x, df, lower_tail, log_p)

permut (n, k)

pexp (x, scale, lower_tail, log_p)

pf (x, n1, n2, lower_tail, log_p)

pfuncinverter (p, shape, lower_tail, log_p, xlow, xhigh, x0, pfunc, dpfunc_dx)

pgamma (x, shape, scale, lower_tail, log_p)

pgeom (x, psuc, lower_tail, log_p)

phyper (x, r, b, n, lower_tail, log_p)

plnorm (x, logmean, logsd, lower_tail, log_p)

plugins_init (c)

pnbinom (x, n, psuc, lower_tail, log_p)

pnorm (x, mu, sigma, lower_tail, log_p)

pnorm2 (x1, x2)

pochhammer (x, n)

popup_menu (menu, event)

position_tooltip (tip, px, py, horizontal)

pow1p (x, y)

pow1pm1 (x, y)

ppois (x, lambda_, lower_tail, log_p)

prayleigh (x, scale, lower_tail, log_p)

pre_parse_init (argc, argv)

pre_parse_shutdown ()

prepare_input_range (input_range, group_by)

print_hf_format_render (format, info, render_type)

print_info_dup (pi)

print_info_free (pi)

print_info_get_margins (pi)

print_info_get_page_setup (pi)

print_info_get_paper (pi)

print_info_get_paper_display_name (pi)

print_info_get_paper_height (pi, unit)

print_info_get_paper_orientation (pi)

print_info_get_paper_size (pi)

print_info_get_paper_width (pi, unit)

print_info_get_printrange (pi)

print_info_get_printtofile_uri (pi)

print_info_has_manual_breaks (pi)

print_info_load_defaults (pi)

print_info_save (pi)

print_info_set_breaks (pi, breaks)

print_info_set_edge_to_above_footer (pi, e_f)

print_info_set_edge_to_below_header (pi, e_h)

print_info_set_from_settings (pi, settings)

print_info_set_margin_footer (pi, footer)

print_info_set_margin_header (pi, header)

print_info_set_margin_left (pi, left)

print_info_set_margin_right (pi, right)

print_info_set_margins (pi, header, footer, left, right)

print_info_set_page_setup (pi, page_setup)

print_info_set_paper (pi, paper)

print_info_set_paper_orientation (pi, orientation)

print_info_set_printrange (pi, pr)

print_info_set_printtofile_from_settings (pi, settings, default_uri)

print_info_set_printtofile_uri (pi, uri)

print_load_repeat_range (str, r, sheet)

print_sheet (wbc, sheet, preview, default_range, export_dst)

print_sheet_objects (cr, sheet, range, base_x, base_y)

print_so (wbc, sos, export_dst)

pt (x, n, lower_tail, log_p)

ptukey (x, nmeans, df, nranges, lower_tail, log_p)

pweibull (x, shape, scale, lower_tail, log_p)

qbeta (p, a, b, lower_tail, log_p)

qbinom (p, n, psuc, lower_tail, log_p)

qcauchy (p, location, scale, lower_tail, log_p)

qchisq (p, df, lower_tail, log_p)

qexp (p, scale, lower_tail, log_p)

qf (p, n1, n2, lower_tail, log_p)

qfactf (x, mant, expb)

qgamma (p, shape, scale, lower_tail, log_p)

qgeom (p, psuc, lower_tail, log_p)

qhyper (p, r, b, n, lower_tail, log_p)

qlnorm (p, logmean, logsd, lower_tail, log_p)

qnbinom (p, n, psuc, lower_tail, log_p)

qnorm (p, mu, sigma, lower_tail, log_p)

qpois (p, lambda_, lower_tail, log_p)

qrayleigh (p, scale, lower_tail, log_p)

qt (p, n, lower_tail, log_p)

qtukey (p, nmeans, df, nranges, lower_tail, log_p)

qweibull (p, shape, scale, lower_tail, log_p)

random_01 ()

random_bernoulli (p)

random_beta (a, b)

random_binomial (p, trials)

random_cauchy (a)

random_chisq (nu)

random_exponential (b)

random_exppow (a, b)

random_exppow_pdf (x, a, b)

random_fdist (nu1, nu2)

random_gamma (a, b)

random_gaussian_tail (a, sigma)

random_geometric (p)

random_gumbel1 (a, b)

random_gumbel2 (a, b)

random_hypergeometric (n1, n2, t)

random_landau ()

random_laplace (a)

random_laplace_pdf (x, a)

random_levy (c, alpha)

random_levy_skew (c, alpha, beta)

random_logarithmic (p)

random_logistic (a)

random_lognormal (zeta, sigma)

random_negbinom (p, f)

random_normal ()

random_pareto (a, b)

random_poisson (lambda_)

random_rayleigh (sigma)

random_rayleigh_tail (a, sigma)

random_skew_normal (a)

random_skew_tdist (nu, a)

random_tdist (nu)

random_uniform_int (n)

random_uniform_integer (l, h)

random_weibull (a, b)

range_adtest (xs, n, p, statistics)

range_avedev (xs, n, res)

range_concatenate (data, user)

range_correl_pop (xs, ys, n, res)

range_count (xs, n, res)

range_covar_est (xs, ys, n, res)

range_covar_pop (xs, ys, n, res)

range_geometric_mean (xs, n, res)

range_harmonic_mean (xs, n, res)

range_hypot (xs, n, res)

range_kurtosis_m3_est (xs, n, res)

range_kurtosis_m3_pop (xs, n, res)

range_list_destroy (ranges)

range_mode (xs, n, res)

range_multinomial (xs, n, res)

range_product (xs, n, res)

range_rsq_pop (xs, ys, n, res)

range_simplify (arr)

range_skew_est (xs, n, res)

range_skew_pop (xs, n, res)

range_stddev_est (xs, n, res)

range_stddev_pop (xs, n, res)

range_var_est (xs, n, res)

range_var_pop (xs, n, res)

reduce_pi (x, e)

regcomp_XL (preg, pattern, cflags, anchor_start, anchor_end)

restore_window_geometry (dialog, key)

row_calc_spans (ri, row, sheet)

row_destroy_span (ri)

row_span_get (ri, col)

rows_height_update (sheet, range, shrink)

rvc_free (rvc)

rvc_remove (rvc, cell)

rvc_store (rvc, cell, rv)

sc_ant (sc)

sc_cursor_bound (sc, r)

sc_freeze_object_view (sc, freeze)

sc_make_cell_visible (sc, col, row, couple_panes)

sc_mode_edit (sc)

sc_object_create_view (sc, so)

sc_recompute_visible_region (sc, full_recompute)

sc_redraw_all (sc, headers)

sc_redraw_headers (sc, col, row, r)

sc_redraw_range (sc, r)

sc_resize (sc, force_scroll)

sc_scale_changed (sc)

sc_scrollbar_config (sc)

sc_set_panes (sc)

sc_set_top_left (sc, col, row)

sc_sheet (sc)

sc_show_im_tooltip (sc, im, pos)

sc_unant (sc)

sc_view (sc)

sc_wbc (sc)

scg_adjust_preferences (scg)

scg_colrow_distance_get (scg, is_cols, from_, to)

scg_colrow_select (scg, is_cols, index, modifiers)

scg_colrow_size_set (scg, is_cols, index, new_size_pixels)

scg_comment_display (scg, cc, x, y)

scg_comment_select (scg, cc, x, y)

scg_comment_unselect (scg, cc)

scg_context_menu (scg, event, is_col, is_row)

scg_cursor_extend (scg, n, jump_to_bound, horiz)

scg_cursor_move (scg, dir, jump_to_bound, horiz)

scg_cursor_visible (scg, is_visible)

scg_delete_sheet_if_possible (scg)

scg_drag_data_get (scg, selection_data)

scg_drag_data_received (scg, source_widget, x, y, selection_data)

scg_edit_start (scg)

scg_edit_stop (scg)

scg_make_cell_visible (scg, col, row, force_scroll, couple_panes)

scg_mode_edit (scg)

scg_object_anchor_to_coords (scg, anchor, coords)

scg_object_coords_to_anchor (scg, coords, in_out)

scg_object_select (scg, so)

scg_object_select_next (scg, reverse)

scg_object_unselect (scg, so)

scg_objects_drag (scg, gcanvas, primary, dx, dy, drag_type, symmetric, snap_to_grid, is_mouse_move)

scg_objects_drag_commit (scg, drag_type, created_objects, pundo, predo, undo_title)

scg_objects_nudge (scg, gcanvas, drag_type, dx, dy, symmetric, snap_to_grid)

scg_pane (scg, pane)

scg_paste_image (scg, where, data, len)

scg_queue_movement (scg, handler, n, jump, horiz)

scg_rangesel_bound (scg, base_col, base_row, move_col, move_row)

scg_rangesel_extend (scg, n, jump_to_bound, horiz)

scg_rangesel_extend_to (scg, col, row)

scg_rangesel_move (scg, dir, jump_to_bound, horiz)

scg_rangesel_start (scg, base_col, base_row, move_col, move_row)

scg_rangesel_stop (scg, clear_str)

scg_reload_item_edits (scg)

scg_select_all (scg)

scg_set_display_cursor (scg)

scg_set_left_col (scg, new_first_col)

scg_set_top_row (scg, new_first_row)

scg_sheet (scg)

scg_size_guide_motion (scg, vert, guide_pos)

scg_size_guide_start (scg, vert, colrow, is_colrow_resize)

scg_size_guide_stop (scg)

scg_special_cursor_bound_set (scg, r)

scg_special_cursor_start (scg, style, button)

scg_special_cursor_stop (scg)

scg_take_focus (scg)

scg_view (scg)

scg_wbc (scg)

scg_wbcg (scg)

search_collect_cells (sr)

search_collect_cells_free (cells)

search_filter_matching (sr, cells)

search_filter_matching_free (matches)

search_normalize (txt)

selection_first_range (sv, cc, cmd_name)

selection_get_ranges (sv, allow_intersection)

selection_to_string (sv, include_sheet_name_prefix)

set_cell_text_col (dao, col, row, text)

set_cell_text_row (dao, col, row, text)

set_uifilename (name, actions, nb)

sheet_range_set_text (pos, r, str)

shortest_rep_in_files ()

shutdown ()

simulation_tool (wbc, dao, sim)

simulation_tool_destroy (sim)

slist_sort_merge (list_1, list_2)

sort_contents (data, cc)

sort_permute_invert (perm, length)

sort_position (data, perm, cc)

stf_dialog_csv_page_cleanup (pagedata)

stf_dialog_csv_page_init (gui, pagedata)

stf_dialog_csv_page_prepare (pagedata)

stf_dialog_fixed_page_cleanup (pagedata)

stf_dialog_fixed_page_init (gui, pagedata)

stf_dialog_fixed_page_prepare (pagedata)

stf_dialog_format_page_cleanup (pagedata)

stf_dialog_format_page_init (gui, pagedata)

stf_dialog_format_page_prepare (pagedata)

stf_dialog_main_page_cleanup (pagedata)

stf_dialog_main_page_init (gui, pagedata)

stf_dialog_main_page_prepare (pagedata)

stf_dialog_result_attach_formats_to_cr (dialogresult, cr)

stf_dialog_result_free (dialogresult)

stf_export (export_options)

stf_file_saver_create (id)

stf_get_stfe (obj)

stf_parse_find_line (parseoptions, data, line)

stf_parse_options_guess (data)

stf_parse_options_guess_csv (data)

stf_parse_region (parseoptions, data, data_end, wb)

stf_parse_sheet (parseoptions, data, data_end, sheet, start_col, start_row)

stf_preview_find_column (renderdata, x, pcol, dx)

stf_text_to_columns (wbc, cc)

stirlerr (n)

string_add_number (buf, d)

strip_missing (data, missing)

style_border_fetch (line_type, color, orientation)

style_border_get_orientation (type)

style_border_get_width (line_type)

style_border_none ()

style_border_none_set_color (color)

style_border_ref (border)

style_border_set_dash (i, context)

style_border_unref (border)

style_border_visible_in_blank (border)

style_borders_row_draw (prev_vert, sr, cr, x, y1, y2, colwidths, draw_vertical, dir)

style_borders_row_print_gtk (prev_vert, sr, context, x, y1, y2, sheet, draw_vertical, dir)

style_color_auto_back ()

style_color_auto_font ()

style_color_auto_pattern ()

style_color_black ()

style_color_equal (a, b)

style_color_grid (context)

style_color_ref (sc)

style_color_unref (sc)

style_color_white ()

style_context_get_color (context, state, color)

style_hash (style)

style_hash_XL (style)

style_list_free (l)

style_list_get_style (l, col, row)

style_row_init (prev_vert, sr, next_sr, start_col, end_col, mem, hide_grid)

sv_is_colrow_selected (sv, colrow, is_col)

sv_is_full_colrow_selected (sv, is_cols, index)

sv_is_full_range_selected (sv, r)

sv_is_pos_selected (sv, col, row)

sv_is_range_selected (sv, r)

sv_is_singleton_selected (sv)

sv_select_cur_array (sv)

sv_select_cur_col (sv)

sv_select_cur_depends (sv)

sv_select_cur_inputs (sv)

sv_select_cur_row (sv)

sv_selection_add_full (sv, edit_col, edit_row, base_col, base_row, move_col, move_row, mode)

sv_selection_add_pos (sv, col, row, mode)

sv_selection_add_range (sv, range)

sv_selection_apply (sv, func, allow_intersection, *user_data)

sv_selection_col_type (sv, col)

sv_selection_extend_to (sv, col, row)

sv_selection_foreach (sv, handler, *user_data)

sv_selection_free (sv)

sv_selection_reset (sv)

sv_selection_row_type (sv, row)

sv_selection_set (sv, edit, base_col, base_row, move_col, move_row)

sv_selection_simplified_free (sv)

sv_selection_simplify (sv)

sv_selection_to_plot (sv, plot)

sv_selection_walk_step (sv, forward, horizontal)

sv_sheet (sv)

sv_wbv (sv)

swap_log_tail (lp)

sys_data_dir ()

sys_extern_plugin_dir ()

sys_lib_dir ()

taylor_log1p (x, k)

textbuffer_get_text (buf)

textview_get_text (text_view)

textview_set_text (text_view, txt)

theme_is_dark (widget)

tool_consolidate_engine (gcc, dao, specs, selector, result)

tool_load_selection (state, allow_multiple)

tool_random_cor_engine (gcc, dao, specs, selector, result)

tool_random_engine (gcc, dao, specs, selector, result)

translate_underline_from_pango (pul)

translate_underline_to_pango (ul)

undo_cell_pos_name (sheet, pos)

undo_range_list_name (sheet, ranges)

undo_range_name (sheet, r)

unit_name_to_unit (name)

unit_to_unit_name (unit)

usr_dir (versioned)

utf8_strto (s, end)

utf8_strtol (s, end)

validation_eval (wbc, mstyle, sheet, pos)

validation_eval_range (wbc, sheet, pos, r, showed_dialog)

value_cmp (ptr_a, ptr_b)

value_cmp_reverse (ptr_a, ptr_b)

value_error_name (err, translated)

value_error_set_pos (err, pos)

wb_control_claim_selection (wbc)

wb_control_cur_sheet (wbc)

wb_control_cur_sheet_view (wbc)

wb_control_edit_line_set (wbc, text)

wb_control_get_doc (wbc)

wb_control_get_workbook (wbc)

wb_control_init_state (wbc)

wb_control_jump (wbc, sheet, r)

wb_control_menu_state_update (wbc, flags)

wb_control_navigate_to_cell (wbc, to)

wb_control_parse_and_jump (wbc, text)

wb_control_paste_from_selection (wbc, pt)

wb_control_selection_descr_set (wbc, text)

wb_control_set_view (wbc, optional_view, optional_wb)

wb_control_sheet_add (wbc, sv)

wb_control_sheet_focus (wbc, sheet)

wb_control_sheet_remove (wbc, sheet)

wb_control_sheet_remove_all (wbc)

wb_control_style_feedback (wbc, changes)

wb_control_undo_redo_labels (wbc, undo, redo)

wb_control_undo_redo_pop (wbc, is_undo)

wb_control_undo_redo_push (wbc, is_undo, text, key)

wb_control_undo_redo_truncate (wbc, n, is_undo)

wb_control_update_action_sensitivity (wbc)

wb_control_validation_msg (wbc, v, title, msg)

wb_control_view (wbc)

wb_view_attach_control (wbv, wbc)

wb_view_auto_expr_recalc (wbv)

wb_view_cur_sheet (wbv)

wb_view_cur_sheet_view (wbv)

wb_view_detach_control (wbc)

wb_view_detach_from_workbook (wbv)

wb_view_edit_line_set (wbv, wbc)

wb_view_get_doc (wbv)

wb_view_get_index_in_wb (wbv)

wb_view_get_workbook (wbv)

wb_view_is_protected (wbv, check_sheet)

wb_view_menus_update (wbv)

wb_view_preferred_size (wbv, w_pixels, h_pixels)

wb_view_selection_desc (wbv, use_pos, wbc)

wb_view_set_attribute (wbv, name, value)

wb_view_sheet_add (wbv, new_sheet)

wb_view_sheet_focus (wbv, sheet)

wb_view_style_feedback (wbv)

wbcg_append_sheet (ignored, wbcg)

wbcg_auto_complete_destroy (wbcg)

wbcg_clone_sheet (ignored, wbcg)

wbcg_copy_toolbar_visibility (new_wbcg, wbcg)

wbcg_cur_scg (wbcg)

wbcg_cur_sheet (wbcg)

wbcg_edit_add_markup (wbcg, attr)

wbcg_edit_finish (wbcg, result)

wbcg_edit_get_display_text (wbcg)

wbcg_edit_get_markup (wbcg, full)

wbcg_edit_start (wbcg, blankp, cursorp)

wbcg_entry_has_logical (wbcg)

wbcg_find_action (wbcg, name)

wbcg_find_for_workbook (wb, candidate, pref_screen, pref_display)

wbcg_focus_cur_scg (wbcg)

wbcg_focus_current_cell_indicator (wbcg)

wbcg_font_action_set_font_desc (act, desc)

wbcg_get_entry (wbcg)

wbcg_get_entry_logical (wbcg)

wbcg_get_entry_underlying (wbcg)

wbcg_get_font_desc (wbcg)

wbcg_get_n_scg (wbcg)

wbcg_get_nth_scg (wbcg, i)

wbcg_insert_object (wbcg, so)

wbcg_insert_object_clear (wbcg)

wbcg_insert_sheet (ignored, wbcg)

wbcg_is_editing (wbcg)

wbcg_rangesel_possible (wbcg)

wbcg_set_end_mode (wbcg, flag)

wbcg_set_entry (wbc, new_entry)

wbcg_set_status_text (wbcg, text)

wbcg_set_transient (wbcg, window)

wbcg_toggle_visibility (wbcg, action)

wbcg_toplevel (wbcg)

widget_measure_string (w, s)

widget_set_cursor (w, ct)

widget_set_cursor_type (w, ct)

x_claim_clipboard (display)

x_disown_clipboard ()

x_request_clipboard (wbcg, pt)

x_store_clipboard_if_needed (wb)

xml_attr_bool (attrs, name, res)

xml_attr_double (attrs, name, res)

xml_attr_int (attrs, name, res)

xml_cellregion_read (wbc, io_context, sheet, buffer, length)

xml_in_cur_obj (xin)

xml_in_cur_sheet (xin)

xml_in_doc_dispose_on_exit (pdoc)

xml_io_conventions ()

xml_out_add_gocolor (o, id, c)

xml_out_end_element_check (xout, id)

xml_prep_style_parser (xin, attrs, handler, user)

xml_sax_read_init ()

xml_sax_read_shutdown ()

xml_sax_write_init ()

xml_sax_write_shutdown ()

yearfrac (from_, to, basis)

Details

Gnm.acot(x)
Parameters:

x (float) – a number

Returns:

The inverse co-tangent of the given number.

Return type:

float

Gnm.acoth(x)
Parameters:

x (float) – a number

Returns:

The inverse hyperbolic co-tangent of the given number.

Return type:

float

Gnm.action_group_add_action(group, act)
Parameters:
Gnm.action_group_add_actions(group, actions, n, user)
Parameters:
Gnm.advanced_filter(wbc, dao, database, criteria, unique_only_flag)
Parameters:
Return type:

int

Gnm.agm(a, b)
Parameters:
Returns:

The arithmetic-geometric mean of a and b.

Return type:

float

Gnm.analysis_tool_advanced_filter_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_anova_single_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_anova_two_factor_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_auto_expression_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_calc_length(info)
Parameters:

info (Gnm.analysis_tools_data_generic_t) –

Return type:

int

Gnm.analysis_tool_chi_squared_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_correlation_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_covariance_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_descriptive_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_exponential_smoothing_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_fourier_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_frequency_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_ftest_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_generic_b_clean(specs)
Parameters:

specs (object or None) –

Return type:

bool

Gnm.analysis_tool_generic_clean(specs)
Parameters:

specs (object or None) –

Return type:

bool

Gnm.analysis_tool_get_function(name, dao)
Parameters:
Returns:

the function named name or a placeholder. The usage GOffice.count of the function is incremented.

Return type:

Gnm.Func

Gnm.analysis_tool_histogram_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_kaplan_meier_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_moving_average_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_normality_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_one_mean_test_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_principal_components_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_ranking_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_regression_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_sampling_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_sign_test_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_sign_test_two_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_signed_rank_test_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_signed_rank_test_two_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_table(dao, info, title, functionname, full_table)
Parameters:
Return type:

bool

Gnm.analysis_tool_ttest_eqvar_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_ttest_neqvar_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_ttest_paired_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_wilcoxon_mann_whitney_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tool_ztest_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.analysis_tools_write_label(val, dao, info, x, y, i)
Parameters:
Gnm.analysis_tools_write_label_ftest(val, dao, x, y, labels, i)
Parameters:
Gnm.annual_year_basis(value_date, basis, date_conv)
Parameters:
Return type:

int

Gnm.auto_style_format_suggest(texpr, epos)
Parameters:
Returns:

Suggested format.

Return type:

GOffice.Format or None

Suggest a format for texpr.

Gnm.autocorrect_tool(input)
Parameters:

input (str) –

Return type:

str

Gnm.autofill_fill(sheet, default_increment, base_col, base_row, w, h, end_col, end_row)
Parameters:

An internal routine to autofill a region. It does NOT queue a recalc, flag a status update, or regen spans.

Gnm.autofill_hint(sheet, default_increment, base_col, base_row, w, h, end_col, end_row)
Parameters:
Return type:

GLib.String

Gnm.bd0(x, M)
Parameters:
Return type:

float

Gnm.bessel_i(x, alpha)
Parameters:
Return type:

float

Gnm.bessel_j(x, alpha)
Parameters:
Return type:

float

Gnm.bessel_k(x, alpha)
Parameters:
Return type:

float

Gnm.bessel_y(x, alpha)
Parameters:
Return type:

float

Gnm.beta(a, b)
Parameters:
Returns:

the Beta function evaluated at a and b.

Return type:

float

Gnm.canvas_get_position(canvas, x, y, px, py)
Parameters:
Gnm.canvas_get_screen_position(canvas, x, y, ix, iy)
Parameters:
Gnm.cell_set_array(sheet, r, texpr)
Parameters:

  • sheet (Gnm.Sheet) – The sheet to set the array expression in.

  • r (Gnm.Range) – The range to set.

  • texpr (Gnm.ExprTop) – an expression (the inner expression, not a corner or element)

Returns:

True if the operation succeeded.

NOTE : This adds a reference to the expression.

Does not regenerate spans, dimensions or autosize cols/rows.

DOES CHECK for array partitioning.

Return type:

bool

Set an array expression for a range. Uses cell_set_expr_internal to store the expr as an ‘array-formula’. The supplied expression is wrapped in an array operator for each cell in the range and scheduled for recalc.

Gnm.cell_set_array_formula_undo(sr, texpr)
Parameters:
Returns:

the newly allocated GOffice.Undo.

Return type:

GOffice.Undo

Gnm.cell_set_comment(sheet, pos, author, text, markup)
Parameters:
Returns:

the newly allocated Gnm.Comment.

Return type:

Gnm.Comment

Gnm.cellpos_equal(a, b)
Parameters:
Return type:

int

Gnm.cellpos_hash(key)
Parameters:

key (Gnm.CellPos) –

Return type:

int

Gnm.cellpos_init_cellref(cp, cr, pos, base_sheet)
Parameters:
Gnm.cellpos_init_cellref_ss(res, cell_ref, pos, ss)
Parameters:
Gnm.cellregion_cmd_size(cr)
Parameters:

cr (Gnm.CellRegion) –

Return type:

int

Gnm.cellregion_invalidate_sheet(cr, sheet)
Parameters:

Invalidate references from cell content, objects or style to sheet.

Gnm.cellregion_ref(cr)
Parameters:

cr (Gnm.CellRegion) –

Return type:

Gnm.CellRegion

Gnm.cellregion_to_string(cr, only_visible, date_conv)
Parameters:
Return type:

GLib.String

Gnm.cellregion_to_xml(cr)
Parameters:

cr (Gnm.CellRegion) – the content to store.

Returns:

None on error

Return type:

Gsf.OutputMemory

Gnm.cellregion_unref(cr)
Parameters:

cr (Gnm.CellRegion) –

Gnm.check_for_plugins_missing(ids, parent)
Parameters:
Return type:

bool

Gnm.clipboard_copy_obj(sheet, objects)
Parameters:
Returns:

a cell region with copies of objects in list.

Return type:

Gnm.CellRegion

Gnm.clipboard_copy_range(sheet, r)
Parameters:
Returns:

the copied contents of the given range.

Return type:

Gnm.CellRegion

Gnm.clipboard_copy_range_undo(sheet, r)
Parameters:
Returns:

A GOffice.Undo object that will restore the contents of the given range.

Return type:

GOffice.Undo

Gnm.clipboard_copy_ranges_undo(sheet, ranges)
Parameters:
Returns:

A GOffice.Undo object that will restore the contents of the given range.

Return type:

GOffice.Undo

Gnm.clipboard_paste_region(cr, pt, cc)
Parameters:
Returns:

True if there was a problem.

Return type:

bool

Pastes the supplied Gnm.CellRegion (cr) into the supplied Gnm.PasteTarget (pt). This operation is not undoable. It does not auto grow the destination if the target is a singleton. This is a simple interface to paste a region.

Gnm.cmd_area_set_array_expr(wbc, sv, new_texpr)
Parameters:
Return type:

bool

Gnm.cmd_area_set_text(wbc, sv, text, markup)
Parameters:
Return type:

bool

Gnm.cmd_autofill(wbc, sheet, default_increment, base_col, base_row, w, h, end_col, end_row, inverse_autofill)
Parameters:
Return type:

bool

Gnm.cmd_autofilter_add_remove(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Return type:

bool

Gnm.cmd_autofilter_set_condition(wbc, filter, i, cond)
Parameters:
Return type:

bool

Gnm.cmd_autofit_selection(wbc, sv, sheet, fit_width, selectionlist)
Parameters:
Return type:

bool

Gnm.cmd_cell_range_is_locked_effective(sheet, range, wbc, cmd_name)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

checks whether the cells are effectively locked

static bool Gnm.cmd_cell_range_is_locked_effective

Do not use this function unless the sheet is part of the GOffice.workbook with the given wbc (otherwise the results may be strange)

Gnm.cmd_change_meta_data(wbc, changes, removed)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_colrow_std_size(wbc, sheet, is_cols, new_default)
Parameters:
Return type:

bool

Gnm.cmd_context_error_calc(cc, msg)
Parameters:
Gnm.cmd_context_error_splits_array(cc, cmd, array)
Parameters:
Gnm.cmd_context_error_splits_merge(cc, merge)
Parameters:
Gnm.cmd_copyrel(wbc, dx, dy, name)
Parameters:
Return type:

bool

Gnm.cmd_create_data_table(wbc, sheet, r, col_input, row_input)
Parameters:
Return type:

bool

Gnm.cmd_data_shuffle(wbc, sc, sheet)
Parameters:
Return type:

bool

Gnm.cmd_define_name(wbc, name, pp, texpr, descriptor)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

If the name has never been defined in context pp create a new name If it is a placeholder, assign texpr to it and make it real If it already exists as a real name just assign expr.

Gnm.cmd_delete_cols(wbc, sheet, start_col, count)
Parameters:
Return type:

bool

Gnm.cmd_delete_rows(wbc, sheet, start_row, count)
Parameters:
Return type:

bool

Gnm.cmd_generic(wbc, text, undo, redo)
Parameters:
Return type:

bool

Gnm.cmd_generic_with_size(wbc, text, size, undo, redo)
Parameters:
Return type:

bool

Gnm.cmd_global_outline_change(wbc, is_cols, depth)
Parameters:
Return type:

bool

Gnm.cmd_goal_seek(wbc, cell, ov, nv)
Parameters:
Return type:

bool

Gnm.cmd_insert_cols(wbc, sheet, start_col, count)
Parameters:
Return type:

bool

Gnm.cmd_insert_rows(wbc, sheet, start_row, count)
Parameters:
Return type:

bool

Gnm.cmd_merge_cells(wbc, sheet, selection, center)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_merge_data(wbc, sheet, merge_zone, merge_fields, merge_data)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_object_raise(wbc, so, dir)
Parameters:
Return type:

bool

Gnm.cmd_objects_delete(wbc, objects, name)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_objects_move(wbc, objects, anchors, objects_created, name)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_page_break_toggle(wbc, sheet, is_vert)
Parameters:
Return type:

bool

Gnm.cmd_page_breaks_clear(wbc, sheet)
Parameters:
Return type:

bool

Gnm.cmd_paste(wbc, pt)
Parameters:

Pastes the current cut buffer, copy buffer, or X selection to the destination sheet range.

When pasting a cut the destination MUST be the same size as the src.

When pasting a copy the destination can be a singleton, or an integer multiple of the size of the source. This is not tested here. Full undo support.

Gnm.cmd_paste_copy(wbc, pt, content)
Parameters:
Return type:

bool

Gnm.cmd_paste_cut(wbc, info, move_selection, cmd_descriptor)
Parameters:
Return type:

bool

Gnm.cmd_paste_to_selection(wbc, dest_sv, paste_flags)
Parameters:

  • wbc (Gnm.WorkbookControl) – GOffice.workbook control

  • dest_sv (Gnm.SheetView) – The sheet into which things should be pasted

  • paste_flags (int) – special paste flags (eg transpose)

Using the current selection as a target Full undo support.

Gnm.cmd_print_setup(wbc, sheet, pi)
Parameters:
Return type:

bool

Gnm.cmd_remove_name(wbc, nexpr)
Parameters:
Return type:

bool

Returns True on error

Gnm.cmd_rename_sheet(wbc, sheet, new_name)
Parameters:
Return type:

bool

Gnm.cmd_reorganize_sheets(wbc, old_state, undo_sheet)
Parameters:
Return type:

bool

Gnm.cmd_rescope_name(wbc, nexpr, scope)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_resize_colrow(wbc, sheet, is_col, selection, new_size)
Parameters:
Return type:

bool

Gnm.cmd_resize_sheets(wbc, sheets, cols, rows)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_scenario_mngr(wbc, sc, undo)
Parameters:
Return type:

bool

Gnm.cmd_search_replace(wbc, sr)
Parameters:
Return type:

bool

Gnm.cmd_selection_autoformat(wbc, ft)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_selection_clear(wbc, clear_flags)
Parameters:
Return type:

bool

Gnm.cmd_selection_colrow_hide(wbc, is_cols, visible)
Parameters:
Return type:

bool

Gnm.cmd_selection_format(wbc, style, borders, opt_translated_name)
Parameters:
Return type:

bool

Gnm.cmd_selection_format_toggle_font_style(wbc, style, t)
Parameters:
Return type:

bool

Gnm.cmd_selection_group(wbc, is_cols, group)
Parameters:
Return type:

bool

Parameters:

  • wbc (Gnm.WorkbookControl) – the GOffice.workbook control.

  • style (Gnm.Style) – style to apply to the selection

  • opt_translated_name (str) – An optional name to use in place of ‘Hyperlink Cells’

  • opt_content (str) – optional content for otherwise empty cells.

Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_selection_outline_change(wbc, is_cols, index, depth)
Parameters:
Return type:

bool

Gnm.cmd_set_comment(wbc, sheet, pos, new_text, attr, new_author)
Parameters:
Return type:

bool

Gnm.cmd_set_text(wbc, sheet, pos, new_text, markup, autocorrect)
Parameters:
Return type:

bool

Gnm.cmd_shift_cols(wbc, sheet, start_col, end_col, row, count)
Parameters:

  • wbc (Gnm.WorkbookControl) – The error context.

  • sheet (Gnm.Sheet) – the sheet

  • start_col (int) – first column

  • end_col (int) – end column

  • row (int) – Gnm.row marking the start of the shift

  • count (int) – numbers of rows to shift. a negative numbers will delete GOffice.count rows, positive number will insert GOffice.count rows.

Takes the cells in the region (start_col,:obj:Gnm.row):(end_col,MAX_ROW) and copies them count units (possibly negative) downwards.

Gnm.cmd_shift_rows(wbc, sheet, col, start_row, end_row, count)
Parameters:

  • wbc (Gnm.WorkbookControl) – The error context. sheet the sheet col column marking the start of the shift start_row first Gnm.row end_row end Gnm.row count numbers of columns to shift. negative numbers will delete GOffice.count columns, positive number will insert GOffice.count columns.

  • sheet (Gnm.Sheet) –

  • col (int) –

  • start_row (int) –

  • end_row (int) –

  • count (int) –

Takes the cells in the region (Gnm.col,start_row):(MAX_COL,end_row) and copies them count units (possibly negative) to the right.

Gnm.cmd_slicer_refresh(wbc)
Parameters:

wbc (Gnm.WorkbookControl) – the GOffice.workbook control.

Return type:

bool

Gnm.cmd_so_component_config(wbc, so, n_obj, o_obj)
Parameters:
Return type:

bool

Gnm.cmd_so_graph_config(wbc, sog, n_graph, o_graph)
Parameters:
Return type:

bool

Gnm.cmd_so_set_adjustment(wbc, so, lnk, horizontal, lower, upper, step, page, undo_label)
Parameters:
Return type:

bool

Gnm.cmd_so_set_button(wbc, so, lnk, old_label, new_label)
Parameters:
Return type:

bool

Gnm.cmd_so_set_checkbox(wbc, so, lnk, old_label, new_label)
Parameters:
Return type:

bool

Gnm.cmd_so_set_frame_label(wbc, so, old_label, new_label)
Parameters:
Return type:

bool

Parameters:
Return type:

bool

Gnm.cmd_so_set_radio_button(wbc, so, lnk, old_label, new_label, old_value, new_value)
Parameters:
Return type:

bool

Gnm.cmd_so_set_value(wbc, text, pref, new_val, sheet)
Parameters:
Return type:

bool

Gnm.cmd_sort(wbc, data)
Parameters:
Return type:

bool

Gnm.cmd_tabulate(wbc, data)
Parameters:
Return type:

bool

Gnm.cmd_text_to_columns(wbc, src, src_sheet, target, target_sheet, content)
Parameters:
Return type:

bool

Gnm.cmd_toggle_rtl(wbc, sheet)
Parameters:
Return type:

bool

Gnm.cmd_trunc_descriptor(src, truncated)
Parameters:
Return type:

GLib.String

Gnm.cmd_unmerge_cells(wbc, sheet, selection)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.cmd_zoom(wbc, sheets, factor)
Parameters:
Returns:

True if there was a problem, False otherwise.

Return type:

bool

Gnm.collect_floats_value(val, ep, flags, n, error)
Parameters:
Return type:

float

Gnm.collect_floats_value_with_info(val, ep, flags, n, info, error)
Parameters:
Return type:

float

Like Gnm.collect_floats_value, but keeps info on missing values

Gnm.colrow_autofit(sheet, r, is_cols, ignore_strings, min_current, min_default, indices, sizes)
Parameters:
Gnm.colrow_autofit_col(sheet, r)
Parameters:
Gnm.colrow_autofit_row(sheet, r)
Parameters:
Gnm.colrow_compute_pixel_scale(sheet, horizontal)
Parameters:
Return type:

float

Gnm.colrow_compute_pixels_from_pts(cri, sheet, horizontal, scale)
Parameters:
Gnm.colrow_compute_pts_from_pixels(cri, sheet, horizontal, scale)
Parameters:
Gnm.colrow_find_outline_bound(sheet, is_cols, index, depth, inc)
Parameters:
Return type:

int

find the next/prev Gnm.col/Gnm.row at the designated depth starting from the supplied index.

Gnm.colrow_free(cri)
Parameters:

cri (Gnm.ColRowInfo) –

Gnm.colrow_get_index_list(first, last, list)
Parameters:
Returns:

list.

Return type:

[object]

Build an ordered list of pairs doing intelligent merging of overlapping regions.

Gnm.colrow_index_list_copy(list)
Parameters:

list ([object]) – #ColRowIndexList

Return type:

[object]

Gnm.colrow_index_list_to_string(list, is_cols, is_single)
Parameters:
Return type:

GLib.String

Gnm.colrow_set_visibility(sheet, is_cols, visible, first, last)
Parameters:

  • sheet (Gnm.Sheet) – the Gnm.Sheet

  • is_cols (bool) – True for columns, False for rows.

  • visible (bool) – Make things visible or invisible.

  • first (int) – The index of the first Gnm.row/Gnm.col (inclusive)

  • last (int) – The index of the last Gnm.row/Gnm.col (inclusive)

Change the visibility of the selected range of contiguous cols/rows. NOTE : only changes the collapsed state for the LAST+1 element.

Gnm.colrow_set_visibility_list(sheet, is_cols, visible, list)
Parameters:

This is the high level command that is wrapped by undo and redo. It should not be called by other commands.

Gnm.colrow_state_group_destroy(set)
Parameters:

set ([object]) – the group to destroy.

Returns:

None.

Return type:

[object] or None

Gnm.colrow_state_list_destroy(list)
Parameters:

list ([object]) – the list to destroy.

Returns:

None.

Return type:

[object]

Gnm.colrow_state_list_foreach(list, sheet, is_cols, base, callback, *user_data)
Parameters:

Iterates through the existing rows or columns within the range supplied. Currently only support left-to-right iteration. If a callback returns True, iteration stops.

Gnm.colrow_vis_list_length(list)
Parameters:

list ([object]) –

Return type:

int

Gnm.combin(n, k)
Parameters:

  • n (float) – total number of items

  • k (float) – number of items to pick

Returns:

the binomial coefficient of n and k.

Return type:

float

Gnm.complex_fact(z)
Parameters:

z (GOffice.Complex) – a complex number

Returns:

the factorial function evaluated at z.

expb:

Return location for power-of-base.

Return type:

(GOffice.Complex, expb: int)

Gnm.complex_from_string(dst, src)
Parameters:
Returns:

zero on success, -1 otherwise.

This function differs from Excel’s parsing in at least the following ways: (1) We allow spaces before the imaginary unit used with an implied “1”. Therefore we allow “+ i”. (2) We do not allow a thousands separator as in “1,000i”.

imunit:

return location of imaginary unit.

Return type:

(int, imunit: str)

Gnm.complex_gamma(z)
Parameters:

z (GOffice.Complex) – a complex number

Returns:

the Gamma function evaluated at z.

expb:

Return location for power-of-base

Return type:

(GOffice.Complex, expb: int)

Gnm.complex_igamma(a, z, lower, regularized)
Parameters:

  • a (GOffice.Complex) – a complex number

  • z (GOffice.Complex) – a complex number

  • lower (bool) – determines if upper or lower incomplete gamma is desired.

  • regularized (bool) – determines if the result should be normalized by Gamma(a).

Returns:

the incomplete gamma function evaluated at a and z.

Return type:

GOffice.Complex

Gnm.complex_invalid_p(src)
Parameters:

src (GOffice.Complex) –

Return type:

int

Gnm.complex_to_string(src, imunit)
Parameters:
Return type:

str

Gnm.conf_get_autocorrect_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autocorrect_first_letter()
Return type:

bool

Gnm.conf_get_autocorrect_first_letter_list()
Return type:

[str]

Gnm.conf_get_autocorrect_first_letter_list_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autocorrect_first_letter_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autocorrect_init_caps()
Return type:

bool

Gnm.conf_get_autocorrect_init_caps_list()
Return type:

[str]

Gnm.conf_get_autocorrect_init_caps_list_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autocorrect_init_caps_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autocorrect_names_of_days()
Return type:

bool

Gnm.conf_get_autocorrect_names_of_days_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autocorrect_replace()
Return type:

bool

Gnm.conf_get_autocorrect_replace_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autoformat_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autoformat_extra_dirs()
Return type:

[str]

Gnm.conf_get_autoformat_extra_dirs_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autoformat_sys_dir()
Return type:

str

Gnm.conf_get_autoformat_sys_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_autoformat_usr_dir()
Return type:

str

Gnm.conf_get_autoformat_usr_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_defaultfont_bold()
Return type:

bool

Gnm.conf_get_core_defaultfont_bold_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_defaultfont_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_defaultfont_italic()
Return type:

bool

Gnm.conf_get_core_defaultfont_italic_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_defaultfont_name()
Return type:

str

Gnm.conf_get_core_defaultfont_name_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_defaultfont_size()
Return type:

float

Gnm.conf_get_core_defaultfont_size_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_file_save_def_overwrite()
Return type:

bool

Gnm.conf_get_core_file_save_def_overwrite_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_file_save_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_file_save_extension_check_disabled()
Return type:

[str]

Gnm.conf_get_core_file_save_extension_check_disabled_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_file_save_single_sheet()
Return type:

bool

Gnm.conf_get_core_file_save_single_sheet_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_cells_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_cells_extension_markers()
Return type:

bool

Gnm.conf_get_core_gui_cells_extension_markers_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_cells_function_markers()
Return type:

bool

Gnm.conf_get_core_gui_cells_function_markers_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_autocomplete()
Return type:

bool

Gnm.conf_get_core_gui_editing_autocomplete_min_chars()
Return type:

int

Gnm.conf_get_core_gui_editing_autocomplete_min_chars_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_autocomplete_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_enter_moves_dir()
Return type:

GOffice.Direction

Gnm.conf_get_core_gui_editing_enter_moves_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_function_argument_tooltips()
Return type:

bool

Gnm.conf_get_core_gui_editing_function_argument_tooltips_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_function_name_tooltips()
Return type:

bool

Gnm.conf_get_core_gui_editing_function_name_tooltips_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_recalclag()
Return type:

int

Gnm.conf_get_core_gui_editing_recalclag_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_editing_transitionkeys()
Return type:

bool

Gnm.conf_get_core_gui_editing_transitionkeys_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_screen_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_screen_horizontaldpi()
Return type:

float

Gnm.conf_get_core_gui_screen_horizontaldpi_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_screen_verticaldpi()
Return type:

float

Gnm.conf_get_core_gui_screen_verticaldpi_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_format_position()
Return type:

Gtk.PositionType

Gnm.conf_get_core_gui_toolbars_format_position_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_format_visible()
Return type:

bool

Gnm.conf_get_core_gui_toolbars_format_visible_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_object_position()
Return type:

Gtk.PositionType

Gnm.conf_get_core_gui_toolbars_object_position_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_object_visible()
Return type:

bool

Gnm.conf_get_core_gui_toolbars_object_visible_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_standard_position()
Return type:

Gtk.PositionType

Gnm.conf_get_core_gui_toolbars_standard_position_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_toolbars_standard_visible()
Return type:

bool

Gnm.conf_get_core_gui_toolbars_standard_visible_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_window_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_window_x()
Return type:

float

Gnm.conf_get_core_gui_window_x_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_window_y()
Return type:

float

Gnm.conf_get_core_gui_window_y_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_gui_window_zoom()
Return type:

float

Gnm.conf_get_core_gui_window_zoom_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_sort_default_ascending()
Return type:

bool

Gnm.conf_get_core_sort_default_ascending_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_sort_default_by_case()
Return type:

bool

Gnm.conf_get_core_sort_default_by_case_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_sort_default_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_sort_default_retain_formats()
Return type:

bool

Gnm.conf_get_core_sort_default_retain_formats_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_sort_dialog_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_sort_dialog_max_initial_clauses()
Return type:

int

Gnm.conf_get_core_sort_dialog_max_initial_clauses_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_workbook_autosave_time()
Return type:

int

Gnm.conf_get_core_workbook_autosave_time_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_workbook_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_workbook_n_cols()
Return type:

int

Gnm.conf_get_core_workbook_n_cols_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_workbook_n_rows()
Return type:

int

Gnm.conf_get_core_workbook_n_rows_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_workbook_n_sheet()
Return type:

int

Gnm.conf_get_core_workbook_n_sheet_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_xml_compression_level()
Return type:

int

Gnm.conf_get_core_xml_compression_level_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_core_xml_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_cut_and_paste_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_cut_and_paste_prefer_clipboard()
Return type:

bool

Gnm.conf_get_cut_and_paste_prefer_clipboard_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_detachable_toolbars()
Return type:

bool

Gnm.conf_get_dialogs_rs_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_dialogs_rs_unfocused()
Return type:

bool

Gnm.conf_get_dialogs_rs_unfocused_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_functionselector_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_functionselector_num_of_recent()
Return type:

int

Gnm.conf_get_functionselector_num_of_recent_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_functionselector_recentfunctions()
Return type:

[str]

Gnm.conf_get_functionselector_recentfunctions_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_long_desc(node)
Parameters:

node (GOffice.ConfNode) – GOffice.ConfNode

Returns:

a description of node.

Return type:

str or None

Gnm.conf_get_page_setup()
Returns:

the default Gtk.PageSetup.

Return type:

Gtk.PageSetup

Gnm.conf_get_plugin_glpk_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugin_glpk_glpsol_path()
Return type:

str

Gnm.conf_get_plugin_glpk_glpsol_path_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugin_latex_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugin_latex_use_utf8()
Return type:

bool

Gnm.conf_get_plugin_latex_use_utf8_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugin_lpsolve_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugin_lpsolve_lpsolve_path()
Return type:

str

Gnm.conf_get_plugin_lpsolve_lpsolve_path_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugins_activate_newplugins()
Return type:

bool

Gnm.conf_get_plugins_activate_newplugins_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugins_active()
Return type:

[str]

Gnm.conf_get_plugins_active_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugins_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugins_extra_dirs()
Return type:

[str]

Gnm.conf_get_plugins_extra_dirs_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugins_file_states()
Return type:

[str]

Gnm.conf_get_plugins_file_states_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_plugins_known()
Return type:

[str]

Gnm.conf_get_plugins_known_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_print_settings()
Returns:

the default Gtk.PrintSettings.

Return type:

Gtk.PrintSettings

Gnm.conf_get_printer_decoration_font()
Returns:

a style appropriate Gnm.font for headers and footers.

Return type:

Gnm.Style

Gnm.conf_get_printsetup_across_then_down()
Return type:

bool

Gnm.conf_get_printsetup_across_then_down_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_all_sheets()
Return type:

bool

Gnm.conf_get_printsetup_all_sheets_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_center_horizontally()
Return type:

bool

Gnm.conf_get_printsetup_center_horizontally_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_center_vertically()
Return type:

bool

Gnm.conf_get_printsetup_center_vertically_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Return type:

[str]

Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_gtk_setting()
Return type:

[str]

Gnm.conf_get_printsetup_gtk_setting_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_header()
Return type:

[str]

Gnm.conf_get_printsetup_header_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_font_bold()
Return type:

bool

Gnm.conf_get_printsetup_hf_font_bold_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_font_italic()
Return type:

bool

Gnm.conf_get_printsetup_hf_font_italic_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_font_name()
Return type:

str

Gnm.conf_get_printsetup_hf_font_name_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_font_size()
Return type:

float

Gnm.conf_get_printsetup_hf_font_size_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_left()
Return type:

[str]

Gnm.conf_get_printsetup_hf_left_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_middle()
Return type:

[str]

Gnm.conf_get_printsetup_hf_middle_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_hf_right()
Return type:

[str]

Gnm.conf_get_printsetup_hf_right_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_margin_bottom()
Return type:

float

Gnm.conf_get_printsetup_margin_bottom_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_margin_gtk_bottom()
Return type:

float

Gnm.conf_get_printsetup_margin_gtk_bottom_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_margin_gtk_left()
Return type:

float

Gnm.conf_get_printsetup_margin_gtk_left_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_margin_gtk_right()
Return type:

float

Gnm.conf_get_printsetup_margin_gtk_right_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_margin_gtk_top()
Return type:

float

Gnm.conf_get_printsetup_margin_gtk_top_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_margin_top()
Return type:

float

Gnm.conf_get_printsetup_margin_top_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_paper()
Return type:

str

Gnm.conf_get_printsetup_paper_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_paper_orientation()
Return type:

int

Gnm.conf_get_printsetup_paper_orientation_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_preferred_unit()
Return type:

Gtk.Unit

Gnm.conf_get_printsetup_preferred_unit_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_print_black_n_white()
Return type:

bool

Gnm.conf_get_printsetup_print_black_n_white_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_print_even_if_only_styles()
Return type:

bool

Gnm.conf_get_printsetup_print_even_if_only_styles_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_print_grid_lines()
Return type:

bool

Gnm.conf_get_printsetup_print_grid_lines_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_print_titles()
Return type:

bool

Gnm.conf_get_printsetup_print_titles_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_repeat_left()
Return type:

str

Gnm.conf_get_printsetup_repeat_left_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_repeat_top()
Return type:

str

Gnm.conf_get_printsetup_repeat_top_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_scale_height()
Return type:

int

Gnm.conf_get_printsetup_scale_height_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_scale_percentage()
Return type:

bool

Gnm.conf_get_printsetup_scale_percentage_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_scale_percentage_value()
Return type:

float

Gnm.conf_get_printsetup_scale_percentage_value_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_printsetup_scale_width()
Return type:

int

Gnm.conf_get_printsetup_scale_width_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_root()
Returns:

the root config node.

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_change_cell_expressions()
Return type:

bool

Gnm.conf_get_searchreplace_change_cell_expressions_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_change_cell_other()
Return type:

bool

Gnm.conf_get_searchreplace_change_cell_other_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_change_cell_strings()
Return type:

bool

Gnm.conf_get_searchreplace_change_cell_strings_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_change_comments()
Return type:

bool

Gnm.conf_get_searchreplace_change_comments_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_columnmajor()
Return type:

bool

Gnm.conf_get_searchreplace_columnmajor_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_error_behaviour()
Return type:

int

Gnm.conf_get_searchreplace_error_behaviour_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_ignore_case()
Return type:

bool

Gnm.conf_get_searchreplace_ignore_case_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_keep_strings()
Return type:

bool

Gnm.conf_get_searchreplace_keep_strings_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_preserve_case()
Return type:

bool

Gnm.conf_get_searchreplace_preserve_case_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_query()
Return type:

bool

Gnm.conf_get_searchreplace_query_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_regex()
Return type:

int

Gnm.conf_get_searchreplace_regex_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_scope()
Return type:

int

Gnm.conf_get_searchreplace_scope_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_search_results()
Return type:

bool

Gnm.conf_get_searchreplace_search_results_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_searchreplace_whole_words_only()
Return type:

bool

Gnm.conf_get_searchreplace_whole_words_only_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_short_desc(node)
Parameters:

node (GOffice.ConfNode) – GOffice.ConfNode

Returns:

a brief description of node.

Return type:

str or None

Gnm.conf_get_stf_export_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_encoding()
Return type:

str

Gnm.conf_get_stf_export_encoding_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_format()
Return type:

Gnm.StfFormatMode

Gnm.conf_get_stf_export_format_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_locale()
Return type:

str

Gnm.conf_get_stf_export_locale_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_quoting()
Return type:

Gsf.OutputCsvQuotingMode

Gnm.conf_get_stf_export_quoting_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_separator()
Return type:

str

Gnm.conf_get_stf_export_separator_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_stringindicator()
Return type:

str

Gnm.conf_get_stf_export_stringindicator_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_terminator()
Return type:

str

Gnm.conf_get_stf_export_terminator_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_stf_export_transliteration()
Return type:

bool

Gnm.conf_get_stf_export_transliteration_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_toolbar_position(name)
Parameters:

name (str) –

Return type:

Gtk.PositionType

Gnm.conf_get_toolbar_style()
Return type:

Gtk.ToolbarStyle

Gnm.conf_get_toolbar_style_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_toolbar_visible(name)
Parameters:

name (str) –

Return type:

bool

Gnm.conf_get_undo_dir_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_undo_max_descriptor_width()
Return type:

int

Gnm.conf_get_undo_max_descriptor_width_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_undo_maxnum()
Return type:

int

Gnm.conf_get_undo_maxnum_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_undo_show_sheet_name()
Return type:

bool

Gnm.conf_get_undo_show_sheet_name_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_get_undo_size()
Return type:

int

Gnm.conf_get_undo_size_node()
Returns:

A GOffice.ConfNode

Return type:

GOffice.ConfNode

Gnm.conf_set_autocorrect_first_letter(x)
Parameters:

x (bool) –

Gnm.conf_set_autocorrect_first_letter_list(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_autocorrect_init_caps(x)
Parameters:

x (bool) –

Gnm.conf_set_autocorrect_init_caps_list(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_autocorrect_names_of_days(x)
Parameters:

x (bool) –

Gnm.conf_set_autocorrect_replace(x)
Parameters:

x (bool) –

Gnm.conf_set_autoformat_extra_dirs(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_autoformat_sys_dir(x)
Parameters:

x (str) –

Gnm.conf_set_autoformat_usr_dir(x)
Parameters:

x (str) –

Gnm.conf_set_core_defaultfont_bold(x)
Parameters:

x (bool) –

Gnm.conf_set_core_defaultfont_italic(x)
Parameters:

x (bool) –

Gnm.conf_set_core_defaultfont_name(x)
Parameters:

x (str) –

Gnm.conf_set_core_defaultfont_size(x)
Parameters:

x (float) –

Gnm.conf_set_core_file_save_def_overwrite(x)
Parameters:

x (bool) –

Gnm.conf_set_core_file_save_extension_check_disabled(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_core_file_save_single_sheet(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_cells_extension_markers(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_cells_function_markers(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_editing_autocomplete(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_editing_autocomplete_min_chars(x)
Parameters:

x (int) –

Gnm.conf_set_core_gui_editing_enter_moves_dir(x)
Parameters:

x (GOffice.Direction) –

Gnm.conf_set_core_gui_editing_function_argument_tooltips(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_editing_function_name_tooltips(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_editing_recalclag(x)
Parameters:

x (int) –

Gnm.conf_set_core_gui_editing_transitionkeys(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_screen_horizontaldpi(x)
Parameters:

x (float) –

Gnm.conf_set_core_gui_screen_verticaldpi(x)
Parameters:

x (float) –

Gnm.conf_set_core_gui_toolbars_format_position(x)
Parameters:

x (Gtk.PositionType) –

Gnm.conf_set_core_gui_toolbars_format_visible(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_toolbars_object_position(x)
Parameters:

x (Gtk.PositionType) –

Gnm.conf_set_core_gui_toolbars_object_visible(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_toolbars_standard_position(x)
Parameters:

x (Gtk.PositionType) –

Gnm.conf_set_core_gui_toolbars_standard_visible(x)
Parameters:

x (bool) –

Gnm.conf_set_core_gui_window_x(x)
Parameters:

x (float) –

Gnm.conf_set_core_gui_window_y(x)
Parameters:

x (float) –

Gnm.conf_set_core_gui_window_zoom(x)
Parameters:

x (float) –

Gnm.conf_set_core_sort_default_ascending(x)
Parameters:

x (bool) –

Gnm.conf_set_core_sort_default_by_case(x)
Parameters:

x (bool) –

Gnm.conf_set_core_sort_default_retain_formats(x)
Parameters:

x (bool) –

Gnm.conf_set_core_sort_dialog_max_initial_clauses(x)
Parameters:

x (int) –

Gnm.conf_set_core_workbook_autosave_time(x)
Parameters:

x (int) –

Gnm.conf_set_core_workbook_n_cols(x)
Parameters:

x (int) –

Gnm.conf_set_core_workbook_n_rows(x)
Parameters:

x (int) –

Gnm.conf_set_core_workbook_n_sheet(x)
Parameters:

x (int) –

Gnm.conf_set_core_xml_compression_level(x)
Parameters:

x (int) –

Gnm.conf_set_cut_and_paste_prefer_clipboard(x)
Parameters:

x (bool) –

Gnm.conf_set_dialogs_rs_unfocused(x)
Parameters:

x (bool) –

Gnm.conf_set_functionselector_num_of_recent(x)
Parameters:

x (int) –

Gnm.conf_set_functionselector_recentfunctions(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_page_setup(setup)
Parameters:

setup (Gtk.PageSetup) –

Gnm.conf_set_persistence(persist)
Parameters:

persist (bool) – whether to save changes

If persist is True, then changes from this point on will not be saved.

Gnm.conf_set_plugin_glpk_glpsol_path(x)
Parameters:

x (str) –

Gnm.conf_set_plugin_latex_use_utf8(x)
Parameters:

x (bool) –

Gnm.conf_set_plugin_lpsolve_lpsolve_path(x)
Parameters:

x (str) –

Gnm.conf_set_plugins_activate_newplugins(x)
Parameters:

x (bool) –

Gnm.conf_set_plugins_active(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_plugins_extra_dirs(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_plugins_file_states(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_plugins_known(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_print_settings(settings)
Parameters:

settings (Gtk.PrintSettings) –

Gnm.conf_set_printsetup_across_then_down(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_all_sheets(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_center_horizontally(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_center_vertically(x)
Parameters:

x (bool) –

Parameters:

x ([str]) – list of strings

Gnm.conf_set_printsetup_gtk_setting(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_printsetup_header(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_printsetup_hf_font_bold(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_hf_font_italic(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_hf_font_name(x)
Parameters:

x (str) –

Gnm.conf_set_printsetup_hf_font_size(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_hf_left(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_printsetup_hf_middle(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_printsetup_hf_right(x)
Parameters:

x ([str]) – list of strings

Gnm.conf_set_printsetup_margin_bottom(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_margin_gtk_bottom(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_margin_gtk_left(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_margin_gtk_right(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_margin_gtk_top(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_margin_top(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_paper(x)
Parameters:

x (str) –

Gnm.conf_set_printsetup_paper_orientation(x)
Parameters:

x (int) –

Gnm.conf_set_printsetup_preferred_unit(x)
Parameters:

x (Gtk.Unit) –

Gnm.conf_set_printsetup_print_black_n_white(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_print_even_if_only_styles(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_print_grid_lines(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_print_titles(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_repeat_left(x)
Parameters:

x (str) –

Gnm.conf_set_printsetup_repeat_top(x)
Parameters:

x (str) –

Gnm.conf_set_printsetup_scale_height(x)
Parameters:

x (int) –

Gnm.conf_set_printsetup_scale_percentage(x)
Parameters:

x (bool) –

Gnm.conf_set_printsetup_scale_percentage_value(x)
Parameters:

x (float) –

Gnm.conf_set_printsetup_scale_width(x)
Parameters:

x (int) –

Gnm.conf_set_searchreplace_change_cell_expressions(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_change_cell_other(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_change_cell_strings(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_change_comments(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_columnmajor(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_error_behaviour(x)
Parameters:

x (int) –

Gnm.conf_set_searchreplace_ignore_case(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_keep_strings(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_preserve_case(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_query(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_regex(x)
Parameters:

x (int) –

Gnm.conf_set_searchreplace_scope(x)
Parameters:

x (int) –

Gnm.conf_set_searchreplace_search_results(x)
Parameters:

x (bool) –

Gnm.conf_set_searchreplace_whole_words_only(x)
Parameters:

x (bool) –

Gnm.conf_set_stf_export_encoding(x)
Parameters:

x (str) –

Gnm.conf_set_stf_export_format(x)
Parameters:

x (Gnm.StfFormatMode) –

Gnm.conf_set_stf_export_locale(x)
Parameters:

x (str) –

Gnm.conf_set_stf_export_quoting(x)
Parameters:

x (Gsf.OutputCsvQuotingMode) –

Gnm.conf_set_stf_export_separator(x)
Parameters:

x (str) –

Gnm.conf_set_stf_export_stringindicator(x)
Parameters:

x (str) –

Gnm.conf_set_stf_export_terminator(x)
Parameters:

x (str) –

Gnm.conf_set_stf_export_transliteration(x)
Parameters:

x (bool) –

Gnm.conf_set_toolbar_position(name, x)
Parameters:
Gnm.conf_set_toolbar_style(x)
Parameters:

x (Gtk.ToolbarStyle) –

Gnm.conf_set_toolbar_visible(name, x)
Parameters:
Gnm.conf_set_undo_max_descriptor_width(x)
Parameters:

x (int) –

Gnm.conf_set_undo_maxnum(x)
Parameters:

x (int) –

Gnm.conf_set_undo_show_sheet_name(x)
Parameters:

x (bool) –

Gnm.conf_set_undo_size(x)
Parameters:

x (int) –

Gnm.convert_to_tooltip(ref_widget, widget)
Parameters:
Returns:

widget

Return type:

Gtk.Widget

Gnm.cot(x)
Parameters:

x (float) – an angle in radians

Returns:

The co-tangent of the given angle.

Return type:

float

Gnm.coth(x)
Parameters:

x (float) – a number.

Returns:

The hyperbolic co-tangent of the given number.

Return type:

float

Gnm.cpp(src, vars)
Parameters:
Return type:

str

Gnm.create_popup_menu(elements, handler, user_data, display_filter, sensitive_filter, event)
Parameters:
Gnm.create_tooltip(ref_widget)
Parameters:

ref_widget (Gtk.Widget) –

Returns:

the newly allocated Gtk.Widget.

Return type:

Gtk.Widget

Gnm.css_debug_color(name, color)
Parameters:
Gnm.css_debug_int(name, i)
Parameters:
Gnm.data_shuffling_free(st)
Parameters:

st (Gnm.data_shuffling_t) –

Gnm.data_shuffling_redo(st)
Parameters:

st (Gnm.data_shuffling_t) –

Gnm.date_add_days(d, n)
Parameters:
Gnm.date_add_months(d, n)
Parameters:
Gnm.date_add_years(d, n)
Parameters:
Gnm.datetime_allow_negative()
Return type:

bool

Gnm.datetime_value_to_g(res, v, conv)
Parameters:
Return type:

bool

Gnm.datetime_value_to_seconds(v, conv)
Parameters:
Return type:

int

Gnm.datetime_value_to_serial(v, conv)
Parameters:
Return type:

int

Gnm.datetime_value_to_serial_raw(v, conv)
Parameters:
Return type:

float

Gnm.dbeta(x, a, b, give_log)
Parameters:

  • x (float) – observation

  • a (float) – the first shape parameter of the distribution

  • b (float) – the second scale parameter of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the beta distribution.

Return type:

float

Gnm.dbinom(x, n, psuc, give_log)
Parameters:

  • x (float) – observation

  • n (float) – the number of trials

  • psuc (float) – the probability of success in each trial

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the binomial distribution.

Return type:

float

Gnm.dbinom_raw(x, n, p, q, give_log)
Parameters:
Return type:

float

Gnm.dcauchy(x, location, scale, give_log)
Parameters:
Return type:

float

Gnm.dchisq(x, df, give_log)
Parameters:

  • x (float) – observation

  • df (float) – the number of degrees of freedom of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the 𝜒² distribution.

Return type:

float

Gnm.debug_flag(flag)
Parameters:

flag (str) –

Return type:

bool

Gnm.dependent_managed_get_expr(dep)
Parameters:

dep (Gnm.DepManaged) –

Return type:

Gnm.ExprTop

Gnm.dependent_managed_init(dep, sheet)
Parameters:
Gnm.dependent_managed_set_expr(dep, texpr)
Parameters:
Gnm.dependent_managed_set_sheet(dep, sheet)
Parameters:
Gnm.dependent_type_register(klass)
Parameters:

klass (Gnm.DependentClass) –

Return type:

int

Gnm.dependent_types_init()
Gnm.dependent_types_shutdown()
Gnm.dependents_dump(wb)
Parameters:

wb (Gnm.Workbook) –

Gnm.dependents_invalidate_sheet(sheet, destroy)
Parameters:
Parameters:

deps ([Gnm.Dependent]) – An slist of dependents.

link a list of dependents. (The list used to get freed, but is not freed anymore.)

Gnm.dependents_relocate(info)
Parameters:

info (Gnm.ExprRelocateInfo) – the descriptor record for what is being moved where.

Returns:

a list of the locations and expressions that were changed outside of the region.

Return type:

GOffice.Undo

Fixes references to or from a region that is going to be moved.

Gnm.dependents_revive_sheet(sheet)
Parameters:

sheet (Gnm.Sheet) –

Gnm.dependents_workbook_destroy(wb)
Parameters:

wb (Gnm.Workbook) –

Gnm.dexp(x, scale, give_log)
Parameters:

  • x (float) – observation

  • scale (float) – the scale parameter of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the exponential distribution.

Return type:

float

Gnm.df(x, n1, n2, give_log)
Parameters:

  • x (float) – observation

  • n1 (float) – the first number of degrees of freedom of the distribution

  • n2 (float) – the first number of degrees of freedom of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the F distribution.

Return type:

float

Gnm.dgamma(x, shape, scale, give_log)
Parameters:

  • x (float) – observation

  • shape (float) – the shape parameter of the distribution

  • scale (float) – the scale parameter of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the gamma distribution.

Return type:

float

Gnm.dgeom(x, psuc, give_log)
Parameters:

  • x (float) – observation

  • psuc (float) – the probability of success in each trial

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the geometric distribution.

Return type:

float

Gnm.dhyper(x, r, b, n, give_log)
Parameters:

  • x (float) – observation

  • r (float) – the number of red balls

  • b (float) – the number of black balls

  • n (float) – the number of balls drawn

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the hypergeometric distribution.

Return type:

float

Gnm.dialog_about(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_advanced_filter(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Show the dialog (guru).

Gnm.dialog_anova_single_factor_tool(wbcg, sheet)
Parameters:
Return type:

int

Gnm.dialog_anova_two_factor_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_auto_filter(wbcg, f, i, is_expr, cur)
Parameters:
Gnm.dialog_autoformat(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – the control that invoked this dialog

This function will show the AutoFormatTemplate dialog and apply the template the user chooses to the current selection in the active sheet of the GOffice.workbook if the user desires.

Gnm.dialog_autosave(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_autosave_prompt(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Return type:

bool

Gnm.dialog_average_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_cell_comment(wbcg, sheet, pos)
Parameters:
Gnm.dialog_cell_format(wbcg, pageno, pages)
Parameters:
Gnm.dialog_cell_format_cond(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_cell_format_select_style(wbcg, pages, w, style, closure)
Parameters:
Returns:

a Gtk.Dialog.

Return type:

Gtk.Dialog

Gnm.dialog_cell_format_style_added(closure, style)
Parameters:
Gnm.dialog_cell_sort(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_chi_square_tool(wbcg, sheet, independence)
Parameters:
Return type:

int

Gnm.dialog_col_width(wbcg, set_default)
Parameters:
Gnm.dialog_consolidate(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_correlation_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_covariance_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_data_slicer(wbcg, create)
Parameters:
Gnm.dialog_data_table(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_define_names(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Create and show the define names dialog.

Gnm.dialog_delete_cells(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_descriptive_stat_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_doc_metadata_new(wbcg, page)
Parameters:

Creates a new instance of the dialog.

Gnm.dialog_exp_smoothing_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_fill_series(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_formula_guru(wbcg, func)
Parameters:

  • wbcg (Gnm.WBCGtk) – The GOffice.workbook to use as a parent window.

  • func (Gnm.Func) –

Pop up a function selector then a formula guru.

Gnm.dialog_fourier_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_frequency_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_ftest_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_function_select(wbcg, key)
Parameters:
Gnm.dialog_function_select_help(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_function_select_paste(wbcg, from_, to)
Parameters:
Gnm.dialog_get_password(parent, filename)
Parameters:
Return type:

str

Gnm.dialog_goal_seek(wbcg, sheet)
Parameters:

Create the dialog (guru).

Gnm.dialog_goto_cell(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_histogram_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Parameters:
Gnm.dialog_insert_cells(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_kaplan_meier_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_merge(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_new_view(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_normality_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_one_mean_test_tool(wbcg, sheet)
Parameters:
Return type:

int

Gnm.dialog_paste_names(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Create and show the define names dialog.

Gnm.dialog_paste_special(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_plugin_manager(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_preferences(wbcg, page)
Parameters:
Gnm.dialog_principal_components_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_printer_setup(wbcg, sheet)
Parameters:
Gnm.dialog_quit(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_raise_if_exists(wbcg, key)
Parameters:
Returns:

existing dialog

Return type:

Gtk.Dialog or None

Raise the dialog identified by key if it is registered on the wbcg.

Gnm.dialog_random_cor_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_random_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_ranking_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_recent_used(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_regression_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_row_height(wbcg, set_default)
Parameters:
Gnm.dialog_sampling_tool(wbcg, sheet)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_scenario_add(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_scenarios(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_search_replace_query(wbcg, sr, location, old_text, new_text)
Parameters:
Return type:

int

Gnm.dialog_setup_destroy_handlers(dialog, wbcg, what)
Parameters:
Gnm.dialog_sheet_compare(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_sheet_order(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_sheet_rename(wbcg, sheet)
Parameters:
Gnm.dialog_sheet_resize(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_shuffle(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Show the dialog (guru).

Gnm.dialog_sign_test_tool(wbcg, sheet, type)
Parameters:
Return type:

int

Gnm.dialog_sign_test_two_tool(wbcg, sheet, type)
Parameters:
Return type:

int

Gnm.dialog_simulation(wbcg, sheet)
Parameters:

Show the dialog (guru).

Gnm.dialog_so_list(wbcg, so)
Parameters:
Gnm.dialog_so_size(wbcg, so)
Parameters:
Gnm.dialog_so_styled(wbcg, so, default_style, title, extent)
Parameters:
Gnm.dialog_solver(wbcg, sheet)
Parameters:

Create the dialog (guru).

Gnm.dialog_tabulate(wbcg, sheet)
Parameters:
Gnm.dialog_tool_preset_to_range(state)
Parameters:

state (Gnm.GenericToolState) –

Gnm.dialog_ttest_tool(wbcg, sheet, test)
Parameters:
Return type:

int

Show the dialog (guru).

Gnm.dialog_wilcoxon_m_w_tool(wbcg, sheet)
Parameters:
Return type:

int

Gnm.dialog_workbook_attr(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.dialog_zoom(wbcg, sheet)
Parameters:
Gnm.diff_sheets(actions, user, old_sheet, new_sheet)
Parameters:
Return type:

bool

Gnm.diff_workbooks(actions, user, old_wb, new_wb)
Parameters:
Return type:

int

Gnm.digamma(x)
Parameters:

x (float) – a number

Returns:

the digamma function evaluated at x.

Return type:

float

Gnm.discpfuncinverter(p, shape, lower_tail, log_p, xlow, xhigh, x0, pfunc)
Parameters:
Return type:

float

Discrete pfuncs only. (Specifically: only integer x are allowed).

Gnm.dlnorm(x, logmean, logsd, give_log)
Parameters:

  • x (float) – observation

  • logmean (float) – mean of the underlying normal distribution

  • logsd (float) – standard deviation of the underlying normal distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the log-normal distribution.

Return type:

float

Gnm.dnbinom(x, n, psuc, give_log)
Parameters:

  • x (float) – observation

  • n (float) – the number of trials

  • psuc (float) – the probability of success in each trial

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the negative binomial distribution.

Return type:

float

Gnm.dnorm(x, mu, sigma, give_log)
Parameters:

  • x (float) – observation

  • mu (float) – mean of the distribution

  • sigma (float) – standard deviation of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the normal distribution.

Return type:

float

Gnm.do_tabulation(wbc, data)
Parameters:
Return type:

[int]

Gnm.dpois(x, lambda_, give_log)
Parameters:

  • x (float) – observation

  • lambda (float) – the mean of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the Poisson distribution.

Return type:

float

Gnm.dpois_raw(x, lambda_, give_log)
Parameters:
Return type:

float

Gnm.drayleigh(x, scale, give_log)
Parameters:

  • x (float) – observation

  • scale (float) – scale parameter

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the Rayleigh distribution.

Return type:

float

Gnm.dt(x, n, give_log)
Parameters:

  • x (float) – observation

  • n (float) – the number of degrees of freedom of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the Student t distribution.

Return type:

float

Gnm.dweibull(x, shape, scale, give_log)
Parameters:

  • x (float) – observation

  • shape (float) – the shape parameter of the distribution

  • scale (float) – the scale parameter of the distribution

  • give_log (bool) – if True, log of the result will be returned instead

Returns:

density of the Weibull distribution.

Return type:

float

Gnm.editable_enters(window, editable)
Parameters:

Make the “activate” signal of an editable click the default dialog button.

This is a literal copy of gnome_dialog_editable_enters, but not restricted to GnomeDialogs.

Normally if there’s an editable widget (such as Gtk.Entry) in your dialog, pressing Enter will activate the editable rather than the default dialog button. However, in most cases, the user expects to type something in and then press enter to close the dialog. This function enables that behavior.

Gnm.entry_to_float_with_format(entry, the_float, update, format)
Parameters:
Return type:

bool

Gnm.entry_to_float_with_format_default(entry, the_float, update, format, num)
Parameters:
Return type:

bool

Gnm.entry_to_int(entry, the_int, update)
Parameters:
Return type:

bool

Retrieve an int from an entry field parsing all reasonable formats

Gnm.error_array()
Return type:

int

Gnm.error_calc()
Return type:

int

Gnm.error_in_entry(state, entry, err_str)
Parameters:

Show an error dialog and select corresponding entry

Gnm.eval_info_get_arg_count(ei)
Parameters:

ei (Gnm.FuncEvalInfo) –

Return type:

int

Gnm.eval_info_get_func(ei)
Parameters:

ei (Gnm.FuncEvalInfo) – Gnm.FuncEvalInfo

Returns:

the called function.

Return type:

Gnm.Func

Gnm.excel_search_impl(needle, haystack, skip)
Parameters:

  • needle (str) – the pattern to search for, see Gnm.regcomp_XL.

  • haystack (str) – the string to search in.

  • skip (int) – zero-based search start point in characters.

Returns:

-1 for a non-match, or zero-based location in characters.

The is the implementation of Excel’s SEARCH function. However, note that skip and return GOffice.value are zero-based.

Return type:

int

Gnm.expmx2h(x)
Parameters:

x (float) – a number

Returns:

The result of exp(-0.5`x` x) with higher accuracy than the naive formula.

Return type:

float

Gnm.expr_cell_deriv(y, x)
Parameters:
Returns:

The derivative of cell y with respect to cell x.

Return type:

Gnm.ExprTop or None

Gnm.expr_cell_deriv_value(y, x)
Parameters:
Returns:

The derivative of cell y with respect to cell x at the current GOffice.value of x. Returns NaN on error.

Return type:

float

Gnm.expr_conv_quote(convs, str)
Parameters:
Returns:

A quoted string according to convs. If no quoting is necessary, a literal copy of str will be returned.

Return type:

GLib.String

Gnm.expr_deriv_shutdown_()
Gnm.expr_lex_all(str, pp, flags, convs)
Parameters:
Return type:

Gnm.LexerItem

Gnm.expr_list_as_string(argc, argv, out)
Parameters:
Gnm.expr_list_copy(list)
Parameters:

list ([object]) – list of expressions

Returns:

a copy of the list and all the expressions in it.

Return type:

[object]

Gnm.expr_list_unref(list)
Parameters:

list ([object]) – expression list

This frees list and all the expressions in it.

Gnm.expr_name_add_dep(nexpr, dep)
Parameters:
Gnm.expr_name_as_string(nexpr, pp, fmt)
Parameters:
Returns:

The rendering of nexpr given convention fmt.

Return type:

str

Gnm.expr_name_check_for_loop(name, texpr)
Parameters:

  • name (str) – tentative name

  • texpr (Gnm.ExprTop) – tentative expression

Returns:

True if defining the tentative name would cause a circular name reference.

NOTE: if we already have a circular reference beforehand, we will come to serious grief.

Return type:

bool

Gnm.expr_name_cmp_by_name(a, b)
Parameters:
Return type:

int

Gnm.expr_name_downgrade_to_placeholder(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) –

Takes a real non-placeholder name and converts it to being a placeholder. unrefing its expression

Gnm.expr_name_eval(nexpr, pos, flags)
Parameters:
Returns:

The resulting GOffice.value.

Return type:

Gnm.Value

Gnm.expr_name_in_use(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) – A named expression.

Returns:

True, if the named expression appears to be in use. This is an approximation only, as we only look at the GOffice.workbook in which the name is defined.

Return type:

bool

Gnm.expr_name_is_active(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) –

Return type:

bool

Gnm.expr_name_is_placeholder(ne)
Parameters:

ne (Gnm.NamedExpr) –

Returns:

True if ne is a placeholder for an unknown name

Return type:

bool

Gnm.expr_name_lookup(pos, name)
Parameters:
Returns:

Gnm.NamedExpr named name in the scope given by pos; None if no such Gnm.NamedExpr exists.

Return type:

Gnm.NamedExpr or None

Gnm.expr_name_name(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) –

Return type:

str

Gnm.expr_name_new(name)
Parameters:

name (str) –

Return type:

Gnm.NamedExpr

Creates a new name without linking it into any container.

Gnm.expr_name_perm_add(sheet, name, texpr, is_editable)
Parameters:

  • sheet (Gnm.Sheet) –

  • name (str) – name

  • texpr (Gnm.ExprTop) – string to be the GOffice.value of the name

  • is_editable (bool) – whether this is a predefined action

This is a wrapper around expr_name_add to set this as permanent name.

Gnm.expr_name_ref(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) –

Return type:

Gnm.NamedExpr

Gnm.expr_name_remove(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) –

Remove a nexpr from its container and deactivate it. NOTE : nexpr may continue to exist if things still have references to it, but they will evaluate to #REF!

Gnm.expr_name_remove_dep(nexpr, dep)
Parameters:
Gnm.expr_name_set_expr(nexpr, texpr)
Parameters:

Set the content of nexpr to texpr.

Gnm.expr_name_set_expr_undo_new(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) – Gnm.NamedExpr

Return type:

GOffice.Undo

Gnm.expr_name_set_is_placeholder(nexpr, is_placeholder)
Parameters:
Gnm.expr_name_set_name(nexpr, new_name)
Parameters:

  • nexpr (Gnm.NamedExpr) – the named expression

  • new_name (str) – the new name of the expression

Returns:

True on error.

Return type:

bool

Gnm.expr_name_set_pos(nexpr, pp)
Parameters:
Return type:

str

Returns a translated error string which the caller must free if something goes wrong.

Gnm.expr_name_unref(nexpr)
Parameters:

nexpr (Gnm.NamedExpr) –

Gnm.expr_name_validate(name)
Parameters:

name (str) – tentative name

Return type:

bool

returns True if the given name is valid, False otherwise.

Gnm.expr_parse_str(str, pp, flags, convs, error)
Parameters:
Return type:

Gnm.ExprTop

Gnm.fact(x)
Parameters:

x (float) – number

Returns:

the factorial of x, which must not be a negative integer.

Return type:

float

Gnm.fact2(x)
Parameters:

x (int) –

Return type:

float

Gnm.factx(x, expb)
Parameters:
Return type:

float

Gnm.file_saver_common_export_option(fs, wb, key, value)
Parameters:
Raises:

GLib.Error

Return type:

bool

Gnm.file_saver_get_sheet(fs, wbv)
Parameters:
Returns:

the sheet to export

Return type:

Gnm.Sheet

For a single-sheet saver, this function determines what sheet to save.

Gnm.file_saver_get_sheets(fs, wbv, default_all)
Parameters:
Returns:

the sheets to export

Note: the return GOffice.value should be unreffed, not freed.

Return type:

[Gnm.Sheet]

This function determines what sheets to save.

Gnm.fill_series_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.filter_show_all(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Gnm.find_column_of_field(ep, database, field)
Parameters:
Return type:

int

Gnm.find_rows_that_match(sheet, first_col, first_row, last_col, last_row, criterias, unique_only)
Parameters:

  • sheet (Gnm.Sheet) – Gnm.Sheet

  • first_col (int) – first column.

  • first_row (int) – first Gnm.row.

  • last_col (int) – last column.

  • last_row (int) – last Gnm.row.

  • criterias ([Gnm.DBCriteria]) – the criteria to use.

  • unique_only (bool) –

Returns:

the list of matching rows.

Return type:

[int]

Finds the rows from the given database that match the criteria.

Gnm.float_equal(a, b)
Parameters:
Return type:

int

Gnm.float_hash(d)
Parameters:

d (float) –

Return type:

int

Gnm.float_range_function(argv, ei, func, flags, func_error)
Parameters:
Returns:

Function result or error GOffice.value.

Return type:

Gnm.Value

This implements a Gnumeric sheet function that operates on a list of numbers. This function collects the arguments and uses func to do the actual computation.

Gnm.float_range_function2(val0, val1, ei, func, flags, func_error)
Parameters:
Returns:

Function result or error GOffice.value.

Return type:

Gnm.Value

This implements a Gnumeric sheet function that operates on a matched pair of ranges. This function collects the arguments and uses func to do the actual computation.

Gnm.float_range_function2d(val0, val1, ei, func, flags, func_error, *data)
Parameters:
Returns:

Function result or error GOffice.value.

Return type:

Gnm.Value

This implements a Gnumeric sheet function that operates on a matched pair of ranges. This function collects the arguments and uses func to do the actual computation.

Gnm.float_to_entry(entry, the_float)
Parameters:
Gnm.focus_on_entry(entry)
Parameters:

entry (Gtk.Entry) –

Gnm.font_equal(v, v2)
Parameters:
Return type:

int

Gnm.font_hash(v)
Parameters:

v (object or None) –

Return type:

int

Gnm.font_override_codepage(font_name)
Parameters:

font_name (str) – The win32 Gnm.font name

Return type:

int

Returns a codepage for the named Win32 Gnm.font, or -1 if no such codepage is known.

Gnm.format_for_date_editing(cell)
Parameters:

cell (Gnm.Cell) –

Return type:

GOffice.Format

Gnm.format_frob_slashes(s)
Parameters:

s (str) –

Return type:

str

Gnm.format_has_hour(fmt, value)
Parameters:
Return type:

bool

Gnm.format_import(fmt, flags)
Parameters:
Return type:

GOffice.Format

Gnm.format_is_date_for_value(fmt, value)
Parameters:
Return type:

int

Gnm.format_is_time_for_value(fmt, value)
Parameters:
Return type:

int

Gnm.format_layout(result, metrics, format, value, col_width, date_conv, unicode_minus)
Parameters:
Return type:

GOffice.FormatNumberError

Gnm.format_match(text, cur_fmt, date_conv)
Parameters:
Return type:

Gnm.Value

Attempts to parse the supplied string to see if it matches a known GOffice.value format. The caller is responsible for releasing the resulting GOffice.value.

Gnm.format_match_datetime(text, date_conv, month_before_day, add_format, presume_date)
Parameters:
Return type:

Gnm.Value

Gnm.format_match_decimal_number_with_locale(text, family, curr, thousand, decimal)
Parameters:
Return type:

Gnm.Value

Gnm.format_match_number(text, cur_fmt, date_conv)
Parameters:
Return type:

Gnm.Value

Attempts to parse the supplied string to see if it matches a known GOffice.value format. Will eventually use the current cell format in preference to canned formats. If format is supplied it will get a copy of the matching format with no additional references. The caller is responsible for releasing the resulting GOffice.value. Will ONLY return numbers.

Gnm.format_match_simple(text)
Parameters:

text (str) – A String to match against.

Return type:

Gnm.Value

Attempt to match the supplied string as a simple GOffice.value.

WARNING WARNING WARNING : This routine should NEVER be changed to match Gnm.ValueType.STRING that will break the parsers handling of named expressions.

Gnm.format_month_before_day(fmt, value)
Parameters:
Return type:

int

Gnm.format_sel_new()
Returns:

a new format selector

Return type:

Gtk.Widget

Gnm.format_sel_set_value(nfs, value)
Parameters:
Gnm.format_specialize(fmt, value)
Parameters:
Return type:

GOffice.Format

Gnm.format_value(format, value, col_width, date_conv)
Parameters:
Return type:

str

Gnm.format_value_gstring(str, format, value, col_width, date_conv)
Parameters:
Return type:

GOffice.FormatNumberError

Gnm.format_value_layout(layout, format, value, col_width, date_conv)
Parameters:
Return type:

GOffice.FormatNumberError

Gnm.free_criterias(criterias)
Parameters:

criterias ([Gnm.Criteria]) – the criteria to be freed. Frees the allocated memory.

Gnm.ft_category_group_cmp(a, b)
Parameters:
Return type:

int

Gnm.ft_category_group_list_free(category_groups)
Parameters:

category_groups ([Gnm.FTCategoryGroup]) – the list to free.

Gnm.ft_category_group_list_get()
Returns:

the list of Gnm.FTCategoryGroup which should be freed using Gnm.FTCategoryGroup.list_free().

Return type:

[Gnm.FTCategoryGroup]

Gnm.ft_compare_name(a, b)
Parameters:
Return type:

int

Gnm.func_group_fetch(name, translation)
Parameters:

  • name (str) –

  • translation (str) –

Return type:

Gnm.FuncGroup

Gnm.func_group_get_nth(n)
Parameters:

n (int) –

Return type:

Gnm.FuncGroup

Gnm.function_call_with_exprs(ei)
Parameters:

ei (Gnm.FuncEvalInfo) – EvalInfo containing valid fn_def!

Return type:

Gnm.Value

Do the guts of calling a function.

Returns the result.

Gnm.function_call_with_values(ep, name, argc, values)
Parameters:
Return type:

Gnm.Value

Gnm.function_def_call_with_values(ep, fn, argc, values)
Parameters:
Return type:

Gnm.Value

Gnm.function_iterate_argument_values(ep, callback, callback_closure, argc, argv, strict, iter_flags)
Parameters:

  • ep (Gnm.EvalPos) – The position in a GOffice.workbook at which to evaluate

  • callback (Gnm.FunctionIterateCB) – The routine to be invoked for every GOffice.value computed

  • callback_closure (object or None) – Closure for the callback.

  • argc (int) –

  • argv (Gnm.Expr) –

  • strict (bool) – If True, the function is considered “strict”. This means that if an error GOffice.value occurs as an argument, the iteration will stop and that error will be returned. If False, an error will be passed on to the callback (as a Gnm.Value * of type Gnm.ValueType.ERROR).

  • iter_flags (Gnm.CellIterFlags) –

Returns:

None : if no errors were reported. Gnm.Value * : if an error was found during strict evaluation VALUE_TERMINATE : if the callback requested termination of the iteration.

This routine provides a simple way for internal functions with variable number of arguments to be written: this would iterate over a list of expressions (expr_node_list) and will invoke the callback for every Gnm.Value found on the list (this means that ranges get properly expanded).

Return type:

Gnm.Value

Gnm.gamma(x)
Parameters:

x (float) – a number

Returns:

the Gamma function evaluated at x for positive or non-integer x.

Return type:

float

Gnm.gammax(x, expb)
Parameters:
Return type:

float

Gnm.get_argv0()
Return type:

str

Parameters:
Gnm.get_pango_attributes_from_buffer(buffer)
Parameters:

buffer (Gtk.TextBuffer) –

Return type:

Pango.AttrList

Gnm.global_range_contained(sheet, a, b)
Parameters:
Returns:

True if a is contained in b. We do not handle 3d ranges

Return type:

bool

Gnm.global_range_list_foreach(gr_list, ep, flags, handler, closure)
Parameters:
Return type:

Gnm.Value

Gnm.global_range_list_parse(sheet, str)
Parameters:

  • sheet (Gnm.Sheet) – Gnm.Sheet where the range specification is relatively parsed to

  • str (str) – a range or list of ranges to parse (ex: “A1”, “A1:B1,C2,Sheet2!D2:D4”)

Returns:

a GLib.SList of Gnm.Value.

Return type:

[Gnm.Value]

Parses a list of ranges, relative to the sheet and returns a list with the results.

Gnm.global_range_name(sheet, r)
Parameters:
Return type:

str

Gnm.go_data_foreach_dep(dat, so, func, user)
Parameters:
Gnm.go_data_get_expr(dat)
Parameters:

dat (GOffice.Data) –

Return type:

Gnm.ExprTop

Gnm.go_data_get_sheet(dat)
Parameters:

dat (GOffice.Data) – GOffice.Data

Returns:

the sheet.

Return type:

Gnm.Sheet

Gnm.go_data_set_sheet(dat, sheet)
Parameters:
Gnm.go_error_info_dialog_create(error)
Parameters:

error (GOffice.ErrorInfo) –

Returns:

the newly allocated dialog.

Return type:

Gtk.Widget

SHOULD BE IN GOFFICE

Gnm.go_error_info_dialog_show(parent, error)
Parameters:
Gnm.go_error_info_list_dialog_show(parent, errs)
Parameters:
Gnm.goal_seek_bisection(f, data, *user_data)
Parameters:
Return type:

Gnm.GoalSeekStatus

Seek a goal (root) using bisection methods.

The supplied function must (should) be continuous over the interval.

Caller must have located a positive and a negative point.

This method will find a root steadily using bisection to narrow the interval in which a root lies.

It alternates between mid-point-bisection (semi-slow, but guaranteed progress), secant-bisection (usually quite fast, but sometimes gets nowhere), and Ridder’s Method (usually fast, harder to fool than the secant method).

Gnm.goal_seek_cell(data, celldata)
Parameters:
Return type:

Gnm.GoalSeekStatus

Gnm.goal_seek_eval_cell(x, data)
Parameters:

  • x (float) – x-GOffice.value for which to evaluate

  • data (object or None) – user data

Returns:

An status indicating whether evaluation went ok.

y:

location to store result

Return type:

(Gnm.GoalSeekStatus, y: float)

Gnm.goal_seek_initialize(data)
Parameters:

data (Gnm.GoalSeekData) –

Gnm.goal_seek_newton(f, df, data, user_data, x0)
Parameters:
Return type:

Gnm.GoalSeekStatus

Seek a goal (root) using Newton’s iterative method.

The supplied function must (should) be continuously differentiable in the supplied interval. If df is None, this function will estimate the derivative.

This method will find a root rapidly provided the initial guess, x0, is sufficiently close to the root. (The number of significant digits (asymptotically) goes like i^2 unless the root is a multiple root in which case it is only like c*i.)

Gnm.goal_seek_point(f, data, user_data, x0)
Parameters:
Return type:

Gnm.GoalSeekStatus

Seek a goal using a single point.

Gnm.goal_seek_trawl_normally(f, data, user_data, mu, sigma, points)
Parameters:
Return type:

Gnm.GoalSeekStatus

Gnm.goal_seek_trawl_uniformly(f, data, user_data, xmin, xmax, points)
Parameters:
Return type:

Gnm.GoalSeekStatus

Gnm.gtk_builder_load(uifile, domain, cc)
Parameters:
Returns:

the newly allocated Gtk.Builder.

Return type:

Gtk.Builder

Simple utility to open ui files

Gnm.gtk_print_cell_range(context, sheet, range, base_x, base_y, pinfo)
Parameters:
Gnm.gtk_radio_group_get_selected(radio_group)
Parameters:

radio_group ([Gtk.RadioButton]) – list of radio buttons.

Returns:

the index of the selected radio button starting from list end.

Return type:

int

Gnm.gui_clipboard_test(fmt)
Parameters:

fmt (str) –

Return type:

GLib.Bytes

Gnm.gui_file_export_repeat(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Return type:

bool

Gnm.gui_file_open(wbcg, type, default_format)
Parameters:
Gnm.gui_file_read(wbcg, file_name, optional_format, optional_encoding)
Parameters:
Returns:

the new Gnm.WorkbookView for the file read.

Return type:

Gnm.WorkbookView

Gnm.gui_file_save(wbcg, wbv)
Parameters:
Return type:

bool

Gnm.gui_file_save_as(wbcg, wbv, type, default_format)
Parameters:
Return type:

bool

Gnm.gui_file_template(wbcg, uri)
Parameters:
Return type:

bool

Gnm.gui_group_value(gui, group)
Parameters:
Return type:

int

Gnm.gui_wb_view_show(wbcg, wbv)
Parameters:
Gnm.gutils_init()
Gnm.gutils_shutdown()
Gnm.hash_table_foreach_ordered(h, callback, order, user)
Parameters:

Like GLib.HashTable.foreach, but with an ordering imposed.

Gnm.history_item_label(uri, accel_number)
Parameters:

  • uri (str) –

  • accel_number (int) –

Return type:

str

Gnm.ifs_func(data, crits, vals, fun, err, ep, flags)
Parameters:
Returns:

Function result or error GOffice.value.

Return type:

Gnm.Value

This implements a Gnumeric sheet database function of the “*IFS” type This function collects the arguments and uses fun to do the actual computation.

Gnm.ilog(x, b)
Parameters:
Return type:

float

Gnm.init()
Gnm.init_help_button(w, lnk)
Parameters:
Gnm.insert_meta_date(doc, name)
Parameters:
Gnm.int_to_entry(entry, the_int)
Parameters:
Gnm.keyed_dialog(wbcg, dialog, key)
Parameters:

Make dialog a transient child of wbcg, attaching to wbcg object data to identify the dialog. The object data makes it possible to ensure that only one dialog of a kind can be displayed for a wbcg. Deallocation of the object data is managed here.

Gnm.lambert_w(x, k)
Parameters:

  • x (float) – a number

  • k (int) – branch, either 0 or -1

Returns:

The Lambert W function at x. k is a branch number: 0 for the primary branch and -1 for the alternate.

Return type:

float

Gnm.lbeta(a, b)
Parameters:
Return type:

float

Gnm.lbeta3(a, b)
Parameters:
Returns:

the logarithm of the absolute GOffice.value of the Beta function evaluated at a and b. The sign will be stored in sign as -1 or +1. This function is useful because the result of the beta function can be too large for doubles.

sign:

the sign

Return type:

(float, sign: int)

Gnm.lgamma1p(a)
Parameters:

a (float) –

Return type:

float

Gnm.linear_solve(A, b, x)
Parameters:
Return type:

GOffice.RegressionResult

Gnm.linear_solve_multiple(A, B)
Parameters:
Return type:

GOffice.RegressionResult

Gnm.linear_solve_posdef(A, b, x)
Parameters:
Return type:

GOffice.RegressionResult

Gnm.link_button_and_entry(button, entry)
Parameters:
Gnm.load_pango_attributes_into_buffer(markup, buffer, str)
Parameters:
Gnm.locale_dir()
Return type:

str

Gnm.log1pmx(x)
Parameters:

x (float) – a number

Returns:

log(1+`x`)-x with less rounding error than the naive formula, especially for small values of x.

Return type:

float

Gnm.logcf(x, i, d, tol)
Parameters:
Return type:

float

Gnm.logspace_add(logx, logy)
Parameters:
Return type:

float

Gnm.logspace_sub(logx, logy)
Parameters:
Return type:

float

Gnm.make_cellref(dx, dy)
Parameters:
Return type:

Gnm.Expr

Gnm.make_rangeref(dx0, dy0, dx1, dy1)
Parameters:
Return type:

Gnm.Expr

Gnm.mathfunc_init()
Gnm.matrix_from_value(v, ep)
Parameters:
Returns:

A new Gnm.Matrix, None on error.

perr:

Gnm.Value with error GOffice.value

Return type:

(Gnm.Matrix or None, perr: Gnm.Value)

Gnm.message_dialog_create(parent, flags, type, primary_message, secondary_message)
Parameters:
Returns:

a Gtk.Dialog, without buttons.

Return type:

Gtk.Widget

A convenience function to build HIG compliant message dialogs.

parent : transient parent, or None for none. flags type : type of dialog primary_message : message displayed in bold secondary_message : message displayed below

Gnm.object_get_bool(o, name)
Parameters:
Returns:

the GOffice.value of o's boolean property name.

Return type:

bool

Gnm.object_has_readable_prop(obj, property, typ)
Parameters:
Returns:

True if obj has a readable property named property of type typ.

pres:

location to store property GOffice.value.

Return type:

(bool, pres: object)

Gnm.owent(h, a)
Parameters:
Return type:

float

Gnm.page_break_type_from_str(str)
Parameters:

str (str) –

Return type:

Gnm.PageBreakType

Gnm.page_setup_get_paper(page_setup)
Parameters:

page_setup (Gtk.PageSetup) –

Return type:

str

Gnm.page_setup_set_paper(page_setup, paper)
Parameters:
Return type:

bool

Gnm.pango_attr_list_equal(l1, l2)
Parameters:
Return type:

bool

Gnm.pango_context_get()
Return type:

Pango.Context

Simple wrapper to handle windowless operation

Gnm.parse_criteria(crit_val, date_conv, anchor_end)
Parameters:
Returns:

Gnm.Criteria which caller must free.

”>=:obj:GOffice.value" “<=:obj:GOffice.value" “<>:obj:GOffice.value" “<GOffice.value" “>:obj:GOffice.value" “=:obj:GOffice.value" “pattern”

Return type:

Gnm.Criteria

Gnm.parse_database_criteria(ep, database, criteria)
Parameters:
Return type:

[Gnm.DBCriteria]

Parses the criteria cell range.

Gnm.parse_text_value_or_expr(pos, text)
Parameters:

  • pos (Gnm.ParsePos) – If the string looks like an expression parse it at this location.

  • text (str) – The text to be parsed.

Returns:

val:

Returns a Gnm.Value if the text was a GOffice.value, otherwise None.

texpr:

Returns a Gnm.ExprTop if the text was an expression, otherwise None.

Return type:

(val: Gnm.Value, texpr: Gnm.ExprTop or None)

Utility routine to parse a string and convert it into an expression or GOffice.value.

If there is a parse failure for an expression an error Gnm.Value with the syntax error is returned in val.

Gnm.parse_util_init()
Gnm.parse_util_shutdown()
Gnm.parsepos_as_string(pp)
Parameters:

pp (Gnm.ParsePos) –

Return type:

str

Gnm.pattern_background_set(mstyle, cr, is_selected, ctxt)
Parameters:
Returns:

True if there is a background to paint.

Set up a cairo context to paint the background of a cell.

Return type:

bool

Gnm.pbeta(x, a, b, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • a (float) – the first shape parameter of the distribution

  • b (float) – the second scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the beta distribution.

Return type:

float

Gnm.pbinom(x, n, psuc, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • n (float) – the number of trials

  • psuc (float) – the probability of success in each trial

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the binomial distribution.

Return type:

float

Gnm.pbinom2(x0, x1, n, p)
Parameters:
Return type:

float

Gnm.pcauchy(x, location, scale, lower_tail, log_p)
Parameters:
Return type:

float

Gnm.pchisq(x, df, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • df (float) – the number of degrees of freedom of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the 𝜒² distribution.

Return type:

float

Gnm.permut(n, k)
Parameters:
Return type:

float

Gnm.pexp(x, scale, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • scale (float) – the scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the exponential distribution.

Return type:

float

Gnm.pf(x, n1, n2, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • n1 (float) – the first number of degrees of freedom of the distribution

  • n2 (float) – the first number of degrees of freedom of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the F distribution.

Return type:

float

Gnm.pfuncinverter(p, shape, lower_tail, log_p, xlow, xhigh, x0, pfunc, dpfunc_dx)
Parameters:
Return type:

float

Gnm.pgamma(x, shape, scale, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • shape (float) – the shape parameter of the distribution

  • scale (float) – the scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the gamma distribution.

Return type:

float

Gnm.pgeom(x, psuc, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • psuc (float) – the probability of success in each trial

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the geometric distribution.

Return type:

float

Gnm.phyper(x, r, b, n, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • r (float) – the number of red balls

  • b (float) – the number of black balls

  • n (float) – the number of balls drawn

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the hypergeometric distribution.

Return type:

float

Gnm.plnorm(x, logmean, logsd, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • logmean (float) – mean of the underlying normal distribution

  • logsd (float) – standard deviation of the underlying normal distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the log-normal distribution.

Return type:

float

Gnm.plugins_init(c)
Parameters:

c (GOffice.CmdContext) –

Gnm.pnbinom(x, n, psuc, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • n (float) – the number of trials

  • psuc (float) – the probability of success in each trial

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the negative binomial distribution.

Return type:

float

Gnm.pnorm(x, mu, sigma, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • mu (float) – mean of the distribution

  • sigma (float) – standard deviation of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the normal distribution.

Return type:

float

Gnm.pnorm2(x1, x2)
Parameters:
Return type:

float

Gnm.pochhammer(x, n)
Parameters:

  • x (float) – a real number

  • n (float) – a real number, often an integer

Returns:

Pochhammer’s symbol (x)_`n`.

Return type:

float

This function computes Pochhammer’s symbol at x and n, i.e., Gamma(x+`n`)/Gamma(x). This is well defined unless x or x+`n` is a non-negative integer. The ratio has a removable singlularity at n=0 and the result is 1.

Gnm.popup_menu(menu, event)
Parameters:

Bring up a popup and if event is non-None ensure that the popup is on the right screen.

Gnm.position_tooltip(tip, px, py, horizontal)
Parameters:
Gnm.pow1p(x, y)
Parameters:
Returns:

The result of (1+`x`)^`y` with less rounding error than the naive formula.

Return type:

float

Gnm.pow1pm1(x, y)
Parameters:
Returns:

The result of (1+`x`)^`y`-1 with less rounding error than the naive formula.

Return type:

float

Gnm.ppois(x, lambda_, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • lambda (float) – the mean of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the Poisson distribution.

Return type:

float

Gnm.prayleigh(x, scale, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • scale (float) – scale parameter

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the Rayleigh distribution.

Return type:

float

Gnm.pre_parse_init(argc, argv)
Parameters:

  • argc (int) –

  • argv (str) –

Returns:

the arguments in UTF-8 encoding.

Return type:

[str]

Initialization to be done before cmd line arguments are handled. Needs to be called first, before any other initialization.

Gnm.pre_parse_shutdown()
Gnm.prepare_input_range(input_range, group_by)
Parameters:
Return type:

input_range: [Gnm.Range]

Gnm.print_hf_format_render(format, info, render_type)
Parameters:
Return type:

str

Gnm.print_info_dup(pi)
Parameters:

pi (Gnm.PrintInformation) –

Return type:

Gnm.PrintInformation

Gnm.print_info_free(pi)
Parameters:

pi (Gnm.PrintInformation) –

Gnm.print_info_get_margins(pi)
Parameters:

pi (Gnm.PrintInformation) – Gnm.PrintInformation

Returns:

top:

top margin.

bottom:

bottom margin.

left:

left margin.

right:

right margin.

edge_to_below_header:

margin.

edge_to_above_footer:

margin.

Return type:

(top: float, bottom: float, left: float, right: float, edge_to_below_header: float, edge_to_above_footer: float)

Gnm.print_info_get_page_setup(pi)
Parameters:

pi (Gnm.PrintInformation) – Gnm.PrintInformation

Returns:

the page setup.

Return type:

Gtk.PageSetup

Gnm.print_info_get_paper(pi)
Parameters:

pi (Gnm.PrintInformation) –

Return type:

str

Gnm.print_info_get_paper_display_name(pi)
Parameters:

pi (Gnm.PrintInformation) – Gnm.PrintInformation

Returns:

the name of the selected paper type

Return type:

str

Gnm.print_info_get_paper_height(pi, unit)
Parameters:
Return type:

float

Gnm.print_info_get_paper_orientation(pi)
Parameters:

pi (Gnm.PrintInformation) –

Return type:

Gtk.PageOrientation

Gnm.print_info_get_paper_size(pi)
Parameters:

pi (Gnm.PrintInformation) –

Return type:

Gtk.PaperSize

Gnm.print_info_get_paper_width(pi, unit)
Parameters:
Return type:

float

Gnm.print_info_get_printrange(pi)
Parameters:

pi (Gnm.PrintInformation) –

Return type:

Gnm.PrintRange

Gnm.print_info_get_printtofile_uri(pi)
Parameters:

pi (Gnm.PrintInformation) – GnmPrintInformation

Returns:

The uri used for print-to-file.

Return type:

str

Gnm.print_info_has_manual_breaks(pi)
Parameters:

pi (Gnm.PrintInformation) –

Return type:

bool

Gnm.print_info_load_defaults(pi)
Parameters:

pi (Gnm.PrintInformation) – Gnm.PrintInformation

NOTE: This reads from a globally stored configuration. If a configuration is stored along with a sheet then that will override these global defaults.

Gnm.print_info_save(pi)
Parameters:

pi (Gnm.PrintInformation) –

Gnm.print_info_set_breaks(pi, breaks)
Parameters:
Parameters:
Gnm.print_info_set_edge_to_below_header(pi, e_h)
Parameters:
Gnm.print_info_set_from_settings(pi, settings)
Parameters:
Parameters:
Gnm.print_info_set_margin_header(pi, header)
Parameters:
Gnm.print_info_set_margin_left(pi, left)
Parameters:
Gnm.print_info_set_margin_right(pi, right)
Parameters:
Gnm.print_info_set_margins(pi, header, footer, left, right)
Parameters:
Gnm.print_info_set_page_setup(pi, page_setup)
Parameters:

Absorb a ref to page_setup.

WHY WHY WHY 1) The life cycle in here is a tad odd, the load_defaults does nothing for the case of an existing page_setup, and seems like it should be ignored for the case of a new one.

  1. Why not copy the page_setup in here and make the arg const ?

Gnm.print_info_set_paper(pi, paper)
Parameters:
Return type:

bool

Gnm.print_info_set_paper_orientation(pi, orientation)
Parameters:
Gnm.print_info_set_printrange(pi, pr)
Parameters:
Gnm.print_info_set_printtofile_from_settings(pi, settings, default_uri)
Parameters:
Gnm.print_info_set_printtofile_uri(pi, uri)
Parameters:
Gnm.print_load_repeat_range(str, r, sheet)
Parameters:
Return type:

bool

Gnm.print_sheet(wbc, sheet, preview, default_range, export_dst)
Parameters:
Gnm.print_sheet_objects(cr, sheet, range, base_x, base_y)
Parameters:
Gnm.print_so(wbc, sos, export_dst)
Parameters:
Gnm.pt(x, n, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • n (float) – the number of degrees of freedom of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the Student t distribution.

Return type:

float

Gnm.ptukey(x, nmeans, df, nranges, lower_tail, log_p)
Parameters:
Return type:

float

Gnm.pweibull(x, shape, scale, lower_tail, log_p)
Parameters:

  • x (float) – observation

  • shape (float) – the shape parameter of the distribution

  • scale (float) – the scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

cumulative density of the Weibull distribution.

Return type:

float

Gnm.qbeta(p, a, b, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • a (float) – the first shape parameter of the distribution

  • b (float) – the second scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the beta distribution.

Return type:

float

Gnm.qbinom(p, n, psuc, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • n (float) – the number of trials

  • psuc (float) – the probability of success in each trial

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the binomial distribution.

Return type:

float

Gnm.qcauchy(p, location, scale, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • location (float) – center of distribution

  • scale (float) – scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the Cauchy distribution.

Return type:

float

Gnm.qchisq(p, df, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • df (float) – the number of degrees of freedom of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the 𝜒² distribution.

Return type:

float

Gnm.qexp(p, scale, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • scale (float) – the scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the exponential distribution.

Return type:

float

Gnm.qf(p, n1, n2, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • n1 (float) – the first number of degrees of freedom of the distribution

  • n2 (float) – the first number of degrees of freedom of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the F distribution.

Return type:

float

Gnm.qfactf(x, mant, expb)
Parameters:
Return type:

int

Gnm.qgamma(p, shape, scale, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • shape (float) – the shape parameter of the distribution

  • scale (float) – the scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the gamma distribution.

Return type:

float

Gnm.qgeom(p, psuc, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • psuc (float) – the probability of success in each trial

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the geometric distribution.

Return type:

float

Gnm.qhyper(p, r, b, n, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • r (float) – the number of red balls

  • b (float) – the number of black balls

  • n (float) – the number of balls drawn

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the hypergeometric distribution.

Return type:

float

Gnm.qlnorm(p, logmean, logsd, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • logmean (float) – mean of the underlying normal distribution

  • logsd (float) – standard deviation of the underlying normal distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the log-normal distribution.

Return type:

float

Gnm.qnbinom(p, n, psuc, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • n (float) – the number of trials

  • psuc (float) – the probability of success in each trial

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the negative binomial distribution.

Return type:

float

Gnm.qnorm(p, mu, sigma, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • mu (float) – mean of the distribution

  • sigma (float) – standard deviation of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the normal distribution.

Return type:

float

Gnm.qpois(p, lambda_, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • lambda (float) – the mean of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the Poisson distribution.

Return type:

float

Gnm.qrayleigh(p, scale, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • scale (float) – scale parameter

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, log of the result will be returned instead

Returns:

the observation with cumulative probability p for the Rayleigh distribution.

Return type:

float

Gnm.qt(p, n, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • n (float) – the number of degrees of freedom of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the Student t distribution.

Return type:

float

Gnm.qtukey(p, nmeans, df, nranges, lower_tail, log_p)
Parameters:
Return type:

float

Gnm.qweibull(p, shape, scale, lower_tail, log_p)
Parameters:

  • p (float) – probability

  • shape (float) – the shape parameter of the distribution

  • scale (float) – the scale parameter of the distribution

  • lower_tail (bool) – if True, the lower tail of the distribution is considered.

  • log_p (bool) – if True, p is given as log probability

Returns:

the observation with cumulative probability p for the Weibull distribution.

Return type:

float

Gnm.random_01()
Return type:

float

Gnm.random_bernoulli(p)
Parameters:

p (float) –

Return type:

float

Gnm.random_beta(a, b)
Parameters:
Return type:

float

Gnm.random_binomial(p, trials)
Parameters:
Return type:

float

Gnm.random_cauchy(a)
Parameters:

a (float) –

Return type:

float

Gnm.random_chisq(nu)
Parameters:

nu (float) –

Return type:

float

Gnm.random_exponential(b)
Parameters:

b (float) –

Return type:

float

Gnm.random_exppow(a, b)
Parameters:
Return type:

float

Gnm.random_exppow_pdf(x, a, b)
Parameters:
Return type:

float

Gnm.random_fdist(nu1, nu2)
Parameters:
Return type:

float

Gnm.random_gamma(a, b)
Parameters:
Return type:

float

Gnm.random_gaussian_tail(a, sigma)
Parameters:
Return type:

float

Gnm.random_geometric(p)
Parameters:

p (float) –

Return type:

float

Gnm.random_gumbel1(a, b)
Parameters:
Return type:

float

Gnm.random_gumbel2(a, b)
Parameters:
Return type:

float

Gnm.random_hypergeometric(n1, n2, t)
Parameters:
Return type:

float

Gnm.random_landau()
Return type:

float

Gnm.random_laplace(a)
Parameters:

a (float) –

Return type:

float

Gnm.random_laplace_pdf(x, a)
Parameters:
Return type:

float

Gnm.random_levy(c, alpha)
Parameters:
Return type:

float

Gnm.random_levy_skew(c, alpha, beta)
Parameters:
Return type:

float

Gnm.random_logarithmic(p)
Parameters:

p (float) –

Return type:

float

Gnm.random_logistic(a)
Parameters:

a (float) –

Return type:

float

Gnm.random_lognormal(zeta, sigma)
Parameters:
Return type:

float

Gnm.random_negbinom(p, f)
Parameters:
Return type:

float

Gnm.random_normal()
Returns:

a N(0,1) distributed random number.

Return type:

float

Gnm.random_pareto(a, b)
Parameters:
Return type:

float

Gnm.random_poisson(lambda_)
Parameters:

lambda (float) –

Return type:

float

Gnm.random_rayleigh(sigma)
Parameters:

sigma (float) –

Return type:

float

Gnm.random_rayleigh_tail(a, sigma)
Parameters:
Return type:

float

Gnm.random_skew_normal(a)
Parameters:

a (float) –

Return type:

float

Gnm.random_skew_tdist(nu, a)
Parameters:
Return type:

float

Gnm.random_tdist(nu)
Parameters:

nu (float) –

Return type:

float

Gnm.random_uniform_int(n)
Parameters:

n (int) – one more than the maximum number in range.

Returns:

a uniformly distributed random non-negative integer less than n.

Return type:

int

Gnm.random_uniform_integer(l, h)
Parameters:

  • l (float) – integer lower bound

  • h (float) – integer upper bound

Returns:

a uniformly distributed random integer in the range from l to h (inclusively).

Return type:

float

Gnm.random_weibull(a, b)
Parameters:
Return type:

float

Gnm.range_adtest(xs, n, p, statistics)
Parameters:
Return type:

int

Gnm.range_avedev(xs, n, res)
Parameters:
Return type:

int

Gnm.range_concatenate(data, user)
Parameters:
Returns:

non-zero on error.

Return type:

(int, res: str)

Gnm.range_correl_pop(xs, ys, n, res)
Parameters:
Return type:

int

Gnm.range_count(xs, n, res)
Parameters:
Return type:

int

Gnm.range_covar_est(xs, ys, n, res)
Parameters:
Return type:

int

Gnm.range_covar_pop(xs, ys, n, res)
Parameters:
Return type:

int

Gnm.range_geometric_mean(xs, n, res)
Parameters:
Return type:

int

Gnm.range_harmonic_mean(xs, n, res)
Parameters:
Return type:

int

Gnm.range_hypot(xs, n, res)
Parameters:
Return type:

int

Gnm.range_kurtosis_m3_est(xs, n, res)
Parameters:
Return type:

int

Gnm.range_kurtosis_m3_pop(xs, n, res)
Parameters:
Return type:

int

Gnm.range_list_destroy(ranges)
Parameters:

ranges ([Gnm.Value]) – a list of GOffice.value ranges to destroy.

Destroys a list of ranges returned from parse_cell_range_list. Note: the element type here is Gnm.Value, not Gnm.Range.

Gnm.range_mode(xs, n, res)
Parameters:
Return type:

int

Gnm.range_multinomial(xs, n, res)
Parameters:
Return type:

int

Gnm.range_product(xs, n, res)
Parameters:
Return type:

int

Gnm.range_rsq_pop(xs, ys, n, res)
Parameters:
Return type:

int

Gnm.range_simplify(arr)
Parameters:

arr ([Gnm.Range]) – array of ranges to simplify

Returns:

array of ranges to simplify

Return type:

arr: [Gnm.Range]

Simplifies the array of ranges by merging small ranges into larger ones.

Gnm.range_skew_est(xs, n, res)
Parameters:
Return type:

int

Gnm.range_skew_pop(xs, n, res)
Parameters:
Return type:

int

Gnm.range_stddev_est(xs, n, res)
Parameters:
Return type:

int

Gnm.range_stddev_pop(xs, n, res)
Parameters:
Return type:

int

Gnm.range_var_est(xs, n, res)
Parameters:
Return type:

int

Gnm.range_var_pop(xs, n, res)
Parameters:
Return type:

int

Gnm.reduce_pi(x, e)
Parameters:

  • x (float) – number of reduce

  • e (int) – scale between -1 and 8, inclusive.

Returns:

a GOffice.value, xr, such that x = xr + j * Pi/2^`e` for some integer number j and |xr| <= Pi/2^(e+1). The lower e+1 bits of j will be returned in k.

k:

location to return lower e+1 bits of reduction GOffice.count

Return type:

(float, k: int)

This function performs range reduction for trigonometric functions.

Gnm.regcomp_XL(preg, pattern, cflags, anchor_start, anchor_end)
Parameters:
Return type:

int

Gnm.restore_window_geometry(dialog, key)
Parameters:
Gnm.row_calc_spans(ri, row, sheet)
Parameters:
Gnm.row_destroy_span(ri)
Parameters:

ri (Gnm.ColRowInfo) –

Gnm.row_span_get(ri, col)
Parameters:
Return type:

Gnm.CellSpanInfo

Gnm.rows_height_update(sheet, range, shrink)
Parameters:

  • sheet (Gnm.Sheet) – The sheet,

  • range (Gnm.Range) – The range whose rows should be resized.

  • shrink (bool) – If set to False, rows will never shrink!

Use this function having changed the Gnm.font size to auto-resize the Gnm.row heights to make the text fit nicely.

Gnm.rvc_free(rvc)
Parameters:

rvc (Gnm.RenderedValueCollection) –

Gnm.rvc_remove(rvc, cell)
Parameters:
Gnm.rvc_store(rvc, cell, rv)
Parameters:
Gnm.sc_ant(sc)
Parameters:

sc (Gnm.SheetControl) –

Gnm.sc_cursor_bound(sc, r)
Parameters:
Gnm.sc_freeze_object_view(sc, freeze)
Parameters:
Gnm.sc_make_cell_visible(sc, col, row, couple_panes)
Parameters:
Gnm.sc_mode_edit(sc)
Parameters:

sc (Gnm.SheetControl) –

Gnm.sc_object_create_view(sc, so)
Parameters:
Gnm.sc_recompute_visible_region(sc, full_recompute)
Parameters:
Gnm.sc_redraw_all(sc, headers)
Parameters:
Gnm.sc_redraw_headers(sc, col, row, r)
Parameters:
Gnm.sc_redraw_range(sc, r)
Parameters:
Gnm.sc_resize(sc, force_scroll)
Parameters:
Gnm.sc_scale_changed(sc)
Parameters:

sc (Gnm.SheetControl) –

Gnm.sc_scrollbar_config(sc)
Parameters:

sc (Gnm.SheetControl) –

Gnm.sc_set_panes(sc)
Parameters:

sc (Gnm.SheetControl) –

Gnm.sc_set_top_left(sc, col, row)
Parameters:
Gnm.sc_sheet(sc)
Parameters:

sc (Gnm.SheetControl) – Gnm.SheetControl

Returns:

the sheet.

Return type:

Gnm.Sheet or None

Gnm.sc_show_im_tooltip(sc, im, pos)
Parameters:
Gnm.sc_unant(sc)
Parameters:

sc (Gnm.SheetControl) –

Gnm.sc_view(sc)
Parameters:

sc (Gnm.SheetControl) – Gnm.SheetControl

Returns:

the sheet view.

Return type:

Gnm.SheetView or None

Gnm.sc_wbc(sc)
Parameters:

sc (Gnm.SheetControl) – Gnm.SheetControl

Returns:

the GOffice.workbook control.

Return type:

Gnm.WorkbookControl or None

Gnm.scg_adjust_preferences(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_colrow_distance_get(scg, is_cols, from_, to)
Parameters:
Return type:

int

Gnm.scg_colrow_select(scg, is_cols, index, modifiers)
Parameters:
Return type:

bool

Gnm.scg_colrow_size_set(scg, is_cols, index, new_size_pixels)
Parameters:
Gnm.scg_comment_display(scg, cc, x, y)
Parameters:
Gnm.scg_comment_select(scg, cc, x, y)
Parameters:

Prepare cc for display.

Gnm.scg_comment_unselect(scg, cc)
Parameters:

If cc is the current cell Gnm.comment being edited/displayed shutdown the display mechanism.

Gnm.scg_context_menu(scg, event, is_col, is_row)
Parameters:
Gnm.scg_cursor_extend(scg, n, jump_to_bound, horiz)
Parameters:

  • scg (Gnm.SheetControlGUI) – The scg

  • n (int) – Units to extend the selection

  • jump_to_bound (bool) – Move to transitions between cells and blanks, or move in single steps.

  • horiz (bool) – extend vertically or horizontally.

Gnm.scg_cursor_move(scg, dir, jump_to_bound, horiz)
Parameters:

  • scg (Gnm.SheetControlGUI) – The scg

  • dir (int) – Number of units to move the Gnm.cursor

  • jump_to_bound (bool) – skip from the start to the end of ranges of filled or unfilled cells.

  • horiz (bool) – is the movement horizontal or vertical

Moves the Gnm.cursor GOffice.count rows

Gnm.scg_cursor_visible(scg, is_visible)
Parameters:
Gnm.scg_delete_sheet_if_possible(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_drag_data_get(scg, selection_data)
Parameters:
Gnm.scg_drag_data_received(scg, source_widget, x, y, selection_data)
Parameters:
Gnm.scg_edit_start(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_edit_stop(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_make_cell_visible(scg, col, row, force_scroll, couple_panes)
Parameters:

  • scg (Gnm.SheetControlGUI) – The gui control

  • col (int) –

  • row (int) –

  • force_scroll (bool) – Completely recalibrate the offsets to the new position

  • couple_panes (bool) – Scroll scroll dynamic panes back to bounds if target is in frozen segment.

Ensure that cell (Gnm.col, Gnm.row) is visible. Gnm.Sheet is scrolled if cell is outside viewport.

Gnm.scg_mode_edit(scg)
Parameters:

scg (Gnm.SheetControlGUI) – The sheet control

Put sheet into the standard state ‘edit mode’. This shuts down any object editing and frees any objects that are created but not realized.

Gnm.scg_object_anchor_to_coords(scg, anchor, coords)
Parameters:
Gnm.scg_object_coords_to_anchor(scg, coords, in_out)
Parameters:
Gnm.scg_object_select(scg, so)
Parameters:

Adds so to the set of selected objects and prepares it for user editing. Adds a reference to ref if it is selected.

Gnm.scg_object_select_next(scg, reverse)
Parameters:
Gnm.scg_object_unselect(scg, so)
Parameters:

unselect the supplied object, and drop out of edit mode if this is the last one. If so == None unselect _all_ objects.

Gnm.scg_objects_drag(scg, gcanvas, primary, dx, dy, drag_type, symmetric, snap_to_grid, is_mouse_move)
Parameters:

Move the control points and Gnm.drag views of the currently selected objects to a new position. This movement is only made in scg not in the actual objects.

Gnm.scg_objects_drag_commit(scg, drag_type, created_objects, pundo, predo, undo_title)
Parameters:
Gnm.scg_objects_nudge(scg, gcanvas, drag_type, dx, dy, symmetric, snap_to_grid)
Parameters:
Gnm.scg_pane(scg, pane)
Parameters:
Returns:

the pane.

Return type:

Gnm.Pane

Gnm.scg_paste_image(scg, where, data, len)
Parameters:
Gnm.scg_queue_movement(scg, handler, n, jump, horiz)
Parameters:

Do motion compression when possible to avoid redrawing an area that will disappear when we scroll again.

Gnm.scg_rangesel_bound(scg, base_col, base_row, move_col, move_row)
Parameters:
Gnm.scg_rangesel_extend(scg, n, jump_to_bound, horiz)
Parameters:
Gnm.scg_rangesel_extend_to(scg, col, row)
Parameters:
Gnm.scg_rangesel_move(scg, dir, jump_to_bound, horiz)
Parameters:
Gnm.scg_rangesel_start(scg, base_col, base_row, move_col, move_row)
Parameters:
Gnm.scg_rangesel_stop(scg, clear_str)
Parameters:
Gnm.scg_reload_item_edits(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_select_all(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_set_display_cursor(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Set the displayed Gnm.cursor type.

Gnm.scg_set_left_col(scg, new_first_col)
Parameters:
Gnm.scg_set_top_row(scg, new_first_row)
Parameters:
Gnm.scg_sheet(scg)
Parameters:

scg (Gnm.SheetControlGUI) – Gnm.SheetControlGUI

Returns:

the sheet.

Return type:

Gnm.Sheet

Gnm.scg_size_guide_motion(scg, vert, guide_pos)
Parameters:
Gnm.scg_size_guide_start(scg, vert, colrow, is_colrow_resize)
Parameters:
Gnm.scg_size_guide_stop(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_special_cursor_bound_set(scg, r)
Parameters:
Return type:

bool

Gnm.scg_special_cursor_start(scg, style, button)
Parameters:
Gnm.scg_special_cursor_stop(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_take_focus(scg)
Parameters:

scg (Gnm.SheetControlGUI) –

Gnm.scg_view(scg)
Parameters:

scg (Gnm.SheetControlGUI) – Gnm.SheetControlGUI

Returns:

the sheet view.

Return type:

Gnm.SheetView

Gnm.scg_wbc(scg)
Parameters:

scg (Gnm.SheetControlGUI) – Gnm.SheetControlGUI

Returns:

the GOffice.workbook control.

Return type:

Gnm.WorkbookControl

Gnm.scg_wbcg(scg)
Parameters:

scg (Gnm.SheetControlGUI) – Gnm.SheetControlGUI

Returns:

the Gnm.WBCGtk.

Return type:

Gnm.WBCGtk

Gnm.search_collect_cells(sr)
Parameters:

sr (Gnm.SearchReplace) – Gnm.SearchReplace

Returns:

the newly created array.

Return type:

[Gnm.EvalPos]

Collect a list of all cells subject to search.

Gnm.search_collect_cells_free(cells)
Parameters:

cells ([Gnm.EvalPos]) –

Gnm.search_filter_matching(sr, cells)
Parameters:
Returns:

matches

Return type:

[Gnm.SearchFilterResult]

Gnm.search_filter_matching_free(matches)
Parameters:

matches ([Gnm.SearchFilterResult]) – matches

Gnm.search_normalize(txt)
Parameters:

txt (str) –

Return type:

str

Gnm.selection_first_range(sv, cc, cmd_name)
Parameters:
Returns:

the first range, if a control is supplied it displays an error if there is more than one range.

Return type:

Gnm.Range

Gnm.selection_get_ranges(sv, allow_intersection)
Parameters:
Return type:

[Gnm.Range]

Caller is responsible for free the list and the content.

Gnm.selection_to_string(sv, include_sheet_name_prefix)
Parameters:
Return type:

str

Gnm.set_cell_text_col(dao, col, row, text)
Parameters:
Gnm.set_cell_text_row(dao, col, row, text)
Parameters:
Gnm.set_uifilename(name, actions, nb)
Parameters:
Gnm.sheet_range_set_text(pos, r, str)
Parameters:

  • pos (Gnm.ParsePos) – The position from which to parse an expression.

  • r (Gnm.Range) – The range to GOffice.fill

  • str (str) – The text to be parsed and assigned.

Does NOT check for array division. Does NOT redraw Does NOT generate spans.

Gnm.shortest_rep_in_files()
Return type:

bool

Gnm.shutdown()
Gnm.simulation_tool(wbc, dao, sim)
Parameters:
Return type:

str

Gnm.simulation_tool_destroy(sim)
Parameters:

sim (Gnm.simulation_t) –

Gnm.slist_sort_merge(list_1, list_2)
Parameters:

  • list_1 ([int]) – a sorted list of unsigned integers with no duplicates.

  • list_2 ([int]) – another one

Returns:

the mergedlist.

Return type:

[int]

Gnm.slist_sort_merge merges two lists of unsigned integers.

Gnm.sort_contents(data, cc)
Parameters:
Return type:

int

Gnm.sort_permute_invert(perm, length)
Parameters:

  • perm (int) –

  • length (int) –

Return type:

int

Gnm.sort_position(data, perm, cc)
Parameters:
Gnm.stf_dialog_csv_page_cleanup(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) – mother struct

Will cleanup csv page run-time data

Gnm.stf_dialog_csv_page_init(gui, pagedata)
Parameters:
Gnm.stf_dialog_csv_page_prepare(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) – mother struct

Will prepare the csv page

Gnm.stf_dialog_fixed_page_cleanup(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) – mother struct

Will cleanup fixed page run-time data

Gnm.stf_dialog_fixed_page_init(gui, pagedata)
Parameters:
Gnm.stf_dialog_fixed_page_prepare(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) – mother struct

Will prepare the fixed page

Gnm.stf_dialog_format_page_cleanup(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) –

Gnm.stf_dialog_format_page_init(gui, pagedata)
Parameters:
Gnm.stf_dialog_format_page_prepare(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) – mother struct

This will prepare the widgets on the format page before the page gets displayed

Gnm.stf_dialog_main_page_cleanup(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) –

Gnm.stf_dialog_main_page_init(gui, pagedata)
Parameters:
Gnm.stf_dialog_main_page_prepare(pagedata)
Parameters:

pagedata (Gnm.StfDialogData) – mother struct

This will prepare the widgets on the format page before the page gets displayed

Gnm.stf_dialog_result_attach_formats_to_cr(dialogresult, cr)
Parameters:

Attach the formats of the dialogresult to the given cell region.

Gnm.stf_dialog_result_free(dialogresult)
Parameters:

dialogresult (Gnm.DialogStfResult_t) – a dialogresult struct

This routine will properly free the members of dialogresult and dialogresult itself

Gnm.stf_export(export_options)
Parameters:

export_options (Gnm.StfExport) – an export options struct

Returns:

True on success, False otherwise

Return type:

bool

Exports the sheets given in stfe

Gnm.stf_file_saver_create(id)
Parameters:

id (str) –

Returns:

the newly allocated GOffice.FileSaver.

Return type:

GOffice.FileSaver

Gnm.stf_get_stfe(obj)
Parameters:

obj (GObject.Object) – GObject.Object with a Gnm.StfExport attached as data.

Returns:

the Gnm.StfExport.

Return type:

Gnm.StfExport

If none is found, a new one is created and attached to obj.

Gnm.stf_parse_find_line(parseoptions, data, line)
Parameters:
Return type:

str

Gnm.stf_parse_options_guess(data)
Parameters:

data (str) – the input data.

Returns:

the guessed options.

Return type:

Gnm.StfParseOptions_t

Gnm.stf_parse_options_guess_csv(data)
Parameters:

data (str) – the CSV input data.

Returns:

the guessed options.

Return type:

Gnm.StfParseOptions_t

Gnm.stf_parse_region(parseoptions, data, data_end, wb)
Parameters:
Return type:

Gnm.CellRegion

Gnm.stf_parse_sheet(parseoptions, data, data_end, sheet, start_col, start_row)
Parameters:
Return type:

bool

Gnm.stf_preview_find_column(renderdata, x, pcol, dx)
Parameters:
Gnm.stf_text_to_columns(wbc, cc)
Parameters:

Main routine, handles importing a file including all dialog mumbo-jumbo

Gnm.stirlerr(n)
Parameters:

n (float) –

Return type:

float

Gnm.string_add_number(buf, d)
Parameters:
Gnm.strip_missing(data, missing)
Parameters:

  • data ([float]) – Array

  • missing ([int]) – indices of elements to remove in increasing order.

Returns:

Array

Return type:

data: [float]

This removes the data elements from data whose indices are given by missing. n is the number of elements and it updated upon return.

Gnm.style_border_fetch(line_type, color, orientation)
Parameters:
Returns:

A Gnm.Border

Return type:

Gnm.Border

Gnm.style_border_get_orientation(type)
Parameters:

type (Gnm.StyleBorderLocation) –

Return type:

Gnm.StyleBorderOrientation

Gnm.style_border_get_width(line_type)
Parameters:

line_type (Gnm.StyleBorderType) –

Return type:

int

Gnm.style_border_none()
Returns:

A Gnm.Border with no borders.

Return type:

Gnm.Border

Gnm.style_border_none_set_color(color)
Parameters:

color (Gnm.Color) – Gnm.Color

This function updates the color of Gnm.Style.border_none when the wanted grid color is known. Gnm.Style.border_none tells how to render the grid. Because the grid color may be different for different sheets, the functions which render the grid call this function first. The rule for selecting the grid color, which is the same as in Excel, is: - if the auto pattern color is default (which is black), the grid color is gray, as returned by Gnm.Style.color_grid (). - otherwise, the auto pattern color is used for the grid.

Gnm.style_border_ref(border)
Parameters:

border (Gnm.Border or None) – Gnm.Border

Returns:

a reference to border

Return type:

Gnm.Border or None

Gnm.style_border_set_dash(i, context)
Parameters:
Gnm.style_border_unref(border)
Parameters:

border (Gnm.Border or None) – Gnm.Border

Gnm.style_border_visible_in_blank(border)
Parameters:

border (Gnm.Border) –

Return type:

bool

Gnm.style_borders_row_draw(prev_vert, sr, cr, x, y1, y2, colwidths, draw_vertical, dir)
Parameters:

TODO : This is not the final resting place for this. It will move into the gui layer eventually.

Gnm.style_borders_row_print_gtk(prev_vert, sr, context, x, y1, y2, sheet, draw_vertical, dir)
Parameters:
Gnm.style_color_auto_back()
Return type:

Gnm.Color

Always white, as far as we know.

Gnm.style_color_auto_font()
Return type:

Gnm.Color

Always black, as far as we know.

Gnm.style_color_auto_pattern()
Return type:

Gnm.Color

Normally black, but follows grid color if so told.

Gnm.style_color_black()
Return type:

Gnm.Color

Gnm.style_color_equal(a, b)
Parameters:
Return type:

int

Gnm.style_color_grid(context)
Parameters:

context (Gtk.StyleContext) –

Return type:

Gnm.Color

Gnm.style_color_ref(sc)
Parameters:

sc (Gnm.Color) –

Return type:

Gnm.Color

Gnm.style_color_unref(sc)
Parameters:

sc (Gnm.Color) –

Gnm.style_color_white()
Return type:

Gnm.Color

Gnm.style_context_get_color(context, state, color)
Parameters:
Gnm.style_hash(style)
Parameters:

style (object or None) –

Return type:

int

Gnm.style_hash_XL(style)
Parameters:

style (object or None) –

Return type:

int

Gnm.style_list_free(l)
Parameters:

l ([object]) – the list to free

Free up the resources in the style list. This includes unreferencing the styles.

Gnm.style_list_get_style(l, col, row)
Parameters:

  • l ([object]) – A style list.

  • col (int) – Column number

  • row (int) – Row number

Returns:

The style found.

Return type:

Gnm.Style or None

Attempts to find the style associated with the pos offset within the 0,0 based style list.

Gnm.style_row_init(prev_vert, sr, next_sr, start_col, end_col, mem, hide_grid)
Parameters:

A small utility routine to initialize the grid drawing Gnm.StyleRow data structure.

Gnm.sv_is_colrow_selected(sv, colrow, is_col)
Parameters:
Return type:

bool

Gnm.sv_is_full_colrow_selected(sv, is_cols, index)
Parameters:
Returns:

True if all of the selected cols/rows in the selection are fully selected and the selection contains the specified Gnm.col.

Return type:

bool

Gnm.sv_is_full_range_selected(sv, r)
Parameters:
Returns:

True if all of r is contained by the selection in sv.

Return type:

bool

Gnm.sv_is_pos_selected(sv, col, row)
Parameters:
Returns:

True if the supplied position is selected in view sv.

Return type:

bool

Gnm.sv_is_range_selected(sv, r)
Parameters:
Returns:

True If r overlaps with any part of the selection in sv.

Return type:

bool

Gnm.sv_is_singleton_selected(sv)
Parameters:

sv (Gnm.SheetView) – Gnm.SheetView

Returns:

A Gnm.CellPos if the selection is a singleton

Return type:

Gnm.CellPos or None

See if the 1st selected region is a singleton.

Gnm.sv_select_cur_array(sv)
Parameters:

sv (Gnm.SheetView) – The sheet view

If the editpos is part of an array clear the selection and select the array.

Gnm.sv_select_cur_col(sv)
Parameters:

sv (Gnm.SheetView) – The sheet view

Selects an entire column

Gnm.sv_select_cur_depends(sv)
Parameters:

sv (Gnm.SheetView) – The sheet view

Select all cells that depend on the expression in the current cell.

Gnm.sv_select_cur_inputs(sv)
Parameters:

sv (Gnm.SheetView) – The sheet view

Select all cells that are direct potential inputs to the current cell.

Gnm.sv_select_cur_row(sv)
Parameters:

sv (Gnm.SheetView) – The sheet view

Selects an entire Gnm.row

Gnm.sv_selection_add_full(sv, edit_col, edit_row, base_col, base_row, move_col, move_row, mode)
Parameters:

  • sv (Gnm.SheetView) – Gnm.SheetView whose selection is append to.

  • edit_col (int) –

  • edit_row (int) – cell to mark as the new edit Gnm.cursor.

  • base_col (int) –

  • base_row (int) – stationary corner of the newly selected range.

  • move_col (int) –

  • move_row (int) – moving corner of the newly selected range.

  • mode (Gnm.SelectionMode) –

Prepends a range to the selection list and sets the edit position.

Gnm.sv_selection_add_pos(sv, col, row, mode)
Parameters:
Gnm.sv_selection_add_range(sv, range)
Parameters:
Gnm.sv_selection_apply(sv, func, allow_intersection, *user_data)
Parameters:

Applies the specified function for all ranges in the selection. Optionally select whether to use the high level potentially over lapped ranges, rather than the smaller system created non-intersection regions.

Gnm.sv_selection_col_type(sv, col)
Parameters:
Returns:

How much of column col is selected in sv.

Return type:

Gnm.ColRowSelectionType

Gnm.sv_selection_extend_to(sv, col, row)
Parameters:

  • sv (Gnm.SheetView) – the sheet

  • col (int) – column that gets covered (negative indicates all cols)

  • row (int) – Gnm.row that gets covered (negative indicates all rows)

This extends the selection to cover Gnm.col, Gnm.row and updates the status areas.

Gnm.sv_selection_foreach(sv, handler, *user_data)
Parameters:
Return type:

bool

Iterate through the ranges in a selection. NOTE : The function assumes that the callback routine does NOT change the selection list. This can be changed in the future if it is a requirement.

Gnm.sv_selection_free(sv)
Parameters:

sv (Gnm.SheetView) – Gnm.SheetView

Releases the selection associated with sv

WARNING: This does not set a new selection and leaves the view in an INVALID STATE.

Gnm.sv_selection_reset(sv)
Parameters:

sv (Gnm.SheetView) – The sheet view

Releases the selection associated with sv , and forces a redraw of the previously selected regions and headers.

WARNING: This does not set a new selection and leaves the view in an INVALID STATE.

Gnm.sv_selection_row_type(sv, row)
Parameters:
Returns:

How much of column col is selected in sv.

Return type:

Gnm.ColRowSelectionType

Gnm.sv_selection_set(sv, edit, base_col, base_row, move_col, move_row)
Parameters:
Gnm.sv_selection_simplified_free(sv)
Parameters:

sv (Gnm.SheetView) – Gnm.SheetView

Releases the simplified selection associated with sv

Gnm.sv_selection_simplify(sv)
Parameters:

sv (Gnm.SheetView) –

Gnm.sv_selection_to_plot(sv, plot)
Parameters:
Gnm.sv_selection_walk_step(sv, forward, horizontal)
Parameters:

Move the edit_pos of sv 1 step according to forward and horizontal. The behavior depends several factors

  • How many ranges are selected

  • The shape of the selected ranges

  • Previous movements (A sequence of tabs followed by an enter can jump to the 1st Gnm.col).

Gnm.sv_sheet(sv)
Parameters:

sv (Gnm.SheetView) – Gnm.SheetView

Returns:

the sheet.

Return type:

Gnm.Sheet

Gnm.sv_wbv(sv)
Parameters:

sv (Gnm.SheetView) – Gnm.SheetView

Returns:

the GOffice.workbook view.

Return type:

Gnm.WorkbookView

Gnm.swap_log_tail(lp)
Parameters:

lp (float) –

Return type:

float

Gnm.sys_data_dir()
Return type:

str

Gnm.sys_extern_plugin_dir()
Return type:

str

Gnm.sys_lib_dir()
Return type:

str

Gnm.taylor_log1p(x, k)
Parameters:

  • x (float) – a number

  • k (int) – starting term.

Returns:

The taylor series for log(1+`x`), except that terms before the k'th are discarded.

Return type:

float

Gnm.textbuffer_get_text(buf)
Parameters:

buf (Gtk.TextBuffer) –

Return type:

str

Gnm.textview_get_text(text_view)
Parameters:

text_view (Gtk.TextView) –

Return type:

str

Gnm.textview_set_text(text_view, txt)
Parameters:
Gnm.theme_is_dark(widget)
Parameters:

widget (Gtk.Widget) –

Return type:

bool

Gnm.tool_consolidate_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.tool_load_selection(state, allow_multiple)
Parameters:

load the current selection in the output and input entries show the dialog and focus the input_entry

Gnm.tool_random_cor_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.tool_random_engine(gcc, dao, specs, selector, result)
Parameters:
Return type:

bool

Gnm.translate_underline_from_pango(pul)
Parameters:

pul (Pango.Underline) –

Return type:

Gnm.Underline

Gnm.translate_underline_to_pango(ul)
Parameters:

ul (Gnm.Underline) –

Return type:

Pango.Underline

Gnm.undo_cell_pos_name(sheet, pos)
Parameters:
Return type:

str

Returns the range name depending on the preference setting.

Gnm.undo_range_list_name(sheet, ranges)
Parameters:
Returns:

the range list name depending on the preference setting. (The result will be something like: “A1:C3, D4:E5”). The string will be truncated to max_descriptor_width.

Return type:

str

Gnm.undo_range_name(sheet, r)
Parameters:
Return type:

str

Returns the range name depending on the preference setting.

Gnm.unit_name_to_unit(name)
Parameters:

name (str) –

Return type:

Gtk.Unit

Gnm.unit_to_unit_name(unit)
Parameters:

unit (Gtk.Unit) –

Return type:

str

Gnm.usr_dir(versioned)
Parameters:

versioned (bool) –

Return type:

str

Gnm.utf8_strto(s, end)
Parameters:
Return type:

float

Gnm.utf8_strtol(s, end)
Parameters:
Return type:

int

Gnm.validation_eval(wbc, mstyle, sheet, pos)
Parameters:
Return type:

(Gnm.ValidationStatus, showed_dialog: bool)

Checks the validation in mstyle, if any. Set showed_dialog to True if a dialog was showed as a result.

Gnm.validation_eval_range(wbc, sheet, pos, r, showed_dialog)
Parameters:
Return type:

Gnm.ValidationStatus

Gnm.value_cmp(ptr_a, ptr_b)
Parameters:
Return type:

int

qsort style comparison function for ascending order

Gnm.value_cmp_reverse(ptr_a, ptr_b)
Parameters:
Return type:

int

qsort style comparison function for descending order.

Gnm.value_error_name(err, translated)
Parameters:
Returns:

the name of err, possibly localized.

Return type:

str

Gnm.value_error_set_pos(err, pos)
Parameters:
Returns:

err as a Gnm.Value.

Return type:

Gnm.Value

Change the position of a ValueError.

Gnm.wb_control_claim_selection(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Return type:

bool

Gnm.wb_control_cur_sheet(wbc)
Parameters:

wbc (Gnm.WorkbookControl) – Gnm.WorkbookControl

Returns:

the current sheet.

Return type:

Gnm.Sheet

Gnm.wb_control_cur_sheet_view(wbc)
Parameters:

wbc (Gnm.WorkbookControl) – Gnm.WorkbookControl

Returns:

the current sheet view.

Return type:

Gnm.SheetView

Gnm.wb_control_edit_line_set(wbc, text)
Parameters:
Gnm.wb_control_get_doc(wbc)
Parameters:

wbc (Gnm.WorkbookControl) – Gnm.WorkbookControl

Returns:

the GOffice.workbook set as a GOffice.Doc.

Return type:

GOffice.Doc

Gnm.wb_control_get_workbook(wbc)
Parameters:

wbc (Gnm.WorkbookControl) – Gnm.WorkbookControl

Returns:

the GOffice.workbook.

Return type:

Gnm.Workbook

Gnm.wb_control_init_state(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Gnm.wb_control_jump(wbc, sheet, r)
Parameters:
Return type:

bool

Gnm.wb_control_menu_state_update(wbc, flags)
Parameters:
Gnm.wb_control_navigate_to_cell(wbc, to)
Parameters:
Gnm.wb_control_parse_and_jump(wbc, text)
Parameters:
Return type:

bool

Gnm.wb_control_paste_from_selection(wbc, pt)
Parameters:
Gnm.wb_control_selection_descr_set(wbc, text)
Parameters:
Gnm.wb_control_set_view(wbc, optional_view, optional_wb)
Parameters:
Gnm.wb_control_sheet_add(wbc, sv)
Parameters:
Gnm.wb_control_sheet_focus(wbc, sheet)
Parameters:
Gnm.wb_control_sheet_remove(wbc, sheet)
Parameters:
Gnm.wb_control_sheet_remove_all(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Gnm.wb_control_style_feedback(wbc, changes)
Parameters:
Gnm.wb_control_undo_redo_labels(wbc, undo, redo)
Parameters:
Gnm.wb_control_undo_redo_pop(wbc, is_undo)
Parameters:
Gnm.wb_control_undo_redo_push(wbc, is_undo, text, key)
Parameters:
Gnm.wb_control_undo_redo_truncate(wbc, n, is_undo)
Parameters:
Gnm.wb_control_update_action_sensitivity(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Gnm.wb_control_validation_msg(wbc, v, title, msg)
Parameters:
Return type:

int

1 : ignore invalid and accept result 0 : discard invalid and finish editing -1 : continue editing

Gnm.wb_control_view(wbc)
Parameters:

wbc (Gnm.WorkbookControl) – Gnm.WorkbookControl

Returns:

the GOffice.workbook view.

Return type:

Gnm.WorkbookView

Gnm.wb_view_attach_control(wbv, wbc)
Parameters:
Gnm.wb_view_auto_expr_recalc(wbv)
Parameters:

wbv (Gnm.WorkbookView) –

Gnm.wb_view_cur_sheet(wbv)
Parameters:

wbv (Gnm.WorkbookView) – Gnm.WorkbookView

Returns:

the current sheet.

Return type:

Gnm.Sheet

Gnm.wb_view_cur_sheet_view(wbv)
Parameters:

wbv (Gnm.WorkbookView) – Gnm.WorkbookView

Returns:

the current sheet view.

Return type:

Gnm.SheetView

Gnm.wb_view_detach_control(wbc)
Parameters:

wbc (Gnm.WorkbookControl) –

Gnm.wb_view_detach_from_workbook(wbv)
Parameters:

wbv (Gnm.WorkbookView) –

Gnm.wb_view_edit_line_set(wbv, wbc)
Parameters:

Load the edit line with the GOffice.value of the cell in sheet's edit_pos.

Calculate what to display on the edit line then display it either in the control wbc, or if that is None, in all controls.

Gnm.wb_view_get_doc(wbv)
Parameters:

wbv (Gnm.WorkbookView) – Gnm.WorkbookView

Returns:

the Gnm.Workbook associated with wbv cast to a GOffice.Doc

Return type:

GOffice.Doc

Gnm.wb_view_get_index_in_wb(wbv)
Parameters:

wbv (Gnm.WorkbookView) – Gnm.WorkbookView

Return type:

int

Returns 0 based index of wbv within GOffice.workbook, or -1 if there is no GOffice.workbook.

Gnm.wb_view_get_workbook(wbv)
Parameters:

wbv (Gnm.WorkbookView) – Gnm.WorkbookView

Returns:

the Gnm.Workbook associated with wbv

Return type:

Gnm.Workbook

Gnm.wb_view_is_protected(wbv, check_sheet)
Parameters:
Return type:

bool

Gnm.wb_view_menus_update(wbv)
Parameters:

wbv (Gnm.WorkbookView) –

Gnm.wb_view_preferred_size(wbv, w_pixels, h_pixels)
Parameters:
Gnm.wb_view_selection_desc(wbv, use_pos, wbc)
Parameters:

Load the edit line with the GOffice.value of the cell in sheet’s edit_pos.

Calculate what to display on the edit line then display it either in the control wbc, or if that is None, in all controls.

Gnm.wb_view_set_attribute(wbv, name, value)
Parameters:
Gnm.wb_view_sheet_add(wbv, new_sheet)
Parameters:
Gnm.wb_view_sheet_focus(wbv, sheet)
Parameters:
Gnm.wb_view_style_feedback(wbv)
Parameters:

wbv (Gnm.WorkbookView) –

Gnm.wbcg_append_sheet(ignored, wbcg)
Parameters:
Gnm.wbcg_auto_complete_destroy(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.wbcg_clone_sheet(ignored, wbcg)
Parameters:
Gnm.wbcg_copy_toolbar_visibility(new_wbcg, wbcg)
Parameters:
Gnm.wbcg_cur_scg(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

the current Gnm.SheetControlGUI.

Return type:

Gnm.SheetControlGUI

Gnm.wbcg_cur_sheet(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

the current Gnm.Sheet.

Return type:

Gnm.Sheet

Gnm.wbcg_edit_add_markup(wbcg, attr)
Parameters:

Absorbs the ref to attr.

Gnm.wbcg_edit_finish(wbcg, result)
Parameters:
Returns:

True if editing completed successfully, or we were no editing.

showed_dialog:

indicates whether a dialog was displayed.

Return type:

(bool, showed_dialog: bool)

Gnm.wbcg_edit_get_display_text(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Return type:

str

Gnm.wbcg_edit_get_markup(wbcg, full)
Parameters:
Returns:

a potentially None Pango.AttrList of the current markup while editing. The list belongs to wbcg and should not be freed.

Return type:

Pango.AttrList

Gnm.wbcg_edit_start(wbcg, blankp, cursorp)
Parameters:

  • wbcg (Gnm.WBCGtk) – The GOffice.workbook to be edited.

  • blankp (bool) – If true, erase current cell contents first. If false, leave the contents alone.

  • cursorp (bool) – If true, create an editing Gnm.cursor in the current sheet. (If false, the text will be editing in the edit box above the sheet, but this is not handled by this function.)

Returns:

True if we did indeed start editing. Returns False if the cell-to-be-edited was locked.

Return type:

bool

Initiate editing of a cell in the sheet. Note that we have two modes of editing: 1) in-cell editing when you just start typing, and 2) above sheet editing when you hit F2.

Gnm.wbcg_entry_has_logical(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

True if Gnm.wbcg_set_entry has redirected the edit_entry.

Return type:

bool

Gnm.wbcg_find_action(wbcg, name)
Parameters:

  • wbcg (Gnm.WBCGtk) – the GOffice.workbook control gui

  • name (str) – name of action

Returns:

The action with the given name

Return type:

Gtk.Action

Gnm.wbcg_find_for_workbook(wb, candidate, pref_screen, pref_display)
Parameters:
Returns:

the found Gnm.WBCGtk or None.

Return type:

Gnm.WBCGtk

Gnm.wbcg_focus_cur_scg(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – The GOffice.workbook control to operate on.

Returns:

the sheet.

Return type:

Gnm.Sheet

A utility routine to safely ensure that the keyboard focus is attached to the item-grid. This is required when a user edits a combo-box or and entry-line which grab focus.

It is called for zoom, Gnm.font name/size, and accept/cancel for the editline.

Gnm.wbcg_focus_current_cell_indicator(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Gnm.wbcg_font_action_set_font_desc(act, desc)
Parameters:
Gnm.wbcg_get_entry(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

the Gtk.Entry associated with the current Gnm.ExprEntry

Return type:

Gtk.Entry

Gnm.wbcg_get_entry_logical(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

the logical (allowing redirection via Gnm.wbcg_set_entry for gurus) Gnm.ExprEntry

Return type:

Gnm.ExprEntry

Gnm.wbcg_get_entry_underlying(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

the Gtk.Entry associated with the logical Gnm.ExprEntry.

Return type:

Gtk.Widget

Gnm.wbcg_get_font_desc(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Return type:

Pango.FontDescription

Gnm.wbcg_get_n_scg(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Return type:

int

Gnm.wbcg_get_nth_scg(wbcg, i)
Parameters:
Returns:

the scg associated with the i-th tab in wbcg's notebook. NOTE : i != scg->sv->sheet->index_in_wb

Return type:

Gnm.SheetControlGUI

Gnm.wbcg_insert_object(wbcg, so)
Parameters:

Takes a newly created Gnm.SheetObject that has not yet been realized and prepares to place it on the sheet.

NOTE : Absorbs a reference to the object.

Gnm.wbcg_insert_object_clear(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

If we are preparing to insert a new object, unref the object, and restore a normal state to the scgs that was changed in Gnm.wbcg_insert_object (e.g., visibility of cursors)

Gnm.wbcg_insert_sheet(ignored, wbcg)
Parameters:
Gnm.wbcg_is_editing(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) –

Return type:

bool

Gnm.wbcg_rangesel_possible(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – the GOffice.workbook control gui

Return type:

bool

Returns true if the Gnm.cursor keys should be used to select a cell range (if the Gnm.cursor is in a spot in the expression where it makes sense to have a cell reference), false if not.

Gnm.wbcg_set_end_mode(wbcg, flag)
Parameters:
Gnm.wbcg_set_entry(wbc, new_entry)
Parameters:
Gnm.wbcg_set_status_text(wbcg, text)
Parameters:
Gnm.wbcg_set_transient(wbcg, window)
Parameters:
Gnm.wbcg_toggle_visibility(wbcg, action)
Parameters:
Gnm.wbcg_toplevel(wbcg)
Parameters:

wbcg (Gnm.WBCGtk) – Gnm.WBCGtk

Returns:

the toplevel Gtk.Window.

Return type:

Gtk.Window

Gnm.widget_measure_string(w, s)
Parameters:
Return type:

int

Gnm.widget_set_cursor(w, ct)
Parameters:
Gnm.widget_set_cursor_type(w, ct)
Parameters:
Gnm.x_claim_clipboard(display)
Parameters:

display (Gdk.Display) –

Return type:

bool

Gnm.x_disown_clipboard()
Gnm.x_request_clipboard(wbcg, pt)
Parameters:
Gnm.x_store_clipboard_if_needed(wb)
Parameters:

wb (Gnm.Workbook) –

Gnm.xml_attr_bool(attrs, name, res)
Parameters:
Return type:

bool

Gnm.xml_attr_double(attrs, name, res)
Parameters:
Return type:

bool

Gnm.xml_attr_int(attrs, name, res)
Parameters:
Return type:

bool

Gnm.xml_cellregion_read(wbc, io_context, sheet, buffer, length)
Parameters:
Return type:

Gnm.CellRegion

Gnm.xml_in_cur_obj(xin)
Parameters:

xin (Gsf.XMLIn) – Gsf.XMLIn

Returns:

the current sheet object.

Return type:

Gnm.SheetObject

Gnm.xml_in_cur_sheet(xin)
Parameters:

xin (Gsf.XMLIn) – Gsf.XMLIn

Returns:

the current sheet.

Return type:

Gnm.Sheet

Gnm.xml_in_doc_dispose_on_exit(pdoc)
Parameters:

pdoc (Gsf.XMLInDoc) –

Gnm.xml_io_conventions()
Return type:

Gnm.Conventions

Gnm.xml_out_add_gocolor(o, id, c)
Parameters:
Gnm.xml_out_end_element_check(xout, id)
Parameters:

Closes an xml tag, expected it to be id. If it is not, tags will continue to be closed until the expected one is found in the hope that getting back to sync will make the result less corrupted.

Gnm.xml_prep_style_parser(xin, attrs, handler, user)
Parameters:
Gnm.xml_sax_read_init()
Gnm.xml_sax_read_shutdown()
Gnm.xml_sax_write_init()
Gnm.xml_sax_write_shutdown()
Gnm.yearfrac(from_, to, basis)
Parameters:
Return type:

float