1 /* PSPP - a program for statistical analysis.
2 Copyright (C) 2019 Free Software Foundation, Inc.
4 This program is free software: you can redistribute it and/or modify
5 it under the terms of the GNU General Public License as published by
6 the Free Software Foundation, either version 3 of the License, or
7 (at your option) any later version.
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program. If not, see <http://www.gnu.org/licenses/>. */
19 #include "output/spv/spv-writer.h"
22 #include <libxml/xmlwriter.h>
27 #include "libpspp/array.h"
28 #include "libpspp/assertion.h"
29 #include "libpspp/cast.h"
30 #include "libpspp/float-format.h"
31 #include "libpspp/integer-format.h"
32 #include "libpspp/temp-file.h"
33 #include "libpspp/version.h"
34 #include "libpspp/zip-writer.h"
35 #include "output/page-setup-item.h"
36 #include "output/pivot-table.h"
37 #include "output/text-item.h"
39 #include "gl/xalloc.h"
40 #include "gl/xvasprintf.h"
43 #define _(msgid) gettext (msgid)
44 #define N_(msgid) (msgid)
48 struct zip_writer *zw;
57 struct page_setup *page_setup;
61 char * WARN_UNUSED_RESULT
62 spv_writer_open (const char *filename, struct spv_writer **writerp)
66 struct zip_writer *zw = zip_writer_create (filename);
68 return xasprintf (_("%s: create failed"), filename);
70 struct spv_writer *w = xmalloc (sizeof *w);
71 *w = (struct spv_writer) { .zw = zw };
76 char * WARN_UNUSED_RESULT
77 spv_writer_close (struct spv_writer *w)
82 zip_writer_add_string (w->zw, "META-INF/MANIFEST.MF", "allowPivoting=true");
84 while (w->heading_depth)
85 spv_writer_close_heading (w);
88 if (!zip_writer_close (w->zw))
89 error = xstrdup (_("I/O error writing SPV file"));
91 page_setup_destroy (w->page_setup);
97 spv_writer_set_page_setup (struct spv_writer *w,
98 const struct page_setup *page_setup)
100 page_setup_destroy (w->page_setup);
101 w->page_setup = page_setup_clone (page_setup);
105 write_attr (struct spv_writer *w, const char *name, const char *value)
107 xmlTextWriterWriteAttribute (w->xml,
108 CHAR_CAST (xmlChar *, name),
109 CHAR_CAST (xmlChar *, value));
112 static void PRINTF_FORMAT (3, 4)
113 write_attr_format (struct spv_writer *w, const char *name,
114 const char *format, ...)
117 va_start (args, format);
118 char *value = xvasprintf (format, args);
121 write_attr (w, name, value);
126 start_elem (struct spv_writer *w, const char *name)
128 xmlTextWriterStartElement (w->xml, CHAR_CAST (xmlChar *, name));
132 end_elem (struct spv_writer *w)
134 xmlTextWriterEndElement (w->xml);
138 write_text (struct spv_writer *w, const char *text)
140 xmlTextWriterWriteString (w->xml, CHAR_CAST (xmlChar *, text));
144 write_page_heading (struct spv_writer *w, const struct page_heading *h,
147 start_elem (w, name);
150 start_elem (w, "pageParagraph");
151 for (size_t i = 0; i < h->n; i++)
153 start_elem (w, "text");
154 write_attr (w, "type", "title");
155 write_text (w, h->paragraphs[i].markup); /* XXX */
164 write_page_setup (struct spv_writer *w, const struct page_setup *ps)
166 start_elem (w, "pageSetup");
167 write_attr_format (w, "initial-page-number", "%d", ps->initial_page_number);
168 write_attr (w, "chart-size",
169 (ps->chart_size == PAGE_CHART_AS_IS ? "as-is"
170 : ps->chart_size == PAGE_CHART_FULL_HEIGHT ? "full-height"
171 : ps->chart_size == PAGE_CHART_HALF_HEIGHT ? "half-height"
172 : "quarter-height"));
173 write_attr_format (w, "margin-left", "%.2fin", ps->margins[TABLE_HORZ][0]);
174 write_attr_format (w, "margin-right", "%.2fin", ps->margins[TABLE_HORZ][1]);
175 write_attr_format (w, "margin-top", "%.2fin", ps->margins[TABLE_VERT][0]);
176 write_attr_format (w, "margin-bottom", "%.2fin", ps->margins[TABLE_VERT][1]);
177 write_attr_format (w, "paper-height", "%.2fin", ps->paper[TABLE_VERT]);
178 write_attr_format (w, "paper-width", "%.2fin", ps->paper[TABLE_HORZ]);
179 write_attr (w, "reference-orientation",
180 ps->orientation == PAGE_PORTRAIT ? "portrait" : "landscape");
181 write_attr_format (w, "space-after", "%.1fpt", ps->object_spacing * 72.0);
182 write_page_heading (w, &ps->headings[0], "pageHeader");
183 write_page_heading (w, &ps->headings[1], "pageFooter");
188 spv_writer_open_file (struct spv_writer *w)
190 w->heading = create_temp_file ();
194 w->xml = xmlNewTextWriter (xmlOutputBufferCreateFile (w->heading, NULL));
195 xmlTextWriterStartDocument (w->xml, NULL, "UTF-8", NULL);
196 start_elem (w, "heading");
198 time_t t = time (NULL);
199 struct tm *tm = gmtime (&t);
200 char *tm_s = asctime (tm);
201 write_attr (w, "creation-date-time", tm_s);
203 write_attr (w, "creator", version);
205 write_attr (w, "creator-version", "21");
207 write_attr (w, "xmlns", "http://xml.spss.com/spss/viewer/viewer-tree");
208 write_attr (w, "xmlns:vps", "http://xml.spss.com/spss/viewer/viewer-pagesetup");
209 write_attr (w, "xmlns:vtx", "http://xml.spss.com/spss/viewer/viewer-text");
210 write_attr (w, "xmlns:vtb", "http://xml.spss.com/spss/viewer/viewer-table");
212 start_elem (w, "label");
213 write_text (w, _("Output"));
218 write_page_setup (w, w->page_setup);
220 page_setup_destroy (w->page_setup);
221 w->page_setup = NULL;
228 spv_writer_open_heading (struct spv_writer *w, const char *command_id,
233 if (!spv_writer_open_file (w))
238 start_elem (w, "heading");
239 write_attr (w, "commandName", command_id);
243 start_elem (w, "label");
244 write_text (w, label);
249 spv_writer_close_file (struct spv_writer *w, const char *infix)
255 xmlTextWriterEndDocument (w->xml);
256 xmlFreeTextWriter (w->xml);
258 char *member_name = xasprintf ("outputViewer%010d%s.xml",
259 w->n_headings++, infix);
260 zip_writer_add (w->zw, w->heading, member_name);
267 spv_writer_close_heading (struct spv_writer *w)
269 const char *infix = "";
270 if (w->heading_depth)
277 if (!w->heading_depth)
278 spv_writer_close_file (w, infix);
282 start_container (struct spv_writer *w)
284 start_elem (w, "container");
285 write_attr (w, "visibility", "visible");
286 if (w->need_page_break)
288 write_attr (w, "page-break-before", "always");
289 w->need_page_break = false;
294 spv_writer_put_text (struct spv_writer *w, const struct text_item *text,
295 const char *command_id)
297 bool initial_depth = w->heading_depth;
299 spv_writer_open_file (w);
303 start_elem (w, "label");
304 write_text (w, (text->type == TEXT_ITEM_TITLE ? "Title"
305 : text->type == TEXT_ITEM_PAGE_TITLE ? "Page Title"
309 start_elem (w, "vtx:text");
310 write_attr (w, "type", (text->type == TEXT_ITEM_TITLE ? "title"
311 : text->type == TEXT_ITEM_PAGE_TITLE ? "page-title"
314 write_attr (w, "commandName", command_id);
316 start_elem (w, "html");
317 write_text (w, text->text); /* XXX */
318 end_elem (w); /* html */
319 end_elem (w); /* vtx:text */
320 end_elem (w); /* container */
323 spv_writer_close_file (w, "");
326 static cairo_status_t
327 write_to_zip (void *zw_, const unsigned char *data, unsigned int length)
329 struct zip_writer *zw = zw_;
331 zip_writer_add_write (zw, data, length);
332 return CAIRO_STATUS_SUCCESS;
336 spv_writer_put_image (struct spv_writer *w, cairo_surface_t *image)
338 bool initial_depth = w->heading_depth;
340 spv_writer_open_file (w);
342 char *uri = xasprintf ("%010d_Imagegeneric.png", ++w->n_tables);
346 start_elem (w, "label");
347 write_text (w, "Image");
350 start_elem (w, "object");
351 write_attr (w, "type", "unknown");
352 write_attr (w, "uri", uri);
353 end_elem (w); /* object */
354 end_elem (w); /* container */
357 spv_writer_close_file (w, "");
359 zip_writer_add_start (w->zw, uri);
360 cairo_surface_write_to_png_stream (image, write_to_zip, w->zw);
361 zip_writer_add_finish (w->zw);
367 spv_writer_eject_page (struct spv_writer *w)
369 w->need_page_break = true;
383 put_uninit (struct buf *b, size_t n)
385 while (b->allocated - b->len < n)
386 b->data = x2nrealloc (b->data, &b->allocated, sizeof b->data);
387 uint8_t *p = &b->data[b->len];
393 put_byte (struct buf *b, uint8_t byte)
395 *put_uninit (b, 1) = byte;
399 put_bool (struct buf *b, bool boolean)
401 put_byte (b, boolean);
405 put_bytes (struct buf *b, const char *bytes, size_t n)
407 memcpy (put_uninit (b, n), bytes, n);
411 put_u16 (struct buf *b, uint16_t x)
413 put_uint16 (native_to_le16 (x), put_uninit (b, sizeof x));
417 put_u32 (struct buf *b, uint32_t x)
419 put_uint32 (native_to_le32 (x), put_uninit (b, sizeof x));
423 put_u64 (struct buf *b, uint64_t x)
425 put_uint64 (native_to_le64 (x), put_uninit (b, sizeof x));
429 put_be32 (struct buf *b, uint32_t x)
431 put_uint32 (native_to_be32 (x), put_uninit (b, sizeof x));
435 put_double (struct buf *b, double x)
437 float_convert (FLOAT_NATIVE_DOUBLE, &x,
438 FLOAT_IEEE_DOUBLE_LE, put_uninit (b, 8));
442 put_float (struct buf *b, float x)
444 float_convert (FLOAT_NATIVE_FLOAT, &x,
445 FLOAT_IEEE_SINGLE_LE, put_uninit (b, 4));
449 put_string (struct buf *b, const char *s_)
451 const char *s = s_ ? s_ : "";
452 size_t len = strlen (s);
454 memcpy (put_uninit (b, len), s, len);
458 put_bestring (struct buf *b, const char *s_)
460 const char *s = s_ ? s_ : "";
461 size_t len = strlen (s);
463 memcpy (put_uninit (b, len), s, len);
467 start_count (struct buf *b)
474 end_count_u32 (struct buf *b, size_t start)
476 put_uint32 (native_to_le32 (b->len - start), &b->data[start - 4]);
480 end_count_be32 (struct buf *b, size_t start)
482 put_uint32 (native_to_be32 (b->len - start), &b->data[start - 4]);
486 put_color (struct buf *buf, const struct cell_color *color)
488 char *s = xasprintf ("#%02"PRIx8"%02"PRIx8"%02"PRIx8,
489 color->r, color->g, color->b);
495 put_font_style (struct buf *buf, const struct font_style *font_style)
497 put_bool (buf, font_style->bold);
498 put_bool (buf, font_style->italic);
499 put_bool (buf, font_style->underline);
501 put_color (buf, &font_style->fg[0]);
502 put_color (buf, &font_style->bg[0]);
503 put_string (buf, font_style->typeface ? font_style->typeface : "SansSerif");
504 put_byte (buf, ceil (font_style->size * 1.33));
508 put_halign (struct buf *buf, enum table_halign halign,
509 uint32_t mixed, uint32_t decimal)
511 put_u32 (buf, (halign == TABLE_HALIGN_RIGHT ? 4
512 : halign == TABLE_HALIGN_LEFT ? 2
513 : halign == TABLE_HALIGN_CENTER ? 0
514 : halign == TABLE_HALIGN_MIXED ? mixed
519 put_valign (struct buf *buf, enum table_valign valign)
521 put_u32 (buf, (valign == TABLE_VALIGN_TOP ? 1
522 : valign == TABLE_VALIGN_CENTER ? 0
527 put_cell_style (struct buf *buf, const struct cell_style *cell_style)
529 put_halign (buf, cell_style->halign, 0xffffffad, 6);
530 put_valign (buf, cell_style->valign);
531 put_double (buf, cell_style->decimal_offset);
532 put_u16 (buf, cell_style->margin[H][0]);
533 put_u16 (buf, cell_style->margin[H][1]);
534 put_u16 (buf, cell_style->margin[V][0]);
535 put_u16 (buf, cell_style->margin[V][1]);
539 put_style_pair (struct buf *buf, const struct font_style *font_style,
540 const struct cell_style *cell_style)
544 put_byte (buf, 0x31);
545 put_font_style (buf, font_style);
548 put_byte (buf, 0x58);
552 put_byte (buf, 0x31);
553 put_cell_style (buf, cell_style);
556 put_byte (buf, 0x58);
560 put_value_mod (struct buf *buf, const struct pivot_value *value,
561 const char *template)
563 if (value->n_footnotes || value->n_subscripts
564 || template || value->font_style || value->cell_style)
566 put_byte (buf, 0x31);
569 put_u32 (buf, value->n_footnotes);
570 for (size_t i = 0; i < value->n_footnotes; i++)
571 put_u16 (buf, value->footnote_indexes[i]);
574 put_u32 (buf, value->n_subscripts);
575 for (size_t i = 0; i < value->n_subscripts; i++)
576 put_string (buf, value->subscripts[i]);
578 /* Template and style. */
579 uint32_t v3_start = start_count (buf);
580 uint32_t template_string_start = start_count (buf);
583 uint32_t inner_start = start_count (buf);
584 end_count_u32 (buf, inner_start);
586 put_byte (buf, 0x31);
587 put_string (buf, template);
589 end_count_u32 (buf, template_string_start);
590 put_style_pair (buf, value->font_style, value->cell_style);
591 end_count_u32 (buf, v3_start);
594 put_byte (buf, 0x58);
598 put_format (struct buf *buf, const struct fmt_spec *f, bool honor_small)
600 int type = f->type == FMT_F && honor_small ? 40 : fmt_to_io (f->type);
601 put_u32 (buf, (type << 16) | (f->w << 8) | f->d);
605 show_values_to_spvlb (enum settings_value_show show)
607 return (show == SETTINGS_VALUE_SHOW_DEFAULT ? 0
608 : show == SETTINGS_VALUE_SHOW_VALUE ? 1
609 : show == SETTINGS_VALUE_SHOW_LABEL ? 2
614 put_show_values (struct buf *buf, enum settings_value_show show)
616 put_byte (buf, show_values_to_spvlb (show));
620 put_value (struct buf *buf, const struct pivot_value *value)
624 case PIVOT_VALUE_NUMERIC:
625 if (value->numeric.var_name || value->numeric.value_label)
628 put_value_mod (buf, value, NULL);
629 put_format (buf, &value->numeric.format, value->numeric.honor_small);
630 put_double (buf, value->numeric.x);
631 put_string (buf, value->numeric.var_name);
632 put_string (buf, value->numeric.value_label);
633 put_show_values (buf, value->numeric.show);
638 put_value_mod (buf, value, NULL);
639 put_format (buf, &value->numeric.format, value->numeric.honor_small);
640 put_double (buf, value->numeric.x);
644 case PIVOT_VALUE_STRING:
646 put_value_mod (buf, value, NULL);
647 size_t len = strlen (value->string.s);
648 if (value->string.hex)
649 put_format (buf, &(struct fmt_spec) { FMT_AHEX, len * 2, 0 }, false);
651 put_format (buf, &(struct fmt_spec) { FMT_A, len, 0 }, false);
652 put_string (buf, value->string.value_label);
653 put_string (buf, value->string.var_name);
654 put_show_values (buf, value->string.show);
655 put_string (buf, value->string.s);
658 case PIVOT_VALUE_VARIABLE:
660 put_value_mod (buf, value, NULL);
661 put_string (buf, value->variable.var_name);
662 put_string (buf, value->variable.var_label);
663 put_show_values (buf, value->variable.show);
666 case PIVOT_VALUE_TEXT:
668 put_string (buf, value->text.local);
669 put_value_mod (buf, value, NULL);
670 put_string (buf, value->text.id);
671 put_string (buf, value->text.c);
672 put_byte (buf, 1); /* XXX user-provided */
675 case PIVOT_VALUE_TEMPLATE:
677 put_value_mod (buf, value, value->template.id);
678 put_string (buf, value->template.local);
679 put_u32 (buf, value->template.n_args);
680 for (size_t i = 0; i < value->template.n_args; i++)
682 const struct pivot_argument *arg = &value->template.args[i];
683 assert (arg->n >= 1);
686 put_u32 (buf, arg->n);
688 for (size_t j = 0; j < arg->n; j++)
691 put_bytes (buf, "\0\0\0\0", 4);
692 put_value (buf, arg->values[j]);
698 put_value (buf, arg->values[0]);
709 put_optional_value (struct buf *buf, const struct pivot_value *value)
713 put_byte (buf, 0x31);
714 put_value (buf, value);
717 put_byte (buf, 0x58);
721 put_category (struct buf *buf, const struct pivot_category *c)
723 put_value (buf, c->name);
724 if (pivot_category_is_leaf (c))
726 put_bytes (buf, "\0\0\0", 3);
728 put_u32 (buf, c->data_index);
733 put_bytes (buf, "\0\0\1", 3);
734 put_u32 (buf, 0); /* x23 */
736 put_u32 (buf, c->n_subs);
737 for (size_t i = 0; i < c->n_subs; i++)
738 put_category (buf, c->subs[i]);
743 put_y0 (struct buf *buf, const struct pivot_table *table)
745 put_u32 (buf, table->settings.epoch);
746 put_byte (buf, table->settings.decimal);
751 put_custom_currency (struct buf *buf, const struct pivot_table *table)
754 for (int i = 0; i < 5; i++)
756 enum fmt_type types[5] = { FMT_CCA, FMT_CCB, FMT_CCC, FMT_CCD, FMT_CCE };
757 char *cc = fmt_number_style_to_string (fmt_settings_get_style (
758 &table->settings, types[i]));
759 put_string (buf, cc);
765 put_x1 (struct buf *buf, const struct pivot_table *table)
767 put_byte (buf, 0); /* x14 */
768 put_byte (buf, table->show_title ? 1 : 10);
769 put_byte (buf, 0); /* x16 */
770 put_byte (buf, 0); /* lang */
771 put_show_values (buf, table->show_variables);
772 put_show_values (buf, table->show_values);
773 put_u32 (buf, -1); /* x18 */
774 put_u32 (buf, -1); /* x19 */
775 for (int i = 0; i < 17; i++)
777 put_bool (buf, false); /* x20 */
778 put_byte (buf, table->show_caption);
782 put_x2 (struct buf *buf)
784 put_u32 (buf, 0); /* n-row-heights */
785 put_u32 (buf, 0); /* n-style-map */
786 put_u32 (buf, 0); /* n-styles */
791 put_y1 (struct buf *buf, const struct pivot_table *table)
793 put_string (buf, table->command_c);
794 put_string (buf, table->command_local);
795 put_string (buf, table->language);
796 put_string (buf, "UTF-8"); /* XXX */
797 put_string (buf, table->locale);
798 put_bytes (buf, "\0\0\1\1", 4);
803 put_y2 (struct buf *buf, const struct pivot_table *table)
805 put_custom_currency (buf, table);
811 put_x3 (struct buf *buf, const struct pivot_table *table)
815 put_byte (buf, 4); /* x21 */
820 put_double (buf, table->small);
822 put_string (buf, table->dataset);
823 put_string (buf, table->datafile);
825 put_u32 (buf, table->date);
831 encode_current_layer (const struct pivot_table *table)
833 uint32_t current_layer = 0;
835 const struct pivot_axis *axis = &table->axes[PIVOT_AXIS_LAYER];
836 for (size_t i = axis->n_dimensions - 1; i < axis->n_dimensions; i--)
838 const struct pivot_dimension *d = axis->dimensions[i];
839 current_layer = current_layer * d->n_leaves + table->current_layer[i];
842 return current_layer;
846 put_light_table (struct buf *buf, uint64_t table_id,
847 const struct pivot_table *table)
850 put_bytes (buf, "\1\0", 2);
852 put_bool (buf, true);
853 put_bool (buf, false);
854 put_bool (buf, table->rotate_inner_column_labels);
855 put_bool (buf, table->rotate_outer_row_labels);
856 put_bool (buf, true);
858 put_u32 (buf, table->look->width_ranges[H][0]);
859 put_u32 (buf, table->look->width_ranges[H][1]);
860 put_u32 (buf, table->look->width_ranges[V][0]);
861 put_u32 (buf, table->look->width_ranges[V][1]);
862 put_u64 (buf, table_id);
865 put_value (buf, table->title);
866 put_value (buf, table->subtype);
867 put_optional_value (buf, table->title);
868 put_optional_value (buf, table->corner_text);
869 put_optional_value (buf, table->caption);
872 put_u32 (buf, table->n_footnotes);
873 for (size_t i = 0; i < table->n_footnotes; i++)
875 const struct pivot_footnote *f = table->footnotes[i];
876 put_value (buf, f->content);
877 put_optional_value (buf, f->marker);
878 put_u32 (buf, f->show ? 1 : -1);
882 for (size_t i = 0; i < PIVOT_N_AREAS; i++)
884 const struct table_area_style *a = &table->look->areas[i];
885 put_byte (buf, i + 1);
886 put_byte (buf, 0x31);
887 put_string (buf, (a->font_style.typeface
888 ? a->font_style.typeface
890 put_float (buf, ceil (a->font_style.size * 1.33));
891 put_u32 (buf, ((a->font_style.bold ? 1 : 0)
892 | (a->font_style.italic ? 2 : 0)));
893 put_bool (buf, a->font_style.underline);
894 put_halign (buf, a->cell_style.halign, 64173, 61453);
895 put_valign (buf, a->cell_style.valign);
897 put_color (buf, &a->font_style.fg[0]);
898 put_color (buf, &a->font_style.bg[0]);
901 = (!cell_color_equal (&a->font_style.fg[0], &a->font_style.fg[1])
902 || !cell_color_equal (&a->font_style.bg[0], &a->font_style.bg[1]));
906 put_color (buf, &a->font_style.fg[1]);
907 put_color (buf, &a->font_style.bg[1]);
911 put_string (buf, "");
912 put_string (buf, "");
915 put_u32 (buf, a->cell_style.margin[H][0]);
916 put_u32 (buf, a->cell_style.margin[H][1]);
917 put_u32 (buf, a->cell_style.margin[V][0]);
918 put_u32 (buf, a->cell_style.margin[V][1]);
922 uint32_t borders_start = start_count (buf);
924 put_be32 (buf, PIVOT_N_BORDERS);
925 for (size_t i = 0; i < PIVOT_N_BORDERS; i++)
927 const struct table_border_style *b = &table->look->borders[i];
929 put_be32 (buf, (b->stroke == TABLE_STROKE_NONE ? 0
930 : b->stroke == TABLE_STROKE_SOLID ? 1
931 : b->stroke == TABLE_STROKE_DASHED ? 2
932 : b->stroke == TABLE_STROKE_THICK ? 3
933 : b->stroke == TABLE_STROKE_THIN ? 4
935 put_be32 (buf, ((b->color.alpha << 24)
940 put_bool (buf, table->show_grid_lines);
941 put_bytes (buf, "\0\0\0", 3);
942 end_count_u32 (buf, borders_start);
944 /* Print Settings. */
945 uint32_t ps_start = start_count (buf);
947 put_bool (buf, table->look->print_all_layers);
948 put_bool (buf, table->look->paginate_layers);
949 put_bool (buf, table->look->shrink_to_fit[H]);
950 put_bool (buf, table->look->shrink_to_fit[V]);
951 put_bool (buf, table->look->top_continuation);
952 put_bool (buf, table->look->bottom_continuation);
953 put_be32 (buf, table->look->n_orphan_lines);
954 put_bestring (buf, table->look->continuation);
955 end_count_u32 (buf, ps_start);
957 /* Table Settings. */
958 uint32_t ts_start = start_count (buf);
961 put_be32 (buf, encode_current_layer (table));
962 put_bool (buf, table->look->omit_empty);
963 put_bool (buf, table->look->row_labels_in_corner);
964 put_bool (buf, !table->look->show_numeric_markers);
965 put_bool (buf, table->look->footnote_marker_superscripts);
967 uint32_t keep_start = start_count (buf);
968 put_be32 (buf, 0); /* n-row-breaks */
969 put_be32 (buf, 0); /* n-column-breaks */
970 put_be32 (buf, 0); /* n-row-keeps */
971 put_be32 (buf, 0); /* n-column-keeps */
972 put_be32 (buf, 0); /* n-row-point-keeps */
973 put_be32 (buf, 0); /* n-column-point-keeps */
974 end_count_be32 (buf, keep_start);
975 put_bestring (buf, table->notes);
976 put_bestring (buf, table->look->name);
977 for (size_t i = 0; i < 82; i++)
979 end_count_u32 (buf, ts_start);
982 put_u32 (buf, 0); /* n-widths */
983 put_string (buf, "en_US.ISO_8859-1:1987"); /* XXX */
984 put_u32 (buf, 0); /* XXX current-layer */
989 put_custom_currency (buf, table);
990 uint32_t formats_start = start_count (buf);
991 uint32_t x1_start = start_count (buf);
993 uint32_t x2_start = start_count (buf);
995 end_count_u32 (buf, x2_start);
996 end_count_u32 (buf, x1_start);
997 uint32_t x3_start = start_count (buf);
999 end_count_u32 (buf, x3_start);
1000 end_count_u32 (buf, formats_start);
1003 put_u32 (buf, table->n_dimensions);
1004 int *x2 = xnmalloc (table->n_dimensions, sizeof *x2);
1005 for (size_t i = 0; i < table->axes[PIVOT_AXIS_LAYER].n_dimensions; i++)
1007 for (size_t i = 0; i < table->axes[PIVOT_AXIS_ROW].n_dimensions; i++)
1008 x2[i + table->axes[PIVOT_AXIS_LAYER].n_dimensions] = 0;
1009 for (size_t i = 0; i < table->axes[PIVOT_AXIS_COLUMN].n_dimensions; i++)
1011 + table->axes[PIVOT_AXIS_LAYER].n_dimensions
1012 + table->axes[PIVOT_AXIS_ROW].n_dimensions] = 1;
1013 for (size_t i = 0; i < table->n_dimensions; i++)
1015 const struct pivot_dimension *d = table->dimensions[i];
1016 put_value (buf, d->root->name);
1017 put_byte (buf, 0); /* x1 */
1018 put_byte (buf, x2[i]);
1019 put_u32 (buf, 2); /* x3 */
1020 put_bool (buf, !d->root->show_label);
1021 put_bool (buf, d->hide_all_labels);
1025 put_u32 (buf, d->root->n_subs);
1026 for (size_t j = 0; j < d->root->n_subs; j++)
1027 put_category (buf, d->root->subs[j]);
1032 put_u32 (buf, table->axes[PIVOT_AXIS_LAYER].n_dimensions);
1033 put_u32 (buf, table->axes[PIVOT_AXIS_ROW].n_dimensions);
1034 put_u32 (buf, table->axes[PIVOT_AXIS_COLUMN].n_dimensions);
1035 for (size_t i = 0; i < table->axes[PIVOT_AXIS_LAYER].n_dimensions; i++)
1036 put_u32 (buf, table->axes[PIVOT_AXIS_LAYER].dimensions[i]->top_index);
1037 for (size_t i = 0; i < table->axes[PIVOT_AXIS_ROW].n_dimensions; i++)
1038 put_u32 (buf, table->axes[PIVOT_AXIS_ROW].dimensions[i]->top_index);
1039 for (size_t i = 0; i < table->axes[PIVOT_AXIS_COLUMN].n_dimensions; i++)
1040 put_u32 (buf, table->axes[PIVOT_AXIS_COLUMN].dimensions[i]->top_index);
1043 put_u32 (buf, hmap_count (&table->cells));
1044 const struct pivot_cell *cell;
1045 HMAP_FOR_EACH (cell, struct pivot_cell, hmap_node, &table->cells)
1048 for (size_t j = 0; j < table->n_dimensions; j++)
1049 index = (table->dimensions[j]->n_leaves * index) + cell->idx[j];
1050 put_u64 (buf, index);
1052 put_value (buf, cell->value);
1057 spv_writer_put_table (struct spv_writer *w, const struct pivot_table *table)
1059 struct pivot_table *table_rw = CONST_CAST (struct pivot_table *, table);
1060 if (!table_rw->subtype)
1061 table_rw->subtype = pivot_value_new_user_text ("unknown", -1);
1063 int table_id = ++w->n_tables;
1065 bool initial_depth = w->heading_depth;
1067 spv_writer_open_file (w);
1069 start_container (w);
1071 char *title = pivot_value_to_string (table->title, table);
1072 char *subtype = pivot_value_to_string (table->subtype, table);
1074 start_elem (w, "label");
1075 write_text (w, title);
1078 start_elem (w, "vtb:table");
1079 write_attr (w, "commandName", table->command_c);
1080 write_attr (w, "type", "table"); /* XXX */
1081 write_attr (w, "subType", subtype);
1082 write_attr_format (w, "tableId", "%d", table_id);
1087 start_elem (w, "vtb:tableStructure");
1088 start_elem (w, "vtb:dataPath");
1089 char *data_path = xasprintf ("%010d_lightTableData.bin", table_id);
1090 write_text (w, data_path);
1091 end_elem (w); /* vtb:dataPath */
1092 end_elem (w); /* vtb:tableStructure */
1093 end_elem (w); /* vtb:table */
1094 end_elem (w); /* container */
1097 spv_writer_close_file (w, "");
1099 struct buf buf = { NULL, 0, 0 };
1100 put_light_table (&buf, table_id, table);
1101 zip_writer_add_memory (w->zw, data_path, buf.data, buf.len);