static void
set_layout(GnmStyle * style,const psiconv_sheet_cell_layout psi_layout)
{
GnmColor *color;
set_format(style,psi_layout->numberformat);
gnm_style_set_font_size(style,psi_layout->character->font_size);
gnm_style_set_font_italic(style,psi_layout->character->italic?TRUE:FALSE);
gnm_style_set_font_bold(style,psi_layout->character->bold?TRUE:FALSE);
gnm_style_set_font_uline(style,
psi_layout->character->underline?TRUE:FALSE);
gnm_style_set_font_strike(style,
psi_layout->character->strikethrough?TRUE:FALSE);
gnm_style_set_font_name(style,
(const char *) psi_layout->character->font->name);
color = get_color(psi_layout->character->color);
if (color)
gnm_style_set_font_color (style, color);
/* TODO: Character level layouts: super_sub */
/* TODO: Paragraph level layouts: all */
/* TODO: Background color: add transparant if white */
#if 0
color = get_color(psi_layout->paragraph->back_color);
if (color) {
gnm_style_set_back_color(style, color);
gnm_style_set_pattern_color(style, color);
/* TODO: Replace 24 with some symbol */
gnm_style_set_pattern(style,1);
}
#endif
}
static gboolean
sylk_rtd_p_parse (SylkReader *state, char *str)
{
char *next;
int font_size;
GnmStyle *font = NULL;
for (; *str != '\0' ; str = next) {
next = sylk_next_token (str);
switch (*str) {
case 'P' : /* format */
g_ptr_array_add (state->formats,
go_format_new_from_XL (str+1));
break;
case 'F' : /* some sort of global font name */
break;
case 'E' : /* font name */
if (str[1] != '\0') {
if (NULL == font) font = gnm_style_new ();
gnm_style_set_font_name (font, str+1);
}
break;
case 'L' : /* font color ? */
break;
case 'M' : /* font size * 20 */
if (sylk_parse_int (str+1, &font_size) &&
font_size > 0) {
if (NULL == font) font = gnm_style_new ();
gnm_style_set_font_size (font, font_size / 20.0);
}
break;
case 'S' :
for (str++ ; *str && *str != ';' ; str++)
switch (*str) {
case 'I':
if (NULL == font) font = gnm_style_new ();
gnm_style_set_font_italic (font, TRUE);
break;
case 'B':
if (NULL == font) font = gnm_style_new ();
gnm_style_set_font_bold (font, TRUE);
break;
}
break;
default :
sylk_read_warning (state, "unknown P option '%c'", *str);
}
}
if (NULL != font)
g_ptr_array_add (state->fonts, font);
return TRUE;
}
static void
thrash_insert (Sheet *sheet)
{
int j;
GnmStyle *style1 = gnm_style_new ();
GnmStyle *style2 = gnm_style_new ();
gnm_style_set_font_bold (style1, TRUE);
gnm_style_set_font_italic (style1, TRUE);
gnm_style_set_font_size (style2, 20.0);
for (j = 0; j < INSERT_HEIGHT; j++) {
GnmRange r;
int i;
for (i = 0; i < INSERT_WIDTH; i++) {
GnmCell *cell;
GnmStyle *setstyle;
r.start.col = i;
r.start.row = j;
r.end = r.start;
if (((i / 31) % 2) == 0)
setstyle = style1;
else
setstyle = style2;
gnm_style_ref (setstyle);
sheet_style_attach (sheet, &r, setstyle);
cell = sheet_cell_fetch (sheet, i, j);
gnm_cell_set_value (cell, value_new_int (i), NULL);
}
r.start.col = 0;
r.start.row = MAX (0, j - 1);
r.end.col = gnm_sheet_get_max_cols (sheet);
r.end.row = MIN (gnm_sheet_get_max_rows (sheet), j + 1);
sheet_style_optimize (sheet, r);
}
gnm_style_unref (style1);
gnm_style_unref (style2);
}
static gboolean
sylk_rtd_f_parse (SylkReader *state, char *str)
{
GnmStyle *style = NULL;
char *next;
int tmp, size = -1;
gboolean is_default_style = FALSE;
int full_col = -1, full_row = -1;
for (; *str != '\0' ; str = next) {
next = sylk_next_token (str);
switch (*str) {
case 'D': /* Default sheet style
;D<fmt-id><digits><alignment><num_cols??> default Format. */
is_default_style = TRUE;
case 'F': { /* Cell Format
;F<fmt-id><digits><alignment>: Single cell format. */
/* Format:
D - default
C - currency (extended)
E - exponent
F - fixed
G - general,
$ - dollar
* - graph
% - percent
Alignment: DCGLR-X
*/
char ch1, alignment;
if (3 == sscanf (str+1, "%c%d%c", &ch1, &tmp, &alignment)) {
int a = -1;
switch (alignment) {
case 'S' : /* standard ? how does this differ from default */
case 'D' : a = GNM_HALIGN_GENERAL; break;
case 'L' : a = GNM_HALIGN_LEFT; break;
case 'R' : a = GNM_HALIGN_RIGHT; break;
case 'C' : a = GNM_HALIGN_CENTER; break;
case 'X' : a = GNM_HALIGN_FILL; break;
default :
break;
}
if (a >= 0) {
if (style == NULL) style = gnm_style_new ();
gnm_style_set_align_h (style, a);
}
}
break;
}
/**************************************************/
/* Globals */
case 'E':
state->pp.sheet->display_formulas = TRUE;
break;
case 'G':
state->pp.sheet->hide_grid = TRUE;
break;
case 'H':
state->pp.sheet->hide_col_header = TRUE;
state->pp.sheet->hide_row_header = TRUE;
break;
case 'K': /* show commas ?? */
break;
case 'Z': /* hide zeros */
state->pp.sheet->hide_zero = TRUE;
break;
/**************************************************/
case 'M' : /* row or col size * 20 or num cols for global */
sylk_parse_int (str+1, &size);
break;
case 'N' : { /* global font */
int size;
if (2 == sscanf (str+1, "%d %d", &tmp, &size) &&
1 <= tmp && tmp <= (int)state->fonts->len) {
GnmStyle const *font =
g_ptr_array_index (state->fonts, tmp-1);
if (style == NULL) style = gnm_style_new ();
is_default_style = TRUE;
gnm_style_merge_element (style, font,
MSTYLE_FONT_NAME);
gnm_style_merge_element (style, font,
MSTYLE_FONT_SIZE);
/* It looks like the size from the id dominates
* this size */
}
break;
}
case 'P':
if (sylk_parse_int (str+1, &tmp) &&
0 <= tmp && tmp < (int)state->formats->len) {
if (style == NULL) style = gnm_style_new ();
gnm_style_set_format (style,
g_ptr_array_index (state->formats, tmp));
}
break;
case 'S':
for (str++ ; *str && *str != ';' ; str++) {
switch (*str) {
case 'I':
if (style == NULL) style = gnm_style_new ();
gnm_style_set_font_italic (style, TRUE);
break;
case 'D':
if (style == NULL) style = gnm_style_new ();
gnm_style_set_font_bold (style, TRUE);
break;
case 'M':
if (sylk_parse_int (str+1, &tmp) &&
1 <= tmp && tmp <= (int)state->fonts->len) {
GnmStyle const *font =
g_ptr_array_index (state->fonts, tmp-1);
if (style == NULL) style = gnm_style_new ();
gnm_style_merge_element (style, font,
MSTYLE_FONT_NAME);
gnm_style_merge_element (style, font,
MSTYLE_FONT_SIZE);
}
str = (char *)" ";
break;
case 'S': /* seems to stipple things */
if (style == NULL) style = gnm_style_new ();
gnm_style_set_pattern (style, 5);
break;
case 'T': style = sylk_set_border (style, MSTYLE_BORDER_TOP); break;
case 'B': style = sylk_set_border (style, MSTYLE_BORDER_BOTTOM); break;
case 'L': style = sylk_set_border (style, MSTYLE_BORDER_LEFT); break;
case 'R': style = sylk_set_border (style, MSTYLE_BORDER_RIGHT); break;
default:
sylk_read_warning (state, "unhandled style S%c.", *str);
}
}
break;
case 'W': {
int first, last, width;
if (3 == sscanf (str+1, "%d %d %d", &first, &last, &width)) {
/* width seems to be in characters */
if (first <= last &&
first < gnm_sheet_get_max_cols (state->pp.sheet) &&
last < gnm_sheet_get_max_cols (state->pp.sheet))
while (first <= last)
sheet_col_set_size_pts (state->pp.sheet,
first++ - 1, width*7.45, TRUE);
}
break;
}
case 'C': if (sylk_parse_int (str+1, &tmp)) full_col = tmp - 1; break;
case 'R': if (sylk_parse_int (str+1, &tmp)) full_row = tmp - 1; break;
case 'X': if (sylk_parse_int (str+1, &tmp)) state->pp.eval.col = tmp - 1; break;
case 'Y': if (sylk_parse_int (str+1, &tmp)) state->pp.eval.row = tmp - 1; break;
default:
sylk_read_warning (state, "unhandled F option %c.", *str);
}
}
if (full_col >= 0) {
if (NULL != style)
sheet_style_apply_col (state->pp.sheet, full_col, style);
if (size > 0)
sheet_col_set_size_pts (state->pp.sheet,
full_col, size / 20.0, FALSE);
} else if (full_row >= 0) {
if (NULL != style)
sheet_style_apply_row (state->pp.sheet, full_row, style);
if (size > 0)
sheet_row_set_size_pts (state->pp.sheet,
full_row, size / 20.0, FALSE);
} else if (NULL != style) {
if (is_default_style) {
GnmRange r;
range_init_full_sheet (&r, state->pp.sheet);
sheet_style_apply_range (state->pp.sheet, &r, style);
} else
sheet_style_apply_pos (state->pp.sheet,
state->pp.eval.col, state->pp.eval.row, style);
}
return TRUE;
}
static void
html_read_content (htmlNodePtr cur, GString *buf, GnmStyle *mstyle,
xmlBufferPtr a_buf, GSList **hrefs, gboolean first,
htmlDocPtr doc, GnmHtmlTableCtxt *tc)
{
htmlNodePtr ptr;
for (ptr = cur->children; ptr != NULL ; ptr = ptr->next) {
if (ptr->type == XML_TEXT_NODE) {
if (g_utf8_validate (ptr->content, -1, NULL))
html_append_text (buf, ptr->content);
else
g_string_append (buf, _("[Warning: Invalid text string has been removed.]"));
} else if (ptr->type == XML_ELEMENT_NODE) {
if (first) {
if (xmlStrEqual (ptr->name, CC2XML ("i"))
|| xmlStrEqual (ptr->name, CC2XML ("em")))
gnm_style_set_font_italic (mstyle, TRUE);
if (xmlStrEqual (ptr->name, CC2XML ("b")))
gnm_style_set_font_bold (mstyle, TRUE);
}
if (xmlStrEqual (ptr->name, CC2XML ("a"))) {
xmlAttrPtr props;
props = ptr->properties;
while (props) {
if (xmlStrEqual (props->name, CC2XML ("href")) && props->children) {
*hrefs = g_slist_prepend (
*hrefs, props->children);
}
props = props->next;
}
}
if (xmlStrEqual (ptr->name, CC2XML ("img"))) {
xmlAttrPtr props;
props = ptr->properties;
while (props) {
if (xmlStrEqual (props->name, CC2XML ("src")) && props->children) {
htmlNodeDump (a_buf, doc, props->children);
xmlBufferAdd (a_buf, CC2XML ("\n"), -1);
}
props = props->next;
}
}
if (xmlStrEqual (ptr->name, CC2XML ("table"))) {
Sheet *last_sheet = tc->sheet;
int last_row = tc->row;
tc->sheet = NULL;
tc->row = -1;
html_read_table (ptr, doc, tc->wb_view, tc);
if (tc->sheet) {
g_string_append_printf (buf, _("[see sheet %s]"), tc->sheet->name_quoted);
xmlBufferAdd (a_buf, CC2XML (_("The original html file is\n"
"using nested tables.")), -1);
}
tc->sheet = last_sheet;
tc->row = last_row;
} else
html_read_content
(ptr, buf, mstyle, a_buf, hrefs, first, doc, tc);
}
first = FALSE;
}
}
