Re: Column Width in Inches, Want Pixels

In article <C0FEC02E.10A1E%bdsmith@xxxxxxxxxxxxx>,
"Brian D. Smith" <bdsmith@xxxxxxxxxxxxx> wrote:

When I select the menu [Format | Column | Width...] the size is listed in
inches instead of pixels/points, as it used to be.

I don't know how I switched this. How do I switch it back?

Column width has never been in pixels/points. In previous MacXL versions
it was set in units which were equivalent to the width of the number
characters for the default font (e.g., if the width was set to 10, then
10 number characters would fit in the cell).

MacXL04 changed this to inches/cm (depending on your preferences). You
can still see the number of units if you click on the divider between
columns in the column header.

To reliably set the column width in pixels or points requires using VBA.
.

Relevant Pages

  • Re: Questions about Expect buffers & operation
    ... you don't have to actually send the characters - just expect something you know ... looked like when I sent some characters to the channel that I could then turn ... out the channel to the virtual console that would not have an adverse effect ... The switch allows you to flip between ...
    (comp.lang.tcl)
  • Re: Extending 5-level code
    ... and 11011 switched between letters and figures and almost ... special characters on the other 'case' it's hard to figure out how you would ... They would have had to have their own special machines which could switch ...
    (sci.crypt)
  • [SUMMARY] Numbers Can Be Words (#133)
    ... We all enjoy a good one-liner, ... it's important to remember that Ruby has a lot of command-line switches ... The -p switch asks Ruby to wrap your program in a read and print loop over the ... That's really just one big character class describing the accepted characters. ...
    (comp.lang.ruby)
  • [SUMMARY] Numbers Can Be Words (#133)
    ... We all enjoy a good one-liner, ... it's important to remember that Ruby has a lot of command-line switches ... The -p switch asks Ruby to wrap your program in a read and print loop over the ... That's really just one big character class describing the accepted characters. ...
    (comp.lang.ruby)
  • Re: Passing parameter to an EXE
    ... I see that some switch values do not get passed. ... CMD.EXE) is probably sucking up varying switch characters on you. ... > Lhan wrote: ...
    (microsoft.public.fox.programmer.exchange)