Problem with formulas and external datas
Hello,
I need to keep some datas updated so I use the function : "sheet > link to external datas" to retrieve and keep them up to date. The problem is that I can't use the received datas in any formulas. they appear just fine but it seems that they aren't taken for account in anything I do. For example, in a formula, it shows no error but it act like the cell is empty. See picture:
What could I do to solve this problem ?
Thanks in advance,
Julie
If you don't set any explicit alignment at all, the default alignment causes cells to display
- numeric results/contents right aligned
- textual results/contents left aligned.
This is a very valuable feature.
I personally only use explicit alignment
Rightfor column headers in tables if the respective column is bound to contain numbers or formulae with assured numeric result.