Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040647
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2019-04-18 15:362019-05-21 15:16
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q3
StatusclosedFix in branchFixed in SCM revision298602067263
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040647: escape formulas when exporting csv

DescriptionWhen exporting to cvs, if a value starts with equals it should be escaped not to treat it as a formula when opened with as spreadsheet.
Steps To Reproduce-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0040646 closednonofrancisco use proper html escape in old selectors 
causes defect 0041747pi closedalostale Negative values have string format when they are exported to csv file 

-  Notes
(0111210)
hgbot (developer)
2019-04-18 15:57

Repository: erp/devel/pi
Changeset: 2986020672639f14f8c2cbd9d66e5d9577b38d10
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 18 15:42:05 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2986020672639f14f8c2cbd9d66e5d9577b38d10 [^]

fixed bug 40647: escape formulas when exporting csv

  When exporting to csv:
    - If value starts with equals, escape it so that it is not treated as a formula
    - Use JDK's String.replace instead of OB's

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
---
(0111353)
hgbot (developer)
2019-04-26 10:27

Repository: erp/devel/pi
Changeset: cbb150e17b8b69ad6f243c526ba64ef744ed8ba2
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Apr 26 10:23:56 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cbb150e17b8b69ad6f243c526ba64ef744ed8ba2 [^]

related to issue 40647: escape formulas when exporting csv

  - Use tab instead of quoute to escape forumulas as latter is not visible
  - Escape also other characters that prefix formulas (+,-,@)

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
---
(0111363)
caristu (developer)
2019-04-26 15:09

Code reviewed + tested OK
(0111990)
hudsonbot (developer)
2019-05-21 15:16

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9b8f37d9d85e [^]
Maturity status: Test
(0112002)
hudsonbot (developer)
2019-05-21 15:16

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9b8f37d9d85e [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2019-04-18 15:36 alostale New Issue
2019-04-18 15:36 alostale Assigned To => platform
2019-04-18 15:36 alostale Modules => Core
2019-04-18 15:36 alostale Triggers an Emergency Pack => No
2019-04-18 15:37 alostale Review Assigned To => caristu
2019-04-18 15:37 alostale Assigned To platform => alostale
2019-04-18 15:55 alostale Relationship added related to 0040646
2019-04-18 15:57 hgbot Checkin
2019-04-18 15:57 hgbot Note Added: 0111210
2019-04-18 15:57 hgbot Status new => resolved
2019-04-18 15:57 hgbot Resolution open => fixed
2019-04-18 15:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2986020672639f14f8c2cbd9d66e5d9577b38d10 [^]
2019-04-26 10:27 hgbot Checkin
2019-04-26 10:27 hgbot Note Added: 0111353
2019-04-26 15:09 caristu Note Added: 0111363
2019-04-26 15:09 caristu Status resolved => closed
2019-04-26 15:09 caristu Fixed in Version => 3.0PR19Q3
2019-05-21 15:16 hudsonbot Checkin
2019-05-21 15:16 hudsonbot Note Added: 0111990
2019-05-21 15:16 hudsonbot Checkin
2019-05-21 15:16 hudsonbot Note Added: 0112002
2019-09-05 08:27 alostale Relationship added causes 0041747


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker