Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008595 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2009-04-08 17:09 | 2009-05-14 16:13 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.40MP4 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 3c759af89c69 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008595: Number cells exported to excel are not recognised as numeric values | |||||||
| Description | In Report General Ledger and Report General Legder Journal, if information is exported to a xls file, then numeric values are recognised by Strings instead of Numbers. That makes the exportation useless, because you cannot do any arithmetic operations whithin the file. Keep in mind that the value should also maintain the number format (="#,##0.00", for example) in case it is needed. This happens also in every jasper report of the application which wants to be exported to excel. This is very common and a feature requested by almost all customers. | |||||||
| Steps To Reproduce | 1. Go to Financial Management || Accounting || Analysis Tools || General Ledger Journal 2. Click on HTML format and see the results 3. Click on "export to excel" button. 4. Save the file, open it and try to sum two values 5. These values are not recognized as numbers, but Strings. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0015763) hgbot (developer) 2009-04-27 11:43 |
Repository: erp/stable/2.40 Changeset: 3c759af89c69436dea895e09d50b148bf0602d17 Author: Iván Perdomo <ivan.perdomo <at> openbravo.com> Date: Mon Apr 27 11:43:23 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/3c759af89c69436dea895e09d50b148bf0602d17 [^] Fixes issue 8595: Added detect cell type when exporting to excel --- M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java --- |
|
(0016357) psarobe (manager) 2009-05-14 16:13 |
Only the chance to do it is done. The you have to change the template |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-16 12:23 | psarobe | Type | defect => backport |
| 2009-04-16 12:23 | psarobe | fix_in_branch | => 2.40 |
| 2009-04-23 12:31 | gorkaion | Assigned To | gorkaion => iperdomo |
| 2009-04-27 11:43 | hgbot | Checkin | |
| 2009-04-27 11:43 | hgbot | Note Added: 0015763 | |
| 2009-04-27 11:43 | hgbot | Status | scheduled => resolved |
| 2009-04-27 11:43 | hgbot | Resolution | open => fixed |
| 2009-04-27 11:43 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/3c759af89c69436dea895e09d50b148bf0602d17 [^] |
| 2009-05-10 19:37 | psarobe | Fixed in Version | => 2.40MP4 |
| 2009-05-14 16:13 | psarobe | Note Added: 0016357 | |
| 2009-05-14 16:13 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |