Bug 100494 - imported percentage from csv are not properly recognize as percentage
Summary: imported percentage from csv are not properly recognize as percentage
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-20 07:16 UTC by remyD
Modified: 2017-02-01 00:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
generated csv values. (25.79 KB, text/x-log)
2016-06-20 07:16 UTC, remyD 		Details
Screenshot with import options (50.81 KB, image/png)
2016-06-20 20:58 UTC, m_a_riosv 		Details
imported and manually added percentage. (169.60 KB, image/png)
2016-06-22 07:56 UTC, remyD 		Details
View All 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 remyD 2016-06-20 07:16:40 UTC 
Created attachment 125752 [details]
generated csv values.

Hello,

This problem is exactly the same as the number 94880 but the difference is that the solution provided to me in 94880 doesn't work here.

To summarize, I have generate a csv file where there are percentage values.
If I import the file, this columns is not detected as percentage even if I tick "Detect special numbers" on import.

csv file attached.
I have probably missed something :(
Comment 1 m_a_riosv 2016-06-20 20:58:31 UTC 
Created attachment 125783 [details]
Screenshot with import options

With the attached screenshot options, works fine for me.
Comment 2 remyD 2016-06-22 07:56:27 UTC 
Created attachment 125822 [details]
imported and manually added percentage.
Comment 3 remyD 2016-06-22 07:59:34 UTC 
My explanation was probably wrong.
The values from the file are well imported, the problem is that I can't do anything with them because they are not recognized as percentage(cf attachment 125822 [details] ).
I have to rewrite the cell to make it usable in a diagram for example. The alignment changes when I am doing that.
Comment 4 m_a_riosv 2016-06-22 14:26:15 UTC 
Have you seen in the import screenshot there is English UK as language (my language is Spanish), it is to have dot as decimal separator for the imported file, you can set up also, with French as language, clicking on the head of percent column and selecting in Column type US English.
Comment 5 QA Administrators 2017-01-31 00:29:39 UTC 
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 INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/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

MassPing-NeedInfo-Ping-20170131