Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Display Data Formats in scientific notation


Permlink Replies: 2 - Pages: 1 - Last Post: Mar 6, 2012 1:00 PM Last Post By: pddzaic
pddzaic

Posts: 3
Registered: 02/11/12
Display Data Formats in scientific notation
Posted: Mar 5, 2012 1:44 PM
   thread.click_reply Reply
Hello,

is it possible to show decimal numbers in the grid in a scientific notation?

Tool Properties -> Tab: General ->Data Formats: #.##e##

does not work.

The number 0.001234567 should be shown as 1.23E-03

Regards,

pddzaic

Edited by: pddzaic on 05.03.2012 13:45
Hans Bergsten


Posts: 1,491
Registered: 10/11/06
Re: Display Data Formats in scientific notation
Posted: Mar 5, 2012 8:24 PM    global.in_response_to.tooltip in response to: pddzaic
   thread.click_reply Reply
Hi,

To get the formatting you use in your example, please specify Decimal Number Format as: 0.##E0. You can read more about all pattern options here:

http://docs.oracle.com/javase/1.4.2/docs/api/java/text/DecimalFormat.html

Best Regards,
Hans
pddzaic

Posts: 3
Registered: 02/11/12
Re: Display Data Formats in scientific notation
Posted: Mar 6, 2012 1:00 PM    global.in_response_to.tooltip in response to: Hans Bergsten
   thread.click_reply Reply
Hi Hans,

thank you very much for the information. Now it works as wanted.

Regards,

pddzaic

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