On 28/04/2021 11:55, Jörg Schmidt wrote: > > >> -----Original Message----- >> From: Dave Barton [mailto:dbar...@posteo.net] >> Sent: Wednesday, April 28, 2021 12:30 PM >> To: dev@openoffice.apache.org >> Subject: Re: Feature: automatic enter of a decimal point at a >> fixed position >> > >>>> 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. > > I don't think so.
I do, because you are not dealing with the original issue. >> 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 > > Right. And? And that answers the issue Peter raised. > In this case 12,340 means the value 12340, the "," is NOT a decimal separator > but the thousands separator (in an English localised OO). Please do not lecture me on such things, I have been involved with this software since 2001 and a long term user of Star Office before that. > But what was the question? > Peter wants a solution how to enter 1234, but the value 12.34 should be taken > over. And I gave the correct answer. Dave --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org