Comments (4)
After some arrangements:
-
Empty string should be treated as CellValue
1.1. getCellValue on such cell will return empty string
1.2. getCellValueType will return CellValueType.STRING -
null will be treated as EmptyCellValue
1.1. getCellValue will return EmptyValue
1.2. getCellValueType will return CellValueType.EMPTY
from hyperformula.
Empty string should be treated as CellValue
I think that if we are going this way, then CsvImporter for empty fields, should change empty strings to null, before constructing HyperFormula. I.e. We'd expect such CSV: ,=ISBLANK(A1)
to have true in B1?
from hyperformula.
I've added possibility to handle null and undefined values. Do we want to handle numbers too (imho if we expanded to null
/undefined
, it make sense)?
Test:
hyperformula/test/engine.spec.ts
Lines 37 to 43 in 299d21c
Also I've fixed bug with " "
being understood as number 0.
Test:
from hyperformula.
Done #46
from hyperformula.
Related Issues (20)
- [Bug]: `simpleCellAddressFromString` crashes when called with non-ASCII character on an unquoted sheet name HOT 1
- Docs: Describe usage of non-ASCII characters in the sheet names
- Increase number of runs for all performance benchmarks
- [Bug]: Typo in the API reference for HyperFormula class HOT 1
- how should we read a string with leading 0 (zero)? HOT 5
- Prepare testing environment for TDD - POC
- get affected formula addresses HOT 6
- [Bug]: `Maximum call stack size exceeded` when adding a row to a huge spreadsheet with formulas HOT 1
- [Bug]: Moving rows sometimes does not update formulas correctly HOT 4
- Language files do not work with ES modules in node HOT 1
- Update copyright notice to 2024 HOT 1
- Docs: broken EUIPO link in the branding page HOT 1
- Remove Vue 2 demo HOT 1
- Improve DX with documentation demos HOT 5
- [Bug]: The *List of differences with other spreadsheets* guide doesn't scale well on narrower screens
- Make the demos show their content fully in the guides
- Use built-in <code> classNames to enhance the *Dependency graph* code snippets HOT 4
- ExcelJS loading function fixed HOT 2
- Introducing HyperFormula 2.6.1
- Feature: get a list of named expressions used by a formula HOT 1
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 hyperformula.