[jira] Created: (DISPL-506) Wrong Sorting done, when exported to pdf or excel

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (DISPL-506) Wrong Sorting done, when exported to pdf or excel

JIRA jira@codehaus.org
Wrong Sorting done, when exported to pdf or excel
-------------------------------------------------

                 Key: DISPL-506
                 URL: http://jira.codehaus.org/browse/DISPL-506
             Project: DisplayTag
          Issue Type: Sub-task
          Components: Export
    Affects Versions: 1.1.1, 1.1
            Reporter: praveen
            Priority: Critical
         Attachments: bug_export_sort.txt

Here the number of columns when viewed on html media is different than when viewed under pdf or excel. Sorting is always done on the html columns. When the table gets exported to pdf or excel with more columns than what we see in html output, it sorts incorrectly based on the column numbers of html output.

 <display:table name="test" export="true" sort="list" pagesize="8">
    <display:column media="excel pdf" property="city" title="CITY" sortable="true" headerClass="sortable" />
    <display:column property="project" title="PROJECT" group="2" sortable="true" headerClass="sortable" />
    <display:column property="amount" title="HOURS" sortable="true"/>
    <display:column property="task" title="TASK" />
  </display:table>

In the above example,
In HTML output, I have 3 columns project, amount and task. If I click on amount ( column number is 1) sorting is done based on amount column
when we click export, the same column number goes to the Table Model to get the table sorted based on the same column number. But now in excel or pdf we have 4 columns and column number 1 represents to project. So now the table is sorted based on the project column title. This is a bug.



--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
displaytag-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (DISPL-506) Wrong Sorting done, when exported to pdf or excel

JIRA jira@codehaus.org

    [ http://jira.codehaus.org/browse/DISPL-506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=174417#action_174417 ]

Steven Revill commented on DISPL-506:
-------------------------------------

Hi,

This happens in 1.2 also.

Any work around of this? Any progress on the fix?

Thanks!
Steve

> Wrong Sorting done, when exported to pdf or excel
> -------------------------------------------------
>
>                 Key: DISPL-506
>                 URL: http://jira.codehaus.org/browse/DISPL-506
>             Project: DisplayTag
>          Issue Type: Sub-task
>          Components: Export
>    Affects Versions: 1.1, 1.1.1
>            Reporter: praveen
>            Priority: Critical
>         Attachments: bug_export_sort.txt
>
>
> Here the number of columns when viewed on html media is different than when viewed under pdf or excel. Sorting is always done on the html columns. When the table gets exported to pdf or excel with more columns than what we see in html output, it sorts incorrectly based on the column numbers of html output.
>  <display:table name="test" export="true" sort="list" pagesize="8">
>     <display:column media="excel pdf" property="city" title="CITY" sortable="true" headerClass="sortable" />
>     <display:column property="project" title="PROJECT" group="2" sortable="true" headerClass="sortable" />
>     <display:column property="amount" title="HOURS" sortable="true"/>
>     <display:column property="task" title="TASK" />
>   </display:table>
> In the above example,
> In HTML output, I have 3 columns project, amount and task. If I click on amount ( column number is 1) sorting is done based on amount column
> when we click export, the same column number goes to the Table Model to get the table sorted based on the same column number. But now in excel or pdf we have 4 columns and column number 1 represents to project. So now the table is sorted based on the project column title. This is a bug.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
displaytag-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (DISPL-506) Wrong Sorting done, when exported to pdf or excel

JIRA jira@codehaus.org
In reply to this post by JIRA jira@codehaus.org

    [ http://jira.codehaus.org/browse/DISPL-506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=181673#action_181673 ]

John Källström commented on DISPL-506:
--------------------------------------

I was also struck by this behaviour in 1.2. I'll try to do a work-around and add some sort of "hidden" column to make the number of columns match between different media settings.

Any other clever hints or tips would be much appreciated.

Thanks!
John

> Wrong Sorting done, when exported to pdf or excel
> -------------------------------------------------
>
>                 Key: DISPL-506
>                 URL: http://jira.codehaus.org/browse/DISPL-506
>             Project: DisplayTag
>          Issue Type: Sub-task
>          Components: Export
>    Affects Versions: 1.1, 1.1.1
>            Reporter: praveen
>            Priority: Critical
>         Attachments: bug_export_sort.txt
>
>
> Here the number of columns when viewed on html media is different than when viewed under pdf or excel. Sorting is always done on the html columns. When the table gets exported to pdf or excel with more columns than what we see in html output, it sorts incorrectly based on the column numbers of html output.
>  <display:table name="test" export="true" sort="list" pagesize="8">
>     <display:column media="excel pdf" property="city" title="CITY" sortable="true" headerClass="sortable" />
>     <display:column property="project" title="PROJECT" group="2" sortable="true" headerClass="sortable" />
>     <display:column property="amount" title="HOURS" sortable="true"/>
>     <display:column property="task" title="TASK" />
>   </display:table>
> In the above example,
> In HTML output, I have 3 columns project, amount and task. If I click on amount ( column number is 1) sorting is done based on amount column
> when we click export, the same column number goes to the Table Model to get the table sorted based on the same column number. But now in excel or pdf we have 4 columns and column number 1 represents to project. So now the table is sorted based on the project column title. This is a bug.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
_______________________________________________
displaytag-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (DISPL-506) Wrong Sorting done, when exported to pdf or excel

JIRA jira@codehaus.org
In reply to this post by JIRA jira@codehaus.org

    [ https://jira.codehaus.org/browse/DISPL-506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=280290#comment-280290 ]

software programmer commented on DISPL-506:
-------------------------------------------

Hi,I am having the same issue. Any progress or any work-around guys?


Thanks,
Bob

> Wrong Sorting done, when exported to pdf or excel
> -------------------------------------------------
>
>                 Key: DISPL-506
>                 URL: https://jira.codehaus.org/browse/DISPL-506
>             Project: DisplayTag
>          Issue Type: Sub-task
>          Components: Export
>    Affects Versions: 1.1, 1.1.1
>            Reporter: praveen
>            Priority: Critical
>         Attachments: bug_export_sort.txt
>
>
> Here the number of columns when viewed on html media is different than when viewed under pdf or excel. Sorting is always done on the html columns. When the table gets exported to pdf or excel with more columns than what we see in html output, it sorts incorrectly based on the column numbers of html output.
>  <display:table name="test" export="true" sort="list" pagesize="8">
>     <display:column media="excel pdf" property="city" title="CITY" sortable="true" headerClass="sortable" />
>     <display:column property="project" title="PROJECT" group="2" sortable="true" headerClass="sortable" />
>     <display:column property="amount" title="HOURS" sortable="true"/>
>     <display:column property="task" title="TASK" />
>   </display:table>
> In the above example,
> In HTML output, I have 3 columns project, amount and task. If I click on amount ( column number is 1) sorting is done based on amount column
> when we click export, the same column number goes to the Table Model to get the table sorted based on the same column number. But now in excel or pdf we have 4 columns and column number 1 represents to project. So now the table is sorted based on the project column title. This is a bug.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
displaytag-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/displaytag-devel