Project

General

Profile

Support #2394

Check Export to Excel

Added by Oleksii Kurasov over 8 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Urgent
Target version:
Start date:
12/22/2016
Due date:
12/23/2016
% Done:

0%


Description

I found these problems in the exported excel :

1) Parameters: (see highlights attached)

a) Remove the “Regular order period” and its date, and replace it by the “End date of the quantification” and its date.

b) Include the “Quantification period” and its duration.

2) Change the title of the sheet from “Stocks and orders” to “Stock of medicines”. (see highlights attached)

3) Summary: (see highlights attached)

a) Include the merged row “On the inventory date” and its date.

b) Include the word “period” at the end of the accelerated order column

4) Quantity and costs: (see highlights attached)

a) Move the comment box to be displayed at the top of the page (it isn’t well visible now).

5) All values at “Quantity and Costs” and “Additional costs” tabs have been exported and displayed with separators for hundreds and thousands as apostrophe punctuation marks (') instead of comma (,) in the English format.

6) The “Schedule” sub-tab has not been exported at all. If we won’t have time to make it to the version 4.0, at least users would be able to save and print with the right button of the mouse as for the graphs.

History

#1 Updated by Oleksii Kurasov over 8 years ago

  • Due date set to 12/22/2016
  • Assignee set to Oleksii Kurasov
  • Priority changed from Normal to Urgent

#2 Updated by Andualem Oumer over 8 years ago

Many issues have not been fixed yet

#3 Updated by Oleksii Kurasov over 8 years ago

  • Status changed from New to In Progress

#4 Updated by Oleksii Kurasov over 8 years ago

  • Due date changed from 12/22/2016 to 12/23/2016

#5 Updated by Oleksii Kurasov over 8 years ago

  • Status changed from In Progress to Resolved

Please check

All values at “Quantity and Costs” and “Additional costs” tabs have been exported and displayed with separators for >>>hundreds and thousands as apostrophe punctuation marks (') instead of comma (,) in the English format.

All numbers are inherit current Excel number format. I can't check this for US Excel. However for RU and PT it works properly

#6 Updated by Oleksii Kurasov over 8 years ago

  • Assignee changed from Oleksii Kurasov to Andualem Oumer
  • Target version set to Version 4.0

#7 Updated by Andualem Oumer over 8 years ago

  • Status changed from Resolved to Closed

tested and ok now

Also available in: Atom PDF