Comments (4)
Interesting. ESD should be pulling the value straight from the sheet and I thought that E notation would translate as well. I wonder if this is a sheet data retrieval issue, a JavaScript number issue, or something else. I'll look into this. Good catch!
from exportsheetdata.
After running a few tests, I think this is a rounding issue with sheets. I duplicated your steps and got the same value. I manually entered values as well to be sure, but got the same result. Based on your screenshot and some other tests I ran, the expected value there is 36028797018964000
instead of 36028797018963970
correct?
I ran the exponential number through some E notation calculators to double check my work and despite some rounding weirdness it seemed like the 36028797018964000
value was the more standard result. I'm not sure if the Sheets POWER function is rounding more precisely or if it has a rounding error, but either way this seems to be related to Sheets, not ESD interpreting the value incorrectly. As such, I'm not really sure what can be done here unfortunately.
from exportsheetdata.
Sorry for the late reply!
Actually the expected value of 2^55
is 36028797018963968
(compute with this calculator).
The google sheet is starting rounding values from 2^50 however ESD still is correct until 2^54.
Based on that difference, the issue may comes from the javascript code itself.
This hypothesis seems to be confirmed by trying to compute power of 2 on this console, it was possible to reproduce the issue on 2^55.
After quick search I find this post which is interesting but without any solution
from exportsheetdata.
Now I'm the one with the late reply!
It's interesting that the JavaScript code itself is what causes the imprecision, but considering that it uses floating point numbers that's not too surprising at large numbers like 2^55
. That does reinforce my concern that I can't really do much about it since ESD can only pull data from Sheets as is. The solution here seems to be writing a high precision calculator to evaluate function expressions instead of pulling in reported values from Sheets directly... Which is a bit of a lift.
Unfortunately, that means this is probably an issue that I can't fix, or at least would not get around to for quite some time since building a calculator is outside the scope of ESD's functionality. I'm going to close this issue for now but if a good solution is found later I'll reopen it and see what I can do.
from exportsheetdata.
Related Issues (20)
- (XML) XML Namespace Validation
- (Bug) Slow or no XML export with "Child elements prefix" enabled HOT 19
- JSON does not export Cyrillic
- Error sidebar array separator character HOT 4
- (Bug) Error catchers cannot handle google service errors
- Upgrade ESD to use the new Google Workspace HOT 1
- Problem with the export of nested elements since last update HOT 4
- Nesting? HOT 4
- (Bug) Export configuration are erased after clicking Visualize before the complete loading of the Sidebar HOT 2
- (Bug) 'Export sheet arrays' + 'Export contents as array' only exports one sheet
- (Bug) Array prefixes do not work with Nested Elements
- (General | JSON | XML) Title HOT 1
- (General | JSON | XML) Title HOT 1
- (General | JSON | XML) Title HOT 3
- (General | JSON | XML) Title HOT 1
- Enabling Nested Elements causes non-nested element sheet to be exported incorrectly HOT 10
- Does not work in Chrome HOT 3
- (Bug) Exporting an array bugged while including a period and negatives HOT 1
- (XML) Easy substitute for 1 level deep XML NESTING
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from exportsheetdata.