Re: Calculations Result Sometimes Displays 000, Sometimes 444



In article <1119497230.203934.270590@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"Sug" <adam.sugerman@xxxxxxxxx> wrote:

> Hi, Harry -
>
> Thanks for taking a shot at this, because we've cracked it. I began
> this reply by listing why each of your solutions wasn't correct, but
> when I was addressing your mention of strange formatting options, it
> suddenly occurred to me, what if it's a fill character? If that were
> the case, each tab would display with exactly the number of fill
> characters that fit into the space, which in this situation happened to
> be three.
>
> Sure enough, the fill character for each tab was set to 4 on one of the
> fields and 0 on another. I can't believe I spent so many hours trying
> to crack this.
>
> But the real question is, why would three fields, each the duplicate of
> the other (as in command-D; as in, option-drag; as in, never accessed
> the text formatting dialog, let alone the _tab_ dialog three levels
> down), suddenly set all the tab stops to 0 or 4? Doesn't make sense.
> Is there a key combination I inadvertently pressed that sets tab fill
> characters? Seems unlikely.
>
> Nonetheless, I'm hugely relieved to have this solved. It was a real
> time-burner.

It's always the simplest answer that's over-looked. I probably wouldn't
have thought of looking at the fill character either. At least you've
now solved the problem. :o)

I doubt there's a keypress that would auto-set a field to use a tab
fill character to "4" or "0". Although it is possible when formatting
the field yourself to press the wrong key by accident (eg. perhaps you
wanted a hyphen as the fill character at some stage and hit the 0
instead).

It is also possible to set field format defaults by making sure you
haven't got anything selected and then changing the format options in
the menus or the side-toolbar. After doing that, any new field or text
added to a layout (not duplicate or copy / paste) will automatically
get that new default formatting. For example, click on 'nothing',
change the fill colour to yellow, then add a field or text and it will
be filled yellow.

Of course, when you duplicate or copy / paste a field it will also
duplicate any field formatting that the original field has.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.



Relevant Pages

  • Re: Heading Style wont stick
    ... Null character styles, maybe? ... because the selection was always in a paragraph. ... Then users could not understand that their formatting would sometimes apply, ... appended the name "Char" to the original style name. ...
    (microsoft.public.mac.office.word)
  • Re: Formatting index entries
    ... replace each space with a tab character ... Copy the whole cell ... use Edit>Replace to replace every tab with a space. ... you want to rip all the Index tags out of the main document. ...
    (microsoft.public.mac.office.word)
  • Re: Word 2004 and random Hidden characters
    ... created RTF with Word 2004, because while Word 2004 supports Unicode, it ... are apparently some passages of text which have the hidden character ... 'clear formatting' doesn't remove the hidden attribute). ... Mac, open in Word 2004 and the file appears empty (except the status bar at ...
    (microsoft.public.mac.office.word)
  • Re: Word 2004 and random Hidden characters
    ... created RTF with Word 2004, because while Word 2004 supports Unicode, it ... are apparently some passages of text which have the hidden character ... 'clear formatting' doesn't remove the hidden attribute). ... have white space characters show up as '??' ...
    (microsoft.public.mac.office.word)
  • Re: Removing a font override from a style
    ... The list says that Ctrl-Shift-Z is also Reset Char. ... direct character formatting, while Ctrl+Q removes any direct paragraph ... any point--paragraph style and character style. ... Paragraph Font). ...
    (microsoft.public.word.docmanagement)