| Summary: | EDITING Pasted space-padded numbers not recognized as numbers | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Adrian Wilkins <adrian.wilkins+freedesktop> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | major | CC: | jbfaure |
| Priority: | high | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
example data
screenshot after pasting screenshot after formatting to Number |
||
|
Description
Adrian Wilkins
2011-01-10 02:48:18 UTC
I've already fixed this. Please test the next RC to see if this issue has been resolved. I'll keep this in the meantime. Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian This is still a problem. If I paste this 15.8278481013 2.4169741697 6.301183432 19.1995104039 5.1121212121 23.4404145078 4.3898809524 6.2704691812 3.1075425791 1.5785714286 8.3517835178 6.2253521127 7.2341954023 15.8515228426 4.1090909091 4.6382978723 into Calc, the cells are transformed into text and no calculations can be made with them, etc. Same if a text/csv file with this content is imported into Calc. Strangely enough, when you just highlight the cells A1:B8 and the go Format Cells > Numbers, then it shows that these cells are of the category Text, which doesn't make sense. However, even when you change their category to Number or All, it doesn't do anything, still no summing. Okay, I am no Calc expert, but: How should I insert this?? Created attachment 66183 [details]
example data
(In reply to comment #7) > Okay, I am no Calc expert, but: How should I insert this?? Either - copy those numbers - go to Calc - press CTRL-SHIFT-V (for paste special) - choose tabs and spaces as delimiters and tick "Merge delimiters" - click OK Then you have it in Calc and Pivot Tables can't compute means, the sum thingy in the status bar doesn't show sums, ... Or - try to import the attached file into Calc and again Pivot Tables can't compute means, the sum thingy in the status bar doesn't show sums, ... Actually, on Windoze this works fine, but on Ubuntu it doesn't This bug report is useless since nobody specifies the version number of his/her tested build. Please test it in 3.6.1. Since I can't reproduce it in 3.6.1 I'll close it as WORKSFORME. Thanks for adding information. I now know what is wrong. For some Programs "," is the comma, for others "." That means: ISTEXT rwgtreg 1b52gr1d5 12.5 ISNUMBER ,5 1 1,2 200,5 So this is no bug, I am very sorry Created attachment 66497 [details]
screenshot after pasting
With me, it's not the decimal separator thing...
- I am using LibreOffice 3.6.0.2 on Kubuntu 12.04. (It seems to work fine on Win)
- I am using a English US locale where the decimal separator is the period.
- when I copy these three numbers out of this text box:
2.09
2.40
2.12
and paste them into Calc cells B2:B4 with the following settings
- Separated by tab
- Text delimiter = nothing
- Field/column type: Standard
then they are pasted in but
- as you can see in the attachment calc1.png , when the field category is changed to Text
- thus, the summing in the status bar upon highlighting does not work
- cell C5, which computes the average of B2:B4 says Div/0.
This is already annoying enough but if I then change the Category to "Number", then
- the numbering stuff still doesn't work but
- the content of the cells B2:B4 is changed: now the numbers are in there with a single quote preceding them, still rendering them text (see attachment calc2.png).
(i) Why can't I just paste numbers into Calc and have them be recognized as numbers or,
(ii) if Calc is dumb enough to treat them as text although I say Field category: General, why can't I at least get them to work as numbers when I format the cells as numbers and not have a stupid quote in there messing things up?
Created attachment 66498 [details]
screenshot after formatting to Number
No problem in current stable versions. Closing again as WorksForMe. Best regards. JBF |