On Sat, 2006-03-04 at 10:21 +1100, Ross Johnson wrote: > On Fri, 2006-03-03 at 10:08 -0800, Michael J. Reude wrote: > > Immanuel CRC Office wrote: > > > Matt Kinsel wrote: > > >> Hi. I'm using OpenOffice.org 2.0 Beta on a Dell laptop running the > > >> Fedora > > >> Core 4 version of Linux. When I'm making a spreadsheet and type a > > >> fraction > > >> like "1/3" into one of the fields, it automatically converts it to a > > >> date > > >> like "01/03/2006". If I'm typing "4/5", it converts it to > > >> "04/05/2006". It > > >> does this for almost any fraction that can be converted to a date. Can > > >> anyone tell me how to turn this feature OFF? Thank you very much for > > >> your > > >> help. > > >> > > > As you are not subscribed, you may not have seen: > > > > > > Type =1/3 instead, because what you are trying to type is a formula, not > > > a fraction, and '=' forces Calc into formula entry mode. Calc doesn't > > > recognise fractions as such. > > > > > > By the way, I tried formatting the cells as Numbers, but then Calc just > > > displays the date in it's internal floating point representation. I.e > > > 1/3 becomes 38777.00 > > > > > > 'Fractions' that can't be turned into dates are left as text. > > > > > > > > > > > > Also, you could try typing '1/3 so that it recognizes the information > > > as text, not a date or fraction or anything. Add a ' to the beginning > > > of any cell will make it stay exactly as you type it. > > > > > > Crystle > > > > > Select the cells you want to put fractions into => right click => Select > > Format Cells => Select "Numbers" => Select "Fraction" from "Category" => > > Click "OK" > > > > That will allow you to put fractions into those cells, (i.e., 24 1/3, > > 1/2, etc.). > > Aha. Learning all the time... > but there seems to be a bug in this feature. It works for 1/3, 1/8, etc. > but 1/2 and 1/4 are converted to text, so that attempts to reference > that cell value return 0. Someone forgot to turn the autocorrect > functions off for non-text cells. You will need to turn that feature off > in Tools - AutoCorrect - Options.
There is an issue relating to this already and I've added a comment re fractions to it. Various other issue reports have been linked to this one, so it is a collection point. See: http://qa.openoffice.org/issues/show_bug.cgi?id=23612 Another annoyance (the subject of the original issue report) is that turning an AutoCorrect feature off in Calc also turns it off in all other OOo applications i.e. Writer etc. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
