Re: [peter h m brooks gmail com: ssconvert - column spacing]

Thank you - that is very useful.

On 27 August 2017 at 18:26, User Hayden via gnumeric-list
<gnumeric-list gnome org> wrote:

I know nothing about the inner workings of ssconvert but have a lot
of experience using many different spreadsheet programs and trying to
move files across platforms and OSs.  My guess is that it is common
for the width of a column that is set to match the widest entry to be
stored as a constant rather than a function.  For example, I just
checked Gnumeric by entering some data in a column and then setting
the width to automatically fit.  It worked, but then when I entered a
longer string into that column the column did not auto-adjust.

The relevance to your situation is that I am guessing that the issue
is not that ssconvert fails to bring in the info that this column's
width is automatic; I am guessing that information is not in the
source file to begin with.  So this feature might require manual
intervention to tell ssconvert which columns should be auto-width, and
width matching code inside ssconvert..

I have never had problems with the auto-width function not working as
long as I do not enter cells that are wider than expected nor try to
move the file elsewhere.  When moving, a commmon problem is that the
two machines have different fonts installed, and the substitute font
may take up more room.  To handle this ssconvert would have to know
what fonts are installed on the target platform.

----- Forwarded message from Peter Brooks <peter h m brooks gmail com> -----

Date: Sun, 27 Aug 2017 11:56:27 +0200
From: Peter Brooks <peter h m brooks gmail com>
To: gnumeric-list gnome org
Subject: ssconvert - column spacing

I've been using ssconvert a lot recently, and it really is excellent!

The main problem that I've been having has been column widths. Various
spreadsheet programs say they make the columns as wide as the widest
entry (which would be fine), but they clearly don't.

Is there a way to get ssconvert to set the column width? Either to the
maximum size or to any size.

I've been using MacoS Numbers and LibreOffice Calc.
gnumeric-list mailing list
gnumeric-list gnome org

----- End forwarded message -----


------->  First-time AP Stats. teacher?  Help is on the way! See
     | |          Robert W. Hayden
     | |          5 Howard Street, Apartment 206
    /  |          Wilton, New Hampshire 03086  USA
   |   |
   |   |          email: bob@ the site below
  /  x |          website:
 |     /

gnumeric-list mailing list
gnumeric-list gnome org

Peter Brooks

Mobile: +27 82 717 6404
Direct:  +27 21 447 9752
Skype:  Fustbariclation
Twitter: Fustbariclation
Google+: Fustbariclation
Author Page:

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]