[#JRA-7439] Excel view "loses" number/date formatting - excel ends up seeing numbers/dates as text (so wont work in formulas)

JIRA

Excel view "loses" number/date formatting - excel ends up seeing numbers/dates as text (so wont work in formulas)

Created: 25/Jul/05 01:39 PM Updated: 30/Jul/06 07:34 PM

Component/s:

Issue navigator

Affects Version/s:

3.2.3

Fix Version/s:

3.3.3

Time Tracking:

Not Specified

Issue Links:

Part

This issue is incorporated by:

~~JRA-7554~~ excel output can't be sorted when components is a column

Participants:	Dylan Etkin [Atlassian], Mark Chaimungkalanont [Atlassian], Nick Menere [Atlassian] and Nick Minutello
Since last comment:	3 years, 7 weeks, 4 days ago
Resolution Date:	12/Oct/05 08:02 PM
Labels:

Description

« Hide

1) At some point in the page, one issue ends up spanning multiple excel rows... (merged cells)
2) After that, all the numbers/dates are stored as text, rather than numbers (so they dont work in formulas)

We are using Excel 2002.
With Ppen Office, The spanning problem still seems to happen - but it seems to work ok anyway..

If you log into jira as huline with our data, and go to this filter and export as excel, you will note 2 things:
http://jira.london.echonet/secure/IssueNavigator.jspa?mode=hide&requestId=11786

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Dylan Etkin [Atlassian] added a comment - 27/Jul/05 01:33 AM

Hi Nick,
I don't seem to be able to resolve jira.london.echonet. What is the name of the filter that is causing this? Scott has your data running so I can probably recreate the problem from there. If the issue does not span rows does excel interpret the numbers/dates correctly. Since we just generate html and excel interprets that I thought that excel would see all fields as text.
Thanks,
Dylan

[ Permlink | « Hide ]

Nick Minutello added a comment - 27/Jul/05 04:10 AM

Maybe I wasnt so clear...
Login as "huline", and replace jira.london.echonet with the host our data is running on...

http://<your host here>/secure/IssueNavigator.jspa?mode=hide&requestId=11786

I guess 11786 is the saved filter id?

I will get you the name if you need it....

>> If the issue does not span rows does excel interpret the numbers/dates correctly.
Yes

>> Since we just generate html and excel interprets that I thought that excel would see all fields as text.
No, Excel is smarter than that...

My guess is that you have to get rid of the <p/> 's in the cell data - or excel interpretes that as a new row...

[ Permlink | « Hide ]

Dylan Etkin [Atlassian] added a comment - 27/Jul/05 11:12 PM

Hi Nick,
I imported your data and there is no filter with id 11786 in the database. I used your bnpparibas-london-27Jul05-sphere.sql data. There is another bug that exists in 3.2.3 that can be found here:
http://jira.atlassian.com/browse/JRA-7470
What is happening is that we are no longer html escaping the text and this will obviously mess-up excels rendering. Do any of the issues you are viewing have html in a field that is being exported? A fix for this issue will make it into 3.3.
If this is not what is happening can you come back with the filter name or where I can see what is going on? Perhaps you could attach the generated .xls to start.

Thanks,
Dylan

[ Permlink | « Hide ]

Nick Menere [Atlassian] added a comment - 13/Sep/05 08:36 PM

Nick,

There was another issue relating to the multiple row problem. This was fixed for 3.3.1 and a patch applied to ~~JRA-7554~~.

Does this solve your problem?

I am not sure if the second part ever worked.

Cheers,
Nick

[ Permlink | « Hide ]

Dylan Etkin [Atlassian] added a comment - 05/Oct/05 08:05 PM

Hi Nick,
Can we resolve this issue, is it fixed for you? Let me know.

Thanks,
Dylan

[ Permlink | « Hide ]

Mark Chaimungkalanont [Atlassian] added a comment - 12/Oct/05 08:02 PM

Nick,

~~JRA-7554~~ should fix your problem. You can reopen or raise a new issue if you have further specific problems with this.

Cheers

Mark C