Joined: 23 Sep 2005
Location: Oklahoma, USA
|Posted: Mon May 12, 2008 1:35 pm Post subject: Datasource view only shows 2 decimal places
I've got a postgresql database table populated with numeric datatypes that I connect to using the jdbc driver. When I pull the table up using "View --> Data Sources", the table in the view only shows two decimal places for the numeric data. The actual data in the table has 5 decimal places.
I've tried setting the calc cell format to show 8 decimal places, but the data available in the datasource view just pastes into the calc cells as two-decimal-place data with 6 zeros at the end.
Is there a way to set the decimal precision in the data source view?
Thanks in advance.
Hooray for Massachusetts and support "the Boston Office party!"