|
Never used it. What are you trying to do with it?
Because I only needed to read it, I rolled my own XLSX reader.
|
|
|
|
|
I've used NPOI for years without any problems
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
pkfox wrote: NPOI
Funny, the author of the spreadsheets show as Apache POI. Related?
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
Yes they ported it from POI
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
kmoorevs wrote: .net framework upgrade to 4.6+
...
whines about a netstandard library that it can't find
Which version did you actually upgrade to?
.NET Standard 2.0 sort-of works with 4.6.1+, but it has several issues. Microsoft recommend using at least 4.7.2:
.NET Standard - .NET | Microsoft Learn[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Which version did you actually upgrade to?
4.6.1 first then 4.7.2. Neither worked. Back to 4.5.2. 
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
Any particular reason? 4.7.2 will make your life much easier when you want to reference a .NET Standard 2.0 library, and I don't recall seeing any breaking changes.
I think the only thing that "broke" for me was an ambiguous reference error for a custom extension method I'd written, which had the same name as one they added to the BCL in 4.7.2. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
kmoorevs wrote: ClosedXML .Net library to open/read Excel files....I am aware that a new version of OpenXML was released
A commercial production application should be built using the following
1. Identify libraries used.
2. Copy those libraries to a source that is controlled by the company.
3. Those libraries should ONLY be updated manually.
4. When libraries are updated and a dependent application is rebuilt then all of the impacted functionality must be retested.
Note that version identifiers should not be trusted. That is why step 2 is required. Version identifiers are nothing but a hint since nothing stops someone from updating a library and not changing the version number.
If the above is not followed then it is quite possible to go for years without problems. Until the day something quite unexpected shows up.
|
|
|
|
|
I find is amusing that my comments elsewhere (not CP), when it can't be deciphered by AI, needs to go for "review" before it can be released. AI is talking but not really listening.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
Gerry Schmitz wrote: AI is talking but not really listening.
Damn it... that might be the proof that is becoming like humans faster than we thought...  
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Gerry Schmitz wrote: AI is talking but not really listening.
I have to admit I've had a number of discussions with ChatGPT (after I've repeatedly tried to clarify a question) that have ended with me writing back "now you're just spewing nonsense".
Invariably, the textbox is then grayed out with a button that says "perhaps it's time to move onto a new topic".
|
|
|
|
|
Sounds like my other half, do you know each other perhaps?...
|
|
|
|
|
|
Probably not the only one not fluent in Spanish 
"If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization." ― Gerald Weinberg
|
|
|
|
|
The Lines & Symbols[^] just suddenly appeared when I opened my project. They were not there before the last update.
Anyone know how to turn these off?? Note that I have 'Show procedure line separators' off.
The lines only appear on regions.
The purple boxes open a context menu.
Thanks
In theory, theory and practice are the same. But in practice, they never are.”
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
|
|
|
|
|
You already have it turned off.
I'm running 17.8.2 and cannot duplicate the problem, so I would say open an issue with MS on it.
|
|
|
|
|
Will the age old method work -
- Close VS (shut down the process in Taskbar) and open.
- If that does'nt work, shut down Windows, power off and open again.
|
|
|
|
|
You forgot the part: Bury a dead chicken in the back yard.
>64
Some days the dragon wins. Suck it up.
|
|
|
|
|
Which, I must say, is MUCH easier than burying a live chicken in the back yard.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
I’m begging you for the benefit of everyone, don’t be STUPID.
|
|
|
|
|
That sounds like somebody with experience. But probably use a rubber chicken next time.
Hogan
|
|
|
|
|
OMG! You guys are on it! Thanks for the chuckle this morning. My brain has been trying to visualize an attempt at burying a live chicken since I read this, particularly a fiesty mean rooster. 
|
|
|
|
|
|
WOW! I can't believe you either found this, or somehow knew about it! What an obscure piece of information, but highly appropriate to this discussion. Thanks for posting.
|
|
|
|
|
Turn them on and save your settings. Then turn them off. Microsoft uses "cached" information when showing settings and sometimes the cache gets out of sync with reality.
|
|
|
|
|
obermd wrote: and sometimes the cache the whole of Microsoft gets out of sync with reality.
FTFY.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
