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

Implement __xludf.DUMMYFUNCTION added to sheets exported from Google Sheets #51

Closed
aglim opened this issue Jun 14, 2020 · 2 comments
Closed
Assignees

Comments

@aglim
Copy link

aglim commented Jun 14, 2020

Is your feature request related to a problem? Please describe.
Google Sheets-specific formulas in sheets exported to Excel are wrapped with ISERROR(__xludf.DUMMYFUNCTION(original_formula), computed_value) where __xludf.DUMMYFUNCTION is a non-existent formula that always gives an error resulting in returning the computed value.

As __xludf.DUMMYFUNCTION is not implemented yet, files with Google Sheets-specific formulas can't be handled by formulas raising NotImplementedError exception.

Describe the solution you'd like
Implement __xludf.DUMMYFUNCTION which always returns an error.

@aglim
Copy link
Author

aglim commented Jun 14, 2020

Workaround for now is to add function in runtime with

FUNCTIONS = formulas.get_functions()
FUNCTIONS["__XLUDF.DUMMYFUNCTION"] = lambda s: formulas.NAME

@vinci1it2000
Copy link
Owner

I implemented a function as described above.

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

No branches or pull requests

2 participants