Search the Community
Showing results for tags 'worksheet functions'.
Hi, are there any possibilities to implement a substring and a count function in a VW 2022 Data Tag? Both are worksheet functions, however I didn't find them both in the data tag functions. (I suppose, because the "data tag" Plugin doesn't support them there) typing a substring command manually still didn't work.
I have two near identical worksheets where =SQRT works in one and not the other. =SQRT works with one cell which is calculated from other cells, and fails on all the other cells where I want to use it. It's infuriating. Can anyone see what's going on? It Does work on other cells if I simply enter the number but that defeats the purpose of having a computer. Worksheets are standalone with no links, Cells formatted the same, both set as decimal to same signif. places. My desired solution is to generate mean planting distances for each of my planting types (which I have working the exactly same setup in other jobs). I'm doing this in worksheets as I usually understand and trust them more than the DB which I've had very bad (co$tly) experiences with. Peacock_sqrtBug.vwx
In Jim's Knowledge Base list of window functions for worksheets I cannot find "Overall Window Area". Is there such a function to return the elevational area of the window? For now I use the obvious workaround :WindowWidth*WindowHeight. Before using this workaround I was using the function "Area" . This returns a value for each window in my database worksheet. But the value is larger, though not much, than Width*Height. I guess Area is too simplistic for using with the 3D Window object , being normally for 2D objects. PS I am finding VWX2016 a truly rewarding experience!