Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for toraritteā
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Edit | Post #290096 |
Post edited: |
— | 11 months ago |
Edit | Post #290497 | Initial revision | — | 12 months ago |
Answer | — |
A: What does F#'s `box` keyword do and where is it documented? `box` and `unbox` are operators documented in the F# Core API Reference; it tersely states that they box / unbox (respectively) a strongly typed value. + `box a` returns value `a` "wrapped" in a .NET `System.Object` instance "wrapped" here simply means that `a` is upcast to `System.Object`: ... (more) |
— | 12 months ago |
Edit | Post #290496 | Initial revision | — | 12 months ago |
Question | — |
What does F#'s `box` keyword do and where is it documented? The Null Values article in the F# Language Reference show an example that uses it, but it does not explain what it does exactly. > You can use the following code to check if an arbitrary value is > `null`. > > match box value with > | null -> printf "The value is null." > | -> p... (more) |
— | 12 months ago |
Comment | Post #290329 |
It was the latter (i.e., present finding in an answer). How would you clarify the question? The question arose from my ignorance of how a browser makes sure that a website's SSL certificate is valid. (Hm, perhaps I should put "HTTP" in the question.) I also aimed to ask a fairly general question to i... (more) |
— | about 1 year ago |
Edit | Post #290329 |
Post edited: |
— | about 1 year ago |
Edit | Post #290330 | Initial revision | — | about 1 year ago |
Answer | — |
A: How does a client verify a server's SSL certificate? What are the specific steps? Found this old article at the bottom of the search results to be the best explanation to date: (The longer version is here, SSL Handshake (Sun Java System Directory Server Enterprise Edition 6.0 Reference). If it doesn't work, here's the archived version.) > ### Server Authentication During S... (more) |
— | about 1 year ago |
Edit | Post #290329 | Initial revision | — | about 1 year ago |
Question | — |
How does a client verify a server's SSL certificate? What are the specific steps? I have little to no idea what happens after a client obtains the server's certificate. It has to make sure that it (somehow) valid, but how? (more) |
— | about 1 year ago |
Edit | Post #290275 |
Post edited: |
— | about 1 year ago |
Edit | Post #290275 |
Post edited: |
— | about 1 year ago |
Edit | Post #290275 |
Post edited: |
— | about 1 year ago |
Edit | Post #290275 | Initial revision | — | about 1 year ago |
Answer | — |
A: How to programmatically evaluate Excel data validations using .NET? 0. State of the art (as 11/22/2023) The `NPOI.SS.Formula.DataValidationEvaluator` class seems to mirror Apache POI's `DataValidationEvaluator` class, but NPOI's version only implemented the `IsType` method thus far. (For reference, here's Apache POI's `isType`.) There also seems to be no .NET E... (more) |
— | about 1 year ago |
Edit | Post #290274 | Initial revision | — | about 1 year ago |
Question | — |
How to programmatically evaluate Excel data validations using .NET? What I would like to do: 1. Set a cell value. 2. Check with a program if cell values conform to data validation rules. I could extract all the information needed to create a validation function, but I don't want to re-invent the wheel. What I have in mind is along the lines of how NPOI allo... (more) |
— | about 1 year ago |
Edit | Post #290255 |
Post edited: |
— | about 1 year ago |
Edit | Post #290256 |
Post edited: |
— | about 1 year ago |
Edit | Post #290255 |
Post edited: |
— | about 1 year ago |
Edit | Post #290256 |
Post edited: |
— | about 1 year ago |
Edit | Post #290263 |
Post edited: |
— | about 1 year ago |
Edit | Post #290264 |
Post edited: |
— | about 1 year ago |
Edit | Post #290264 | Initial revision | — | about 1 year ago |
Answer | — |
A: Drop-down values in Excel cells are not specified in Data Validation rules and global search didn't find them in workbook, so where do they come from? It took a day and a half, but found it: 1. LEFT column's valid values, `Assessed` and `Pending` Started with the left column, because if it is not set, then the right column is "inactive", so it clearly has to trigger something. After several global workbook searches on the string `Pending`, I ... (more) |
— | about 1 year ago |
Edit | Post #290263 | Initial revision | — | about 1 year ago |
Question | — |
Drop-down values in Excel cells are not specified in Data Validation rules and global search didn't find them in workbook, so where do they come from? On top of values seemingly coming from nowhere in multiple columns, they also affect each other's behavior: In the GIF below, if the cells in the left column have no value selected, then there is no dropdown in the cells in the right column and they also don't accept arbitrary values (as a validation... (more) |
— | about 1 year ago |
Edit | Post #290256 | Initial revision | — | about 1 year ago |
Answer | — |
A: Which .NET project can programmatically validate a cell's value out of the box based on Excel data validation constraints? Here's a list of popular Excel .NET projects that don't have this functionality: | | Has built-in cell validation? | |--------------|-------------------------------| | Open XML SDK | no | | NPOI | no | | EPPlus | no? (see section 3. belo... (more) |
— | about 1 year ago |
Edit | Post #290255 | Initial revision | — | about 1 year ago |
Question | — |
Which .NET project can programmatically validate a cell's value out of the box based on Excel data validation constraints? Are any of the popular Excel .NET projects have a functionality similar to Apache POI's `DataValidationEvaluator` class? (more) |
— | about 1 year ago |
Edit | Post #290254 | Initial revision | — | about 1 year ago |
Question | — |
How to "materialize" Ionide function signature type hints as comments? For example, given this function head, this is the hint that is generated: ```fsharp let updateCell workbook sheetIndex rowIndex columnIndex value = // XSSFWorkbook -> int -> int -> int -> string -> unit ``` Helpful, but this hint cannot be saved with the source code, and it also cannot be c... (more) |
— | about 1 year ago |
Comment | Post #290226 |
Thanks, but please don't bother - I just realized that the books I've been reading were written before .NET Core, when it probably made more sense to use it... (more) |
— | about 1 year ago |
Edit | Post #290226 |
Post edited: Add backticks around code in quote |
— | about 1 year ago |
Comment | Post #290227 |
Thanks! I figured as much, and, at this point, I'm just going to use my question to document stuff I find:) (more) |
— | about 1 year ago |
Edit | Post #290225 |
Post edited: |
— | about 1 year ago |
Comment | Post #290226 |
Thank you for the answer! I did some digging in the meantime, and indeed the consensus is that using `paket` pays off mostly when the project reaches a certain level of complexity.
So I'm not going to worry about it as my project is not a big one. What gnaws at me is that I can't figure out why it... (more) |
— | about 1 year ago |
Suggested Edit | Post #290226 |
Suggested edit: Add backticks around code in quote (more) |
helpful | about 1 year ago |
Edit | Post #290225 | Initial revision | — | about 1 year ago |
Question | — |
Where is the `.fsproj` project file documented? More specifically: Is there a dedicated docs page listing "properties" that are idiosyncratic to F# `.fsproj` project files? Why am I asking? Started learning F# a couple of days ago, but just now starting to realize that I will also have to learn the .NET ecosystem as well: Came across the ... (more) |
— | about 1 year ago |
Edit | Post #290209 |
Post edited: |
— | about 1 year ago |
Edit | Post #290209 |
Post edited: |
— | about 1 year ago |
Edit | Post #290209 | Initial revision | — | about 1 year ago |
Question | — |
How to automatically add package reference into project file after installing .NET package? Just getting into F#, finally figured out how to add .NET packages to projects, but the way I managed to get it to work doesn't make sense. Once the package is installed (either with `nuget` or `paket`), I have to manually add a reference to the project file (either by editing it directly or with `do... (more) |
— | about 1 year ago |
Comment | Post #290197 |
Thank you! I added it to my answer. (more) |
— | about 1 year ago |
Edit | Post #290198 |
Post edited: Add python tools |
— | about 1 year ago |
Edit | Post #290198 |
Post edited: |
— | about 1 year ago |
Edit | Post #290197 |
Post edited: |
— | about 1 year ago |
- ← Previous
- 1
- 2
- 3
- 4
- Next →