void
go_cmd_context_error_invalid (GOCmdContext *context, char const *msg, char const *val)
{
GError *err = g_error_new (go_error_invalid(), 0, "Invalid %s : '%s'", msg, val);
go_cmd_context_error (context, err);
g_error_free (err);
}
void
go_cmd_context_error_export (GOCmdContext *context, char const *message)
{
GError *err = format_message (go_error_export (), message);
go_cmd_context_error (context, err);
g_error_free (err);
}
void
dialog_data_table (WBCGtk *wbcg)
{
GnmDialogDataTable *state;
GnmRange const *r;
GnmRange input_range;
SheetView *sv;
Sheet *sheet;
g_return_if_fail (wbcg != NULL);
if (wbc_gtk_get_guru (wbcg) ||
gnm_dialog_raise_if_exists (wbcg, DIALOG_DATA_TABLE_KEY))
return;
sv = wb_control_cur_sheet_view (GNM_WBC (wbcg));
r = selection_first_range (sv, GO_CMD_CONTEXT (wbcg), _("Create Data Table"));
if (NULL == r)
return;
if (range_width (r) <= 1 || range_height (r) <= 1) {
GError *msg = g_error_new (go_error_invalid(), 0,
_("The selection must have more than 1 column and row to create a Data Table."));
go_cmd_context_error (GO_CMD_CONTEXT (wbcg), msg);
g_error_free (msg);
return;
}
input_range = *r;
input_range.start.col++;
input_range.start.row++;
sheet = sv_sheet (sv);
if (sheet_range_splits_region (sheet, &input_range, NULL,
GO_CMD_CONTEXT (wbcg), _("Data Table")))
return;
if (cmd_cell_range_is_locked_effective
(sheet, &input_range, GNM_WBC (wbcg),
_("Data Table")))
return;
state = g_new0 (GnmDialogDataTable, 1);
state->wbcg = wbcg;
state->sheet = sheet;
state->input_range = input_range;
if (data_table_init (state, wbcg)) {
go_gtk_notice_dialog (wbcg_toplevel (wbcg), GTK_MESSAGE_ERROR,
_("Could not create the Data Table definition dialog."));
g_free (state);
}
}
static void
soi_cb_save_as (SheetObject *so, SheetControl *sc)
{
WBCGtk *wbcg;
char *uri;
GsfOutput *output;
GSList *l = NULL;
GOImageFormat sel_fmt;
GOImageFormatInfo const *format_info;
GdkPixbuf *pixbuf = NULL;
GError *err = NULL;
SheetObjectImage *soi = SHEET_OBJECT_IMAGE (so);
g_return_if_fail (soi != NULL);
sel_fmt = go_image_get_format_from_name (soi->type);
if ((pixbuf = go_image_get_pixbuf (soi->image)) != NULL)
l = go_image_get_formats_with_pixbuf_saver ();
/* Move original format first in menu */
if (sel_fmt != GO_IMAGE_FORMAT_UNKNOWN) {
l = g_slist_remove (l, GUINT_TO_POINTER (sel_fmt));
l = g_slist_prepend (l, GUINT_TO_POINTER (sel_fmt));
}
wbcg = scg_wbcg (SHEET_CONTROL_GUI (sc));
uri = go_gui_get_image_save_info (wbcg_toplevel (wbcg), l, &sel_fmt, NULL);
if (!uri)
goto out;
output = go_file_create (uri, &err);
if (!output)
goto out;
format_info = go_image_get_format_info (sel_fmt);
sheet_object_write_image (so, (format_info? format_info->name: NULL), -1.0, output, &err);
gsf_output_close (output);
g_object_unref (output);
if (err != NULL)
go_cmd_context_error (GO_CMD_CONTEXT (wbcg), err);
out:
if (pixbuf)
g_object_unref (pixbuf);
g_free (uri);
g_slist_free (l);
}
/**
* stf_text_to_columns:
* @wbc: The control making the request
* @cc:
*
* Main routine, handles importing a file including all dialog mumbo-jumbo
**/
void
stf_text_to_columns (WorkbookControl *wbc, GOCmdContext *cc)
{
DialogStfResult_t *dialogresult = NULL;
SheetView *sv;
Sheet *src_sheet, *target_sheet;
GnmRange const *src;
GnmRange target;
GsfOutput *buf;
guint8 const *data;
size_t data_len;
sv = wb_control_cur_sheet_view (wbc);
src_sheet = sv_sheet (sv);
src = selection_first_range (sv, cc, _("Text to Columns"));
if (src == NULL)
return;
if (range_width (src) > 1) {
go_cmd_context_error (cc, g_error_new (go_error_invalid (), 0,
_("Only one column of input data can be parsed at a time")));
return;
}
/* FIXME : how to do this cleanly ? */
if (!GNM_IS_WBC_GTK (wbc))
return;
#warning Add UI for this
target_sheet = src_sheet;
target = *src;
range_translate (&target, target_sheet, 1, 0);
buf = gsf_output_memory_new ();
sheet_foreach_cell_in_range (src_sheet,
CELL_ITER_ALL,
src->start.col, src->start.row,
src->end.col, src->end.row,
(CellIterFunc) &cb_get_content, buf);
gsf_output_close (buf);
data = gsf_output_memory_get_bytes (GSF_OUTPUT_MEMORY (buf));
data_len = (size_t)gsf_output_size (buf);
if (data_len == 0) {
go_cmd_context_error_import (GO_CMD_CONTEXT (cc),
_("There is no data "
"to convert"));
} else {
dialogresult = stf_dialog (WBC_GTK (wbc),
NULL, FALSE, NULL, FALSE,
_("Text to Columns"),
data, data_len);
}
if (dialogresult != NULL) {
GnmCellRegion *cr = stf_parse_region (dialogresult->parseoptions,
dialogresult->text, NULL, target_sheet->workbook);
if (cr != NULL) {
stf_dialog_result_attach_formats_to_cr (dialogresult, cr);
target.end.col = target.start.col + cr->cols - 1;
target.end.row = target.start.row + cr->rows - 1;
}
if (cr == NULL ||
cmd_text_to_columns (wbc, src, src_sheet,
&target, target_sheet, cr))
go_cmd_context_error_import (GO_CMD_CONTEXT (cc),
_("Error while trying to "
"parse data into sheet"));
stf_dialog_result_free (dialogresult);
}
g_object_unref (buf);
}