Cell Range dataValidation problem about xlsx

[qrilka]

Hi @flhorizon
Any suggestion are welcome but I'm not quite sure what you propose as a "patch" here. As Linus says "show me your code" :)
Also @emilaxelsson added data validation in #67 so probably he could also add his 5 cents.

[flhorizon]

Hi @qrilka :)

Here's what I have so far, working for me:

flhorizon#1

I've tried to be as conservative as possible, so as not to change the contents of the list of ValidationTypeList [Text] for the existing use case.

As current lib users aren't using cell range validation, it shouldn't break anything for them.

Unless.. they are and didn't care until now that it was broken when parsing a file 🤔

(we're currently using 0.7.2 but it doesn't seem hard to port to later majors)

[flhorizon]

When I have a bit of spare time I'll implement the proposal extending the param type of DataValidationTypeList over 1.0.0.x

I guess there's no way to express in semver its backporting to 0.7.x and 0.8.x 😄

I'll admit the one with the formula header linked above (flhorizon#1) is a bit... lousy and just to sidestep upgrading my team's project deps to 1.0.0.1

[qrilka]

Sure, take you time, small not though - I'm on vacation for a couple of weeks so could be not that fast with a response, otherwise - any contribution is welcome

[flhorizon]

Hello,

I've finally ported my cellrange DV. code to master

#157

I've also needed support for absolute coordinates along the way so I've also added it too