0008595: Number cells exported to excel are not recognised as numeric values

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0008595

Openbravo ERP

09. Financial management

public

2009-04-08 17:09

2009-05-14 16:13

Reporter

networkb

Assigned To

iperdomo

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

2.40MP4

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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.

Proposed Solution

Additional Information