Hi Bruce, Thanks for your reply. The two columns that 'disappeared' (width almost zero- one was 0.46, so not hidden as such), were both text columns, one 256 characters, the other 512. Other text columns with less characters were OK. Not sure why this is.
I am now trying out the Wizard to see if I can make that work correctly. Thanks for your help. Regards John Docherty On Sunday, March 15, 2026 at 5:02:26 PM UTC+13 Bruce Chitiea wrote: > John: Just spitballin’ here. Do these zero-width columns share any common > characteristic, e.g. all NULLs, or BLANK_IF_[ NULL | ZERO ]? > > Failing a coded solution, I’d go low tech: highlighting a span of columns > surrounding the target column, [right-clicking] and hitting Unhide to show > the column. > > That’s all I got. > > Bruce Chitiea > > > ------ Original Message ------ > From "[email protected]" <[email protected]> > To "RBASE-L" <[email protected]> > Date 3/14/2026 20:40:45 > Subject [RBASE-L] - Formatting an XLS File > > Hi, > > I was wondering how or if it is possible to control the column width when > a file is exported to an Excel spreadsheet using a command file ? I have > been unable to find any details on this, but maybe I am missing something > here ? Any help would be very much appreciated. > > (I ask as some columns are exported with 'zero' width and are hence not > visible when opened in Excel and need to be adjusted manually. > > Thank you. > Regards, > John Docherty > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/rbase-l/482630ca-a996-4083-9dcf-7354e9b7303bn%40googlegroups.com > > <https://groups.google.com/d/msgid/rbase-l/482630ca-a996-4083-9dcf-7354e9b7303bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/8c774a72-8f1f-4b08-a601-c7cf77030fd8n%40googlegroups.com.
