History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: JRA-9509
Type: Bug Bug
Status: Resolved Resolved
Resolution: Duplicate
Priority: Minor Minor
Assignee: Unassigned
Reporter: Brian Nguyen
Votes: 2
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
JIRA

A text field starting with a minus or plus sign causes problems in Excel

Created: 28/Feb/06 11:40 PM   Updated: 11/Feb/08 07:39 PM
Component/s: Import / Export, Web interface
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Reference
 

Participants: Brian Nguyen and Scott Farquhar [Atlassian]
Since last comment: 91 weeks, 6 days ago
Resolution Date: 11/Feb/08 07:39 PM
Labels:


 Description  « Hide
If you have a text field like 'description' starting with an minus '-' or plus '+' sign, formatting in Excel no longer works.

This is because Jira believes that the fields refer to a number e.g. '-6' but instead sees '-x'. As a result it throws the error "Number Stored as Text" in the next column.

This error will then turn off all formatting in the later Excel cells and you will start to see some strange data. For example, date fields will not be formatted.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Scott Farquhar [Atlassian] - 18/Oct/06 08:45 PM
Perhaps we could just encode the + and - signs using their HTML attributes to prevent this?