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

[Peter Brooks <peter h m brooks gmail com>]

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
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
> ----- End forwarded message -----
>
> --
>
> ------->  First-time AP Stats. teacher?  Help is on the way! See
> http://courses.ncssm.edu/math/Stat_Inst/Stats2007/Bob%20Hayden/Relief.html
>       _
>      | |          Robert W. Hayden
>      | |          5 Howard Street, Apartment 206
>     /  |          Wilton, New Hampshire 03086  USA
>    |   |
>    |   |          email: bob@ the site below
>   /  x |          website: http://statland.org
>  |     /
>  ''''''
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list



-- 
Peter Brooks


Mobile: +27 82 717 6404
Direct:  +27 21 447 9752
Skype:  Fustbariclation
Twitter: Fustbariclation
Google+: Fustbariclation
Author Page: amazon.com/author/peter_brooks