[opensuse] Rounding of numbers in LO Calc
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi, I have to enter long numbers in 20150630xxxx75579OO LO CALC. Like "20150630xxxx75579", wich is an invoice number. It gets rounded to 2,01506300101756E+016, and displayed as "20150630xxxx76000", which is obviously the wrong invoice. How do I tell CALC to use Integers, not Reals? The numbers are not made by me, so no, I can't use shorter numbers. They are copy pasted from PDF files by me. I'm using libreoffice-calc-4.4.5.2-1.1.x86_64 in oS 13.1 - -- Cheers Carlos E. R. (from 13.1 x86_64 "Bottle" (Minas Tirith)) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iF4EAREIAAYFAlXiU2oACgkQja8UbcUWM1xUlAD/a2Dr1Op4tmVoy31K/9Herd9M /l6EKwUmdykwS+PUz+4A/R6xoDiYHMq60XgNQzVKj5lMkhX4EZnePdafVcTTHJjt =6czh -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* Carlos E. R.
I have to enter long numbers in 20150630xxxx75579OO LO CALC. Like "20150630xxxx75579", wich is an invoice number. It gets rounded to 2,01506300101756E+016, and displayed as "20150630xxxx76000", which is obviously the wrong invoice.
How do I tell CALC to use Integers, not Reals?
Have you tried enclosing in quote marks, also add a leading "@" at-sign. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 2015-08-30 03:20, Patrick Shanahan wrote:
* Carlos E. R. <> [08-29-15 20:51]:
How do I tell CALC to use Integers, not Reals?
Have you tried enclosing in quote marks, also add a leading "@" at-sign.
That works, yes, but only if I do it /before/ pasting the number from the PDF reader. If I paste the number into a cell, it is instantly rounded off at the right. At least two digits are lost forever. I have to hit F2, type a ' to signify it is text, then paste the number, which is then treated as text. But it is a XXI century computer and software, with 64 bit CPU, it should be able to handle big numbers as numbers. - -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" (Minas Tirith)) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iF4EAREIAAYFAlXiX0oACgkQja8UbcUWM1wiagD+LZiWe/YScfCJEejTbdHCnMLf Sro12NeI6zelXkfTsrkA/03qP2HBmseemWqBxhe3G1rO3Q93CXu/mS83CDb/2ToL =D6c/ -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* Carlos E. R.
On 2015-08-30 03:20, Patrick Shanahan wrote:
* Carlos E. R. <> [08-29-15 20:51]:
How do I tell CALC to use Integers, not Reals?
Have you tried enclosing in quote marks, also add a leading "@" at-sign.
That works, yes, but only if I do it /before/ pasting the number from the PDF reader. If I paste the number into a cell, it is instantly rounded off at the right. At least two digits are lost forever.
I have to hit F2, type a ' to signify it is text, then paste the number, which is then treated as text.
But it is a XXI century computer and software, with 64 bit CPU, it should be able to handle big numbers as numbers.
Format the cells as text, after all, the invoice number is just a place holder. You are not going to do calculations with it. There should be no rounding with a number as text. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 2015-08-30 03:47, Patrick Shanahan wrote:
* Carlos E. R. <> [08-29-15 21:42]:
Format the cells as text, after all, the invoice number is just a place holder. You are not going to do calculations with it. There should be no rounding with a number as text.
It is an extra operation. Compare: Select number in PDF. Copy to clipboard. Go to Calc. Press Ctrl-V. Done. To: Select number in PDF. Copy to clipboard. Go to Calc. Press F2, then ' or ", then Ctrl-V. Done. Paste multiple items? Impossible. Or (which is what you mean): Format the cell as text in advance (or the entire column). Try to paste the invoice number. I get a popup from calk asking how to treat the number: select language, detect special numbers such as dates. Hit enter. Done. I'll have to do it this way. - -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" (Minas Tirith)) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iF4EAREIAAYFAlXiaCsACgkQja8UbcUWM1wxEwD/duTWkjFvb0GR3CHQOsIcX8zs WHvYQNvPmEXoQfJ8agEBAIdeFt+y3Pgz9hC6V/UKAu56/D/ul/0MVOnaNGnJNhnx =7FuU -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 30/08/15 04:19, Carlos E. R. wrote:
It is an extra operation.
Compare:
Select number in PDF. Copy to clipboard. Go to Calc. Press Ctrl-V. Done.
To:
Select number in PDF. Copy to clipboard. Go to Calc. Press F2, then ' or ", then Ctrl-V. Done.
Paste multiple items? Impossible.
Or (which is what you mean):
Format the cell as text in advance (or the entire column). Try to paste the invoice number. I get a popup from calk asking how to treat the number: select language, detect special numbers such as dates. Hit enter. Done.
I'll have to do it this way.
If I format the cells as text first, I no longer get that popup on every paste, I was only getting it when cells were formatted as standard numbers. That's on LO 4.1.6.2, oS 13.1. gumb -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/29/2015 10:19 PM, Carlos E. R. wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 2015-08-30 03:47, Patrick Shanahan wrote:
* Carlos E. R. <> [08-29-15 21:42]:
Format the cells as text, after all, the invoice number is just a place holder. You are not going to do calculations with it. There should be no rounding with a number as text.
It is an extra operation.
Compare:
Select number in PDF. Copy to clipboard. Go to Calc. Press Ctrl-V. Done.
To:
Select number in PDF. Copy to clipboard. Go to Calc. Press F2, then ' or ", then Ctrl-V. Done.
Paste multiple items? Impossible.
Or (which is what you mean):
Format the cell as text in advance (or the entire column). Try to paste the invoice number. I get a popup from calk asking how to treat the number: select language, detect special numbers such as dates. Hit enter. Done.
I'll have to do it this way.
Is the entire column "Invoice Number" if yes then format the column as text. Once and done. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/29/2015 09:41 PM, Carlos E. R. wrote:
But it is a XXI century computer and software, with 64 bit CPU, it should be able to handle big numbers as numbers.
That's a joke, right? I hope. UNIX back in the PDP-11 days of the 1970s had a indefinite precision integer package. Try 'bc', or if you prefer, 'dc' for the user level implementations. RTFM. Many scripting languages, Ruby, gawk, Python, Perl with theMath::BigInt core module, PHP with a library module, Java with the BigInteger class, LISP - of course, and every compiled language has library modules. I'm pretty sure the machine of the 1940s used for the Manhattan Project calculations had similar. I can't imagine the calculations for space-flight of the 1960s used only the machine precision. The techniques of indefinite precision are available for calculations on a an abacus. You don't need a 64-but CPU, you don't need to be in the 21st century, You just need the right algorithm. Your question should be "If so many UNIX/Linux scripting languages and tools have indefinite precision arithmetic, why isn't this available in LO Calc?" https://en.wikipedia.org/wiki/Arbitrary-precision_arithmetic -- A: Yes. > Q: Are you sure? >> A: Because it reverses the logical flow of conversation. >>> Q: Why is top posting frowned upon? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 08/29/2015 08:50 PM, Carlos E. R. wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
Hi,
I have to enter long numbers in 20150630xxxx75579OO LO CALC. Like "20150630xxxx75579", wich is an invoice number. It gets rounded to 2,01506300101756E+016, and displayed as "20150630xxxx76000", which is obviously the wrong invoice.
How do I tell CALC to use Integers, not Reals?
The numbers are not made by me, so no, I can't use shorter numbers. They are copy pasted from PDF files by me.
I'm using libreoffice-calc-4.4.5.2-1.1.x86_64 in oS 13.1
Set the cell to text instead of numeric content. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 2015-09-01 16:00, Ken Schneider - openSUSE wrote:
On 08/29/2015 08:50 PM, Carlos E. R. wrote:
Set the cell to text instead of numeric content.
Yes, that's what I'm doing, but it should be possible to do long integer arithmetic if so wanted. Also the thing did not warn that it was doing rounding because the input exceeded capacity. - -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" (Minas Tirith)) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iF4EAREIAAYFAlXlvTUACgkQja8UbcUWM1znPwD9H4CrTYn6bRspBYe1oVA25TR1 E7Evr6+LEg4BmOos3HIA/1xqUkVMwfjdSsMwhddSYu23ZOvaMr16L9VytEX99whz =zIpl -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (6)
-
Anton Aylward -
Carlos E. R. -
Carlos E. R. -
gumb -
Ken Schneider - openSUSE -
Patrick Shanahan