Forums » General Discussion

Thread: Spreadsheet export


Permlink Replies: 1 - Pages: 1 - Last Post: Apr 27, 2010 12:10 PM by: Dwight Threads: [ Previous | Next ]
cgwchv
Spreadsheet export
Posted: Apr 16, 2010 12:58 PM
  Click to reply to this thread Reply

I just exported a result grid to Excel only to find all the bit(1) column display the opposite value of what I expected in the spreadsheet.

If the bit(1) field is set (displays with a checked box in the result grid), I would expect a value of TRUE in the spreadsheet and FALSE if not checked. I am getting the exact opposite.

Is this the intended design? or is this a bug?

Thank you,

Chris






Dwight


Posts: 68
Registered: 8/22/07
RE: Spreadsheet export
Posted: Apr 27, 2010 12:10 PM   in response to: cgwchv
  Click to reply to this thread Reply







Chris,

This is a problem with a third-party package that we use to perform our exports
to Excel. There is a work-around for it. Try exporting to a running instance of
Excel.

Dwight




Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums