Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

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.

Posts by toraritte‭

42 posts
60%
+1 −0
Q&A What determines where the focus goes back to when clicking on a browser's back button?

Short answer The HTML specification only addresses scroll position restoration behavior, so the main factors that influences where focus will land when navigating the browser history are: user ...

posted 29d ago by toraritte‭  ·  edited 29d ago by toraritte‭

Answer
60%
+1 −0
Q&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?

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 n...

1 answer  ·  posted 6mo ago by toraritte‭  ·  edited 6mo ago by toraritte‭

60%
+1 −0
Q&A How to merge Django model query results?

Just found the How Can I Combine Two or More QuerySets in a Django View? article by James W. that perfectly answers my question (and just learned that a "Django model query" is called a QuerySet). ...

posted 1mo ago by toraritte‭

Answer
60%
+1 −0
Q&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 met...

posted 6mo ago by toraritte‭  ·  edited 6mo ago by toraritte‭

Answer
60%
+1 −0
Q&A What is the difference between `static let` and `static member` in F#?

Taking the example from this Stackoverflow question: type Vector2D(dx : float, dy : float) = static let zero = Vector2D(0.0, 0.0) static let onex = Vector2D(1.0, 0.0) static let ...

1 answer  ·  posted 4mo ago by toraritte‭  ·  last activity 4mo ago by toraritte‭

Question f#
60%
+1 −0
Q&A How to set the cell color to a user defined value using NPOI from F#?

As far as I can tell (from F# at least), cell can only be colored using predefined NPOI.SS.UserModel.IndexedColors. From the available methods / properties, val it: ICellStyle = NPOI.XSSF.UserM...

1 answer  ·  posted 4mo ago by toraritte‭  ·  last activity 4mo ago by toraritte‭

Question f# excel NPOI
60%
+1 −0
Q&A How to start creating a Giraffe web project and how to serve it?

Having some trouble with giraffe-template on Mac M1, so decided to set up a Giraffe project manually. Started following the Doing it manually section of the Giraffe README, but got stuck right away...

1 answer  ·  posted 2mo ago by toraritte‭  ·  last activity 2mo ago by toraritte‭

50%
+0 −0
Q&A How to change the color of a cell to a user defined value while keeping its existing style using NPOI from F#?

The answer provided in the How to set the cell color to a user defined value using NPOI from F#? thread solves the problem of how to set the right properties using F#, but it uses a new ICellStyle ...

1 answer  ·  posted 4mo ago by toraritte‭  ·  last activity 4mo ago by toraritte‭

Question f# excel NPOI
50%
+0 −0
Q&A How to merge Django model query results?

I have to modify a legacy Django web application where there are 2 tables to store the same information using the same database structure, and the only difference is the names of the tables (and th...

1 answer  ·  posted 1mo ago by toraritte‭  ·  last activity 1mo ago by toraritte‭

50%
+0 −0
Q&A Why does `let map f = id >=> switch f` work in F#?

Asked How to implement map using the fish (>=>, Kleisli composition) operator in F#? a couple of hours ago, and r~~'s answer blew my mind: let map f = id >=> switch f It is perfect ...

1 answer  ·  posted 2mo ago by toraritte‭  ·  edited 1mo ago by Alexei‭

50%
+0 −0
Q&A How to implement `map` using the fish (>=>, Kleisli composition) operator in F#?

I'm learning monadic composition through Scott Wlaschin's Railway-oriented Programming post. Oncebind, switch, and >=> functions are defined, he introduces map to show how to "turn a one-trac...

1 answer  ·  posted 2mo ago by toraritte‭  ·  last activity 2mo ago by r~~‭

50%
+0 −0
Q&A What is a "sealed" type in F# and why doesn't the type test pattern operator (:?) work on it out of the `box`?

The F# language guide (see Signatures article) has a very sparse definition of what a "sealed" type is: Attribute Description [<Sealed>] For a type that has no abstract me...

0 answers  ·  posted 4mo ago by toraritte‭  ·  edited 4mo ago by toraritte‭

Question f#
50%
+0 −0
Q&A How to change the color of a cell to a user defined value while keeping its existing style using NPOI from F#?

Solved this by writing my own clone function: open System.Reflection let cloneCellStyle (cell: NPOI.XSSF.UserModel.XSSFCell) = let original = cell.CellStyle // printfn "ORIGINAL: %A"...

posted 4mo ago by toraritte‭  ·  edited 4mo ago by toraritte‭

Answer
50%
+1 −1
Q&A What software architecture are available for developing an application with multiple business domains that only share some common aspects?

NOTE The meaning of the word "program" below is (PROGRAM) A federal or state initiative that offers grants for non-profits so that they can provide service at low cost or free of charge. a...

2 answers  ·  posted 7mo ago by toraritte‭  ·  edited 7mo ago by toraritte‭

50%
+0 −0
Q&A How to set the cell color to a user defined value using NPOI from F#?

I failed to notice that a cell's CellStyle property returns the generic ICellStyle, which has to be cast down to NPOI.XSSF.UserModel.XSSFCellStyle in order to gain access to the FillBackgroundXSSFC...

posted 4mo ago by toraritte‭  ·  edited 4mo ago by toraritte‭

Answer
50%
+0 −0
Q&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 clea...

posted 6mo ago by toraritte‭  ·  edited 6mo ago by toraritte‭

Answer
50%
+0 −0
Q&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. be...

posted 6mo ago by toraritte‭  ·  edited 6mo ago by toraritte‭

Answer