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.bro...@gmail.com> ----- > > Date: Sun, 27 Aug 2017 11:56:27 +0200 > From: Peter Brooks <peter.h.m.bro...@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 _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
