Tests for double and decimal CellValue ctors

[tomjebo]

• adding tests for double and decimal ctors for CellValue

[twsouthwick]

Can you update the title of the PR title with details?

[twsouthwick]

can you create a helper for this? Something like this:

internal readonly struct CultureInfoTester:IDisposable
{
  private readonly CultureInfo _old;
  
  public CultureInfoTester(CultureInfo desired)
  {
    _old = Thread.CurrentThread.CurrentCulture;
    Thread.CurrentThread.CurrentCulture = desired;
  }
  
  public void Dispose(){
    Thread.CurrentThread.CurrentCulture = _old;
  }
}

This can then be used to wrap the methods

[tomjebo]

So something like this? I just pushed the helper.

[twsouthwick]

It would be good to have a few cultures to verify this: ie en-US, fr-FR, ru-RU, zh-CH, tr-TR, ar-EG, etc (get in different ways of handling commas, left-to-right, etc)

[tomjebo]

Yes, I'll spend some more time on this to see what makes sense.

[twsouthwick]

what about for int/dates/etc? May not be as big of a deal, but with exponential support added in, it may

[tomjebo]

Dates definitely could be included. Not sure about int but I'll take some time to check them out.

[tomjebo]

I checked dates and they don't work the same way as decimal and double numbers. I tested a couple different dates but Excel seems to pay attention to the incoming format, unlike decimal and double.

[twsouthwick]

Any movement here, @tomjebo?

[twsouthwick]

Yeah, that's the right idea. Forgot to put usings around it though

[twsouthwick]

/azp run