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




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
 |     /          
 ''''''         




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