Feature #5284

"% done" should provide data in text form too

Added by Alex Last about 8 years ago. Updated about 1 month ago.

Status:NewStart date:2010-04-09
Priority:NormalDue date:
Assignee:-% Done:


Category:Issues list
Target version:Candidate for next major release


I see "Issues list" page can have "% done" field, which shows info as a progress bar. This looks nice, but I also need to be able to import redmine data into other programs like Microsoft Excel.
Unfortunately, Microsoft Excel 2003 shows no values in imported column "% Done". I assume this is because the info in not provided in text format when Excel parses URL like http://demo.redmine.org/projects/ace/issues

is it possible to provide text info for "% done" field in this web page in addition to nice green "progress" bar? This would be really helpful to load tasks into excel and be able to use Excel calculations for remaining time and other parameters.

import_from_web-1.PNG (49.6 KB) Alex Last, 2010-04-09 20:50

import_from_web-2.PNG (275 KB) Alex Last, 2010-04-09 20:50

percent_done_is_empty_on_import_using_url.PNG (25 KB) Alex Last, 2010-04-09 20:50

percent-done-with-number@2x.png (25.5 KB) Go MAEDA, 2018-04-03 13:06


#2 Updated by Alex Last about 8 years ago

what I actually need to do is to estimate "remaining time" for all tasks for a particular target version.
If I could show "remaining time" column on "Issues list" page and then import it into Excel the same way - this would solve my problem and I would not really need text value for "% done" column (although I'd recommend to provide it there anyway to simplify redmine integration with all kinds of external tools, which can grep data from redmine web URLs).

#3 Updated by Go MAEDA 11 months ago

  • Category set to Issues list

#4 Updated by Mizuki ISHIKAWA about 1 month ago

Issues/show has "% done" information next to the progress bar.
I would like to confirm the "% done" information on the Issues list as well.
This change is a very small change, so no one will be confused.

You can implement this feature by making the following changes.

diff --git a/app/helpers/queries_helper.rb b/app/helpers/queries_helper.rb
index 9d3f2468e..40c481134 100644
--- a/app/helpers/queries_helper.rb
+++ b/app/helpers/queries_helper.rb
@@ -221,7 +221,7 @@ module QueriesHelper
     when :last_notes
       item.last_notes.present? ? content_tag('div', textilizable(item, :last_notes), :class => "wiki") : ''
     when :done_ratio
-      progress_bar(value)
+      progress_bar(value, :legend => "#{value}%")
     when :relations
         value.to_s(item) {|other| link_to_issue(other, :subject => false, :tracker => false)}.html_safe,

#5 Updated by Go MAEDA about 1 month ago

Mizuki ISHIKAWA wrote:

Issues/show has "% done" information next to the progress bar.

Here is a screenshot of Mizuki's patch.

#6 Updated by Go MAEDA about 1 month ago

  • Target version set to Candidate for next major release

Also available in: Atom PDF