Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Calculate on connection (Read 2433 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Calculate on connection
06.12.10 at 14:40:46
Calculate on connection
When connect to the database all results are disappeared and only "#VALUE: is shown.

I chose to let SQL*XL recalculate the formulas when connecting to a database with the view that you want to reflect what is in the current database. However I can also think of scenario's where you don't want this to happen. I added a property to change this default behavior. Use the folling code to not calculate after establishing a connection:
SQLXL.Database.CalculateOnConnection = False
If anyone needs to change the default behavior I can cast it into a program setting as well. Just let me know if that is required by anyone.
The new property will be incorporated in SQL*XL 5.0.5.
Back to top
« Last Edit: 07.12.10 at 11:00:47 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1