Comments (10)
hi,@htoyamaさん, このissueをreportし、NPOIのavailibilityを検証するとのですか、それともbugの修復を含めcodeを貢献したいですか?tonyqusさんが今この問題について検討していますが、もし修復策があればぜひともcodeも含めPRしてください😀。
from npoi.
It should be a limitation of xls files.
May I ask why do you need so many shapes?
from npoi.
Shape id is not a sequential number.
1024 shape id per cluster.
see also AllocateShapeId function.
The group is different, a new cluster will be assigned.
cluseter=0, shape id=0
cluseter=1, shape id=1024
...
cluseter=65, shape id=65536
For one image per cluster, the upper limit is 64.
from npoi.
book1.xls has a shape id greater than 65535.
Workbook.CloneSheet("Sheet1") <-- New group id.(next cluster is 74, shape id=74 * 1024)
workbook.Write(New_File)
from npoi.
Sorry, I think I misunderstand you. If you are provide a fix for NPOI, please follow the following tutorial.
from npoi.
Btw, if you are not good at English (I see your name is a Japanese name), you can directly use Japanese. Github has translation feature or I can use Google translation instead although my Japanese is so poor.
from npoi.
Hi, I'm not good at English.
Last Shape id is not equal number of shapes(images).
Shape idとshape(image)の数は、一致しません。
The shape(image) limit is 65535, but Shape Id is int32.
shape(image)の上限は、65535ですが、Shape Idは、int32です。
The attached patch can work around the exception, but it's maybe wrong.
添付のパッチは、例外を回避できますが、たぶん正しいものではありません。
Correctly, count the number of shapes(images).
正しくは、shape(image)の数をカウントしなければなりません。
from npoi.
結果は同じで実際の変更はないため、これを >65535 から >Int32.MaxValue に変更する必要はないと思います。(I use Google translation)
from npoi.
添付のbook1.xls で例外が発生するので、修正する必要がある。
from npoi.
パッチは、例外を回避するためのもので、良くありませんでした。
いつになるかお約束はできませんが、修正コードは作成するかもしれません。
70 shapes程度で、例外が発生する問題を共有できればと思っております。
from npoi.
Related Issues (20)
- Use of legacy .Signed MathNet.Numerics package causing build issues HOT 2
- fixed AutoFilter record size with multibyte strings. HOT 1
- fixed System.ArgumentException: 'Invalid CellReference: 'Sheet1' HOT 2
- Validation cannot handle double quote
- fixed System.InvalidOperationException: 'The hyperlink for cell A1 references relation rId1, but that didn't exist!'
- CICD script doesn't update the version number of the nuget package after updating to 2.7.1
- NPOI setting a new workbook ThemesTable copied from another workbook ThemesTable does nothing HOT 1
- ExcelToHtmlConverter dont assign class to tr tag
- GitHub: Missing release info/changelog for 2.7.1 HOT 3
- CreateColumn return System.ArgumentOutOfRangeException: Index was out of range
- The backport of POI Bug 60370 introduces a bug with PromptBox and ErrorBox text encoding HOT 1
- ByteArrayOutputStream is not disposed in NPOI.Util.IOUtils.ToByteArray method. Potential Memory leak HOT 2
- Reading Docs With DesignType,throw POIXMLException Error
- Wrong picture size in merged cell after picture.Resize() was invoked.
- Security vulnerabilities in SixLabors.ImageSharp HOT 4
- XSSFWorkbook write issue
- Remove picture...
- npoi-examples not available HOT 4
- 安装了最新版的库,处理同样多的数据,变慢了一半! 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.