Comments (4)
Bykiev
commented on May 23, 2024
I believe that excel file shouldn't contain any localized data, it's always in English and only the Excel App is localized and shows the data according to you region settings. How did you get the original file? WPS office shows the cell with formula contains unknown text, though MS Excel can parse it.
from npoi.
Zax
commented on May 23, 2024
I'm also pretty sure that the non-localized formula (EDATE) is in the excel file. I also did a test in VBA with the control expression and the formula in the cell gives me "=EDATE(A1,1)".
I created the Excel sheet directly with Excel 2016 (Italian) and saved it in Excel 97-2003 (xls) format. Now I'm uploading a test project here on Github.
Here my test project:
https://github.com/Zax/EDataTest
from npoi.
tonyqus
commented on May 23, 2024
Is this the only translated function Microsoft Excel provided? Or there are a few?
from npoi.
Bykiev
commented on May 23, 2024
@Zax, I've researched the issues and test project in your repo, can you please remove the Implicit intersection operator in formula and save it again? It seems this operator is only supported by Microsoft 365 and MS Excel 2016+ and incorrectly translated to old xls format while exporting
from npoi.
Related Issues (20)
- Charts Not Copied HOT 12
- Saving a Workbook and Re-opening It Corrupts the File HOT 13
- Error 0x800A03EC when opening with Excel.Application after saving with NPOI HOT 5
- Overwrite existing Excel results in problem with content HOT 3
- How can protected workbook excel file with npoi HOT 3
- Formula openxml gets corrupted after opened and saved by NPOI 2.7.0 HOT 12
- Excel file is always modified even if only opened for reading HOT 1
- Can't copy sheet's chart when using sheet copy function HOT 1
- System.Runtime.CompilerServices.Unsafe 4.0.41 not found while calling AsSpan HOT 13
- TypeLoadException: “NPOI.XSSF.UserModel.XSSFSheet.RemoveDataValidation” hasn't been implemented in “NPOI.OOXML, Version=2.7.0.0," HOT 1
- Add API for SearchText for xlsx,xls HOT 4
- Reading large files HOT 3
- AVERAGEIF formula doesn't work in xls HOT 7
- Cells with Formulas Display as Blank HOT 3
- XWPF POI Bug Migration II
- How can set picture properties on "Move and size with cells" HOT 2
- XSSFSheet.CopySheet doesn't support cloning charts
- i cannot open a file with npoi HOT 5
- The npoi package conflicts with the Magicodes.IE package HOT 2
- 'Object reference not set to an instance of an object' in XSSFCell.ToString() HOT 4
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 npoi.