× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2012-04-09T18:52:53Z  · last modified 2012-04-09T20:04:39Z

Aspose bugs on Sorting on View as Excel and Save as Excel


Dev
Niels Gron
NielsGron
QA swissarmyknife(*)
Priority Major
Complexity Unknown
Component Q Analyzer - Grid Results
Version 10.0

 

Product: Aqua Data Studio
Version: 10.0.8_05
Build #: 26176
 
Bug 1 - NO Sort for NULL values in Excel
 
1.  Connect to SQL Server 2012 Denali and execute the below query
Select * from Orders
2. Sort the ShippedDate Column, so that it has got null values on top
3. Click on View as Spreadsheet button
 
The excel opens up and doest have the Sorted order
 
Bug 2
 
Save the above result set as Excel using Right Click on Cell-->Save Results , Results as Excel 2007 Worksheet
If you open the saved excel, the sort order is not saved 
 
 
Bug 3  Rearrange the columns, do a Sort
 
1. select * from Orders
2. Drag ShipCountry as the first column
3. sort descending 
4. click quick excel button
5. The resulting excel doesn't seem to match anything you view in the grid
 
 
Bug 4
 
Save the above result set as Excel using Right Click on Cell-->Save Results , Results as Excel 2007 Worksheet
If you open the saved excel, the sort order is not saved 
Column Order is incorrect
 
 
 
 
 
 
4 attachments
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #6759
Closed
Fixed
Resolved 2012-04-09T19:12:35Z
 
 
Completion
No due date
Fixed Build 10.0.8_06
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017