Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041747Openbravo ERPA. Platformpublic2019-09-04 12:152019-09-10 10:29
immediatemajorhave not tried
Production - QA Approved
3.0PR19Q3 [^]
0041747: Negative values have string format when they are exported to csv file
When the data of any grid is exported as csv using the button "Export to Spreadsheet" the negative values have a prefix "tabulation Character" this produces that the spreadsheet program format the field as text. This causes that these values don't be used to do autosum or in formulas.

Also, if the spreadsheet program has the tab character as separator the field with negative value have a shift to the right column

This prefix character was introduced in the issue [^]
- Export any grid than contains negative values
- Open the CSV file with a spreadsheet program

a.- Leave the tab character selected as a separator
- Result all the values negatives will be a shift to the right column

b.- Deselect the tab character
- Do an Autosum with all the column that contains negative values
- Save the value
- Edit any negative value erasing the tab character
- Do the autosum again
- Result if different.
No tags attached.
depends on backport 00417543.0PR19Q3.1 closed alostale Negative values have string format when they are exported to csv file 
caused by defect 0040647 closed alostale escape formulas when exporting csv 
png Screenshot from 2019-09-04 12-03-00.png (24,753) 2019-09-04 12:15

png Screenshot from 2019-09-04 12-04-12.png (12,856) 2019-09-04 12:15
Issue History
2019-09-04 12:15salvador_campanellaNew Issue
2019-09-04 12:15salvador_campanellaAssigned To => platform
2019-09-04 12:15salvador_campanellaFile Added: Screenshot from 2019-09-04 12-03-00.png
2019-09-04 12:15salvador_campanellaModules => Core
2019-09-04 12:15salvador_campanellaResolution time => 1569362400
2019-09-04 12:15salvador_campanellaTriggers an Emergency Pack => No
2019-09-04 12:15salvador_campanellaFile Added: Screenshot from 2019-09-04 12-04-12.png
2019-09-04 12:18PracticsIssue Monitored: Practics
2019-09-04 12:20PracticsIssue End Monitor: Practics
2019-09-04 12:20PracticsIssue Monitored: Practics
2019-09-05 08:27alostaleAssigned Toplatform => alostale
2019-09-05 08:27alostaleRelationship addedcaused by 0040647
2019-09-05 08:30alostaleReview Assigned To => caristu
2019-09-05 08:30alostaleRegression level => Production - QA Approved
2019-09-05 08:30alostaleRegression date => 2019-04-26
2019-09-05 08:30alostaleRegression introduced in release => 3.0PR19Q3
2019-09-05 08:30alostaleRegression introduced by commit => [^]
2019-09-05 08:30alostalePrioritynormal => immediate
2019-09-05 08:32alostaleStatusnew => scheduled
2019-09-05 08:47hgbotCheckin
2019-09-05 08:47hgbotNote Added: 0114405
2019-09-05 08:47hgbotStatusscheduled => resolved
2019-09-05 08:47hgbotResolutionopen => fixed
2019-09-05 08:47hgbotFixed in SCM revision => [^]
2019-09-05 18:16hudsonbotCheckin
2019-09-05 18:16hudsonbotNote Added: 0114427
2019-09-10 10:29caristuNote Added: 0114486
2019-09-10 10:29caristuStatusresolved => closed
2019-09-10 10:29caristuFixed in Version => 3.0PR19Q4

2019-09-05 08:47   
Repository: erp/devel/pi
Changeset: 5879f2488432819dc36b197421e94aca5f804314
Author: Asier Lostalé <asier.lostale <at>>
Date: Thu Sep 05 08:47:04 2019 +0200
URL: [^]

fixed bug 41747: negative numeric values exported as string in csv

  Whenever a value is exported to csv, it is prepended a tab if it starts with
  any character that can be used for formulas (issue 0040647) in order to prevent
  formula injection. This causes negative numeric values to be also escaped being
  treated as strings.

  Numeric values don't require to be escaped at all as they are cannot be crafted
  for formula injection.

M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/
2019-09-05 18:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test
2019-09-10 10:29   
Reviewed + tested OK.