All Forums  Origin Forum  Origin Forum  labtalk dataset access changes

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by menhart@ii[/i] [br]ok so we have been using O for along time ( since it was part of microcal...) and have many older fitting functions. until O2017 we could access data in worksheets by wsname_colname(x) which would interpolate a dataset in worksheet wsname column colname. we have used this, for instance, to fit data as a linear combination of experimentally derived basis sets stored in wsname. we use this in various fitting functions, e.g.: F*(a*ba_a(x) + b*ba_b(x) + (f-a-b)*ba_r(x) ) now it seems this no longer works. note that referring to specific elements via ba_r[x] seems to work (i think...). the problem seems specific to interpolatin, and to be that the shortname has been changed by default to be non-customizable i.e. as described here https://www.originlab.com/doc/Origin-Help/Column-Short-Names-Restrict?f=dl this says the default is to name columns A, B, C.... like excel. so our fitting functions work if they are edited to F*(a*ba_B(x) + b*ba_C(x) + (f-a-b)*ba_D(x)) but that is silly. it is crazy since we would have to go back and change all fitting functions, and possible all datasets to reconcile this. it is also crazy since it is bad practice to have uninformative variable names. i feel like i have been transported back to 1970 and am programing in FORTRAN where only certain variable names are allowed (who remembers integers start with i-n, reals with some other letter?). i cannot believe origins developers did something so crazy without providing a work around so... what is it? how do i refer to an interpolated worksheet column dataset i have tried turning off this "excel spreadsheet mode" but the fitting functions still does not work in the NLLS fitter i have attached an O2107 *.opj file that works fine in O2017 but does NOT work in O2021 [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.