Re: [Quantlib-dev] QuantLibXL / ObjectHandler 1.0.1 Prerelease Files

[Ferdinando A. <na...@am...>]

Hi Eric,

I've downloaded and tested the QuantLibXL-bin.exe release candidate:
there were few workbooks which needed an update. I fixed all of them
but Interpolation.xls.

Interpolation.xls fails because of a broken feature: we used to be
able to input a comma separated string instead of a vector of numbers,
now it's not possible anymore.
The code must be there somewhere and we also have the function
ohStringSplit which implements that functionality in an effective way.
Unfortunately nesting ohStringSplit inside a function call does not
solve the issue. Could you take a look at it?

The most elegant solution would probably be to just fix the call

=myFunction(..., ohStringSplit(myvectorAsString, ","), ...)

so that it would up to the user to do the conversion and to provide
the delimiter (which is regional settings dependant)
The optional next step might be to also attempt a last-resort coercion
to vector<Whatever> at the C++ layer, in which case the delimiter
should be the regional setting default

thank you anyway

ciao -- Nando