[libreoffice-users] prevent automatic reduction of fractions

2013-04-13 Thread e-letter
Readers,

Is it possible to prevent calc from automatic reduction of fractions?
For example for a cell formatted as data type 'fraction':

10/30

becomes

1/3.

How to stop this behaviour, so that '10/30' remains the values in the cell?

--
LO35

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] prevent automatic reduction of fractions

2013-04-13 Thread Tom Davies
Hi :)
Errr, you could format the cell as a text cell, perhaps just by typing in 
'10/30
The ' mark lets Calc know the cell is text.  

Unfortunately i think that means the 10/30 can't be used in formulas! :(  Btw 
Excel does the same thing jic you were wondering.  
Regards from
Tom :)






 From: e-letter inp...@gmail.com
To: users@global.libreoffice.org 
Sent: Saturday, 13 April 2013, 12:48
Subject: [libreoffice-users] prevent automatic reduction of fractions
 

Readers,

Is it possible to prevent calc from automatic reduction of fractions?
For example for a cell formatted as data type 'fraction':

10/30

becomes

1/3.

How to stop this behaviour, so that '10/30' remains the values in the cell?

--
LO35

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted