On 28/04/2021 10:53, Jörg Schmidt wrote: >> -----Original Message----- >> From: DaveB [mailto:b...@apache.org] >> Sent: Wednesday, April 28, 2021 11:25 AM >> To: dev@openoffice.apache.org >> Subject: Re: Feature: automatic enter of a decimal point at a >> fixed position >> >> On 28/04/2021 09:59, Pedro Lino wrote: >>> Hi Peter >>> >>>> On 04/28/2021 3:27 AM Peter Kovacs <pe...@apache.org> wrote: >>> >>>> I have been asked on Facebook, and I found a forum thread >> if there is a >>>> feature that interprets the entry of numbers the last 2 >> numbers as digits. >>> >>>> Any Ideas, or inputs? Does LO maybe have done this? (I >> could not find >>>> any hints.) >>> >>> That is a simple calculation that can be done in two >> columns. Just type the number in one column without the dot >> (although I don't see that pressing an extra key would slow >> down any typist) and then on the next column divide it by 100. >>> >>> I think this is a simple user problem, not a dev issue... >>> >>> Regards, >>> Pedro >> >> Or a more simple solution = Format Cells > > Really not, no formatting is able to change a value. Sure, you can compensate > for this during further calculation (for example =SUM(D1:D10)/100 instead of > =SUM(D1:D10)), but who wants to work like that? > > > greetings, > Jörg
You are creating an issue where a problem does not exist. Using your example Cells D1:D12 formatted as numbers with zero decimal places means that only integer values are entered in those cells. Fill cells D1:D10 with the integer value 1234 and in cell D12 enter =SUM(D1:D10) which returns the result 12,340 Dave --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
