| Summary: | EDITING: Enhancement request: Cell containing only decimal separator character becomes value 0 when paste cells range as unformatted text | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | webofht-libreofficebugs002 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | enhancement | CC: | LibreOffice, stgohi-lobugs, webofht-libreofficebugs002 |
| Priority: | medium | ||
| Version: | 3.6.4.3 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Sample spreadsheet | ||
Effect is [Reproducible] with Server Installation of "LibreOffice 3.6.5.1 rc” English UI/ English Locale [Build-ID: 5b93205]" {pull date 2013-01-18} on German WIN7 Home Premium (64bit).
You also can reproduce the effect with empty spreadsheet except dots in A1 and A2
and then copy / paste-plain-text A1:B2 to C3
AFAIK (because of a feature request?) 4.0.0.2 has 'Detect special Numbers' on by default, what might explain reporter's observations with this version.
Bug or Feature? I think the paste process sees the "." as ".0"
'Detect special Numbers' option will paste the dots as dots.
We will have to think about that.
@webofht-libreofficebugs002
Thx. for Report!
Such a Problem with a possible decimal separator might be Localization related, so please contribute screenshots of all your language settings.
For me the effect disappears when I change Menu 'Tools -> Options -> Language Settings -> Languages - Locale setting' ro "German"
Additionally we need all your paste plaint text settings (please add to screenshots).
Effect also reproducible with "LibO 4.0.0.2 rc - GERMAN UI / German Locale [Build ID: 5991f37846fc3763493029c4958b57282c2597e)]" {tinderbox: @6, pull time 2013-01-24 07:20(?)} on German WIN7 Home Premium (64bit) with User Profile automatically created form renamed /3 User profile used by 3.6.5.2:
0. New empty spreadseet
1. "," (comma) to A1:A2
2. Select A1:B2
3. <control-c> for Copy
4. Click C3
5. Paste drop-down arrow (Standard toolbar) -> Unformatted text
6. Uncheck 'Detect special Numbers' -> <OK>
>cells with decimal separator strings Pasted become "0"
No more info required. But still question whether might be Feature (In reply to comment #3) > No more info required. > > But still question whether might be Feature In that case, I think it is an enhancement request. (LibreOffice 3, not 4) Checking 'Detect special Numbers' makes . become . after pasting. Unchecking 'Detect special Numbers' makes . become 0 after pasting. My locale setting is English (USA). 1) Checking 'Detect special Numbers' should be the default. 2) 'Detect special Numbers' sounds misleading. The . is not a number. It is a special character or a symbol. Not reproducible with LO 4.1.4.2 (Win7 Home, 64bit) Can anybody still confirm this issue in the latest release of LO? Otherwise, I would propose to close this issue. (In reply to comment #5) > Not reproducible with LO 4.1.4.2 (Win7 Home, 64bit) > > Can anybody still confirm this issue in the latest release of LO? Otherwise, > I would propose to close this issue. With LibreOffice Version: 4.2.0.4 (Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71), this issue should be closed because it is not reproducible. Copying the dot and pasting as unformatted text does not create the 0 response. Please close. Thanks. Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of FDO |
Created attachment 73778 [details] Sample spreadsheet Problem description: Copy some cells containing the dot (.) but paste the cells as unformatted text. The dot becomes 0 in LibreOffice 3.6.4.3. Steps to reproduce: 1. The operating system used is Linux debian 2.6.32-5-686 #1 SMP Sun Sep 23 09:49:36 UTC 2012 i686 GNU/Linux. 2. The LibreOffice version involved is: - LibreOffice Version 3.6.4.3 (Build ID: 2ef5aff) (LO3.6.4.3) 3. (This issue does _not_ affect LibreOffice Version 4.0.0.2 (Build ID: 408fe71bd18616c467b3dcd7ab6756528ffcae2).) 4. Type 1 in A1. Type 2 in A2. 5. Type . in B1. Type . in B2. 6. Select A1:B2. 7. Press Copy. (Standard toolbar) 8. Select A3. 9. Press Paste drop-down arrow (Standard toolbar) -> Unformatted text -> OK (If you type . in C1 and select this cell _only_ and select C2 and repeat step 9, you will get the .. Please follow step 6 to reproduce this issue. ) Current behavior: . becomes 0. Expected behavior: . should be .. Operating System: Debian Version: 3.6.4.3 release