Bug 144584 - Try to copy a number of 0.#### eg. 0.617 from somewhere eg. webpage, and it is pasted as 617
Summary: Try to copy a number of 0.#### eg. 0.617 from somewhere eg. webpage, and it i...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-18 10:01 UTC by elias estatistics
Modified: 2021-09-18 13:43 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description elias estatistics 2021-09-18 10:01:44 UTC 
Is it a bug? I consider it as a bug! 

Try to copy a number of 0.#### eg. 0.617 from somewhere eg. webpage, and it is pasted as 617.

Try to copy eg. 0.0006 from somewhere into calc and it is pasted as 6.


Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: d5ade739771ddf06cc7ee6d4af15672bfcf09ed6
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: el-GR (el_GR.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-09-01_02:56:07
Calc: threaded
Comment 1 elias estatistics 2021-09-18 10:14:47 UTC 
Go into  eg.https://www.ncbi.nlm.nih.gov/pmc/articles/PMC8169780/

Copy any table with p values into calc withou p values loosing "0.000###".

Options copy as textnumber/formula do nothing. 

Only work --> Paste Speical ---> Paste Special --> Unformatted text or imported text. 

Maybe an enhancement to do that in a much fewer steps? (eg. Paste special --> Unformatted text?) 

I think people that copy data tables in calc with such numbers will be many!
Comment 2 Mike Kaganski 2021-09-18 11:16:12 UTC 
(In reply to elias estatistics from comment #0)
> Try to copy a number of 0.#### eg. 0.617 from somewhere eg. webpage, and it
> is pasted as 617.
> 
> Try to copy eg. 0.0006 from somewhere into calc and it is pasted as 6.
> 
> Locale: el-GR (el_GR.UTF-8); UI: en-US

This is not a bug. Citing Wikipedia [1]:

> Countries where a comma "," is used as decimal separator include:
> ... Greece

[1] https://en.wikipedia.org/wiki/Decimal_separator#Countries_using_decimal_comma
Comment 3 elias estatistics 2021-09-18 13:43:07 UTC 
OK! :) Sorry for the incovinience!