[Tfug] Turning off OOo auto-format?

[Malcolm Schmerl]

Claude Rubinson wrote:
> I'm running into some frustration with OpenOffice's spreadsheet
> thinking that it's smarter than I am.  I've got a list of figures with
> major.minor-style numbering (e.g., Figure 1.2, 1.3, etc).  The problem
> is with, e.g., Figure 1.30.  OpenOffice decides "that's a number" and
> then strips off the trailing zero, leaving me with "1.3".  Is there
> anyway to stop this behavior?
>
> Changing the formatting of the individual column to text is not an
> option.  I'm only using OpenOffice as a means of easing data entry.
> The spreadsheet is always save as plain text and, so, the next time
> that I open the file, OpenOffice re-strips all of the trailing zeros.
>
> So, I'm looking to turn off autoformatting entirely.  I'm happy to
> switch to another app; KSpread appears to do the same thing.
>
> Any suggestions would be appreciated,
>
> Claude
>
> _______________________________________________
> Tucson Free Unix Group - tfug at tfug.org
> Subscription Options:
> http://www.tfug.org/mailman/listinfo/tfug_tfug.org
>
>   
Claude,

The sixth and seventh icons from the left in the third tool bar from the 
top allow you to specify how many decimal places to display a number. 
If, for example, you're displaying monetary figures, you'd always want 
them displayed with two decimal places.  Malcolm