Creating a pivot table usually consists of the following steps:
1. Create the table with pivot_table_create(), passing in the title.
- It's commonly useful to set up a few options at this point:
- - If empty rows or columns should not be displayed, set ->omit_empty to
- true.
+ 2. Optionally, set the format to use for "count" values with
+ pivot_table_set_weight_var() or pivot_table_set_weight_format().
- - Set the format to use for "count" values with
- pivot_table_set_weight_var() or pivot_table_set_weight_format().
-
- 2. Create each dimension with pivot_dimension_create() and populate it with
+ 3. Create each dimension with pivot_dimension_create() and populate it with
categories and, possibly, with groups that contain the categories. This
call also assigns the dimension to an axis.
first cell for that variable. In that case, creating categories and
inserting data can be interleaved.
- 3. Insert data. For each cell, supply the category indexes, which are
+ 4. Insert data. For each cell, supply the category indexes, which are
assigned starting from 0 in the order in which the categories were
created in step 2, and the value to go in the cell. If the table has a
small, fixed number of dimensions, functions like, e.g.
pivot_table_put3() for 3 dimensions, can be used. The general function
pivot_table_put() works for other cases.
- 4. Output the table for user consumption. Use pivot_table_submit(). */
+ 5. Output the table for user consumption. Use pivot_table_submit(). */
\f
/* Pivot table display styling. */
#define PIVOT_RC_COUNT ("RC_COUNT")
bool pivot_result_class_change (const char *, const struct fmt_spec *);
+bool is_pivot_result_class (const char *);
\f
/* Styling for a pivot table.
bool show_grid_lines;
bool show_title;
bool show_caption;
- size_t *current_layer; /* axis[PIVOT_AXIS_LAYER].n_dimensions elements. */
+ size_t *current_layer; /* axes[PIVOT_AXIS_LAYER].n_dimensions elements. */
enum settings_value_show show_values;
enum settings_value_show show_variables;
struct fmt_spec weight_format;
struct pivot_value *content);
struct pivot_table *pivot_table_ref (const struct pivot_table *);
+struct pivot_table *pivot_table_unshare (struct pivot_table *);
void pivot_table_unref (struct pivot_table *);
bool pivot_table_is_shared (const struct pivot_table *);
+/* Axes. */
+void pivot_table_swap_axes (struct pivot_table *,
+ enum pivot_axis_type, enum pivot_axis_type);
+void pivot_table_transpose (struct pivot_table *);
+void pivot_table_move_dimension (struct pivot_table *,
+ struct pivot_dimension *,
+ enum pivot_axis_type, size_t ofs);
+
/* Styling. */
const struct pivot_table_look *pivot_table_get_look (
const struct pivot_table *);
struct pivot_value *pivot_table_get_rw (struct pivot_table *,
const size_t *dindexes);
+bool pivot_table_delete (struct pivot_table *, const size_t *dindexes);
+
/* Footnotes.
Use pivot_table_create_footnote() to create a footnote.
char **subscripts;
size_t n_subscripts;
- char *superscript;
-
- const struct pivot_footnote **footnotes;
+ size_t *footnote_indexes;
size_t n_footnotes;
enum pivot_value_type type;
};
};
+/* Life cycle. */
+struct pivot_value *pivot_value_clone (const struct pivot_value *);
+void pivot_value_destroy (struct pivot_value *);
+
/* Numbers resulting from calculations. */
struct pivot_value *pivot_value_new_number (double);
struct pivot_value *pivot_value_new_integer (double);
/* Converting a pivot_value to a string for display. */
char *pivot_value_to_string (const struct pivot_value *,
- enum settings_value_show show_values,
- enum settings_value_show show_variables);
+ const struct pivot_table *);
+char *pivot_value_to_string_defaults (const struct pivot_value *);
void pivot_value_format (const struct pivot_value *,
- enum settings_value_show show_values,
- enum settings_value_show show_variables,
- struct string *);
+ const struct pivot_table *, struct string *);
bool pivot_value_format_body (const struct pivot_value *,
- enum settings_value_show show_values,
- enum settings_value_show show_variables,
+ const struct pivot_table *,
struct string *);
-void pivot_value_destroy (struct pivot_value *);
-
/* Styling. */
void pivot_value_get_style (struct pivot_value *,
const struct font_style *base_font_style,
struct table_area_style *);
void pivot_value_set_style (struct pivot_value *,
const struct table_area_style *);
+void pivot_value_set_font_style (struct pivot_value *,
+ const struct font_style *);
+void pivot_value_set_cell_style (struct pivot_value *,
+ const struct cell_style *);
/* Template arguments. */
struct pivot_argument
};
void pivot_argument_uninit (struct pivot_argument *);
+void pivot_argument_copy (struct pivot_argument *,
+ const struct pivot_argument *);
\f
/* One piece of data within a pivot table. */
struct pivot_cell
projects / pspp / blobdiff