Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Blocker] No universal conversion to strings #23

Closed
9il opened this issue Jul 26, 2017 · 3 comments
Closed

[Blocker] No universal conversion to strings #23

9il opened this issue Jul 26, 2017 · 3 comments

Comments

@9il
Copy link
Contributor

9il commented Jul 26, 2017

Motivation

A table contains dates, numbers, and strings (headers, and NaNs).
So it should be convertible to a universal type like string[][] or Variant[][].

How to reproduce

Change the function in the example to FuncBob

Note

Text cell formatting does not help.

@9il
Copy link
Contributor Author

9il commented Jul 26, 2017

BTW, Date support for an excel-d algebraic type would be very nice to have.

@atilaneves
Copy link
Collaborator

There's a type called Any.
It's a variant that supports exactly the same types as Excel does. Just declare your function to take Any, Any[] or Any[][]. Unfortunately that means knowing how Any works and manually inspecting the type (it contains an XLOPER12 inside.

@9il 9il closed this as completed Jul 26, 2017
@atilaneves
Copy link
Collaborator

Check the date functions in xlld.xlf - Excel uses double as a date type. There's no automatic conversion right now though - I agree it'd be nice to automatically convert to/from std.datetime.DateTime.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants