Tsjaikovski
New Member
- Joined
- Jun 26, 2006
- Messages
- 29
Hi,
Our PostgreSQL database stores in some tables excel formulas.
When we query the database the formulas are put in the cells (2000 rows, 50 columns), but not the calculated values.
I would expect the formulas are recognized as text, but this is not the case as we see that Excel recognize it as numbers, percentages, etc.
We could solve it by adding this code in vba
sheets("sheet1").range("A1:A2000).select
Selection.Formula = Selection.Formula
but to do this for 50 columns it's to much time consuming.
Who can explain us what and why this is happening, and furthermore has somebody an alternative approach?
Thx,
Bert
Our PostgreSQL database stores in some tables excel formulas.
When we query the database the formulas are put in the cells (2000 rows, 50 columns), but not the calculated values.
I would expect the formulas are recognized as text, but this is not the case as we see that Excel recognize it as numbers, percentages, etc.
We could solve it by adding this code in vba
sheets("sheet1").range("A1:A2000).select
Selection.Formula = Selection.Formula
but to do this for 50 columns it's to much time consuming.
Who can explain us what and why this is happening, and furthermore has somebody an alternative approach?
Thx,
Bert
