Sharp Cells @SharpCells

Sharp Cells puts the fun in Excel programming! Enjoy the full power of functional programming in the world's most popular functional programming environment. sharpcells.com Joined February 2023

Tweets

100
Followers

42
Following

46
Likes

112

Sharp Cells @SharpCells

3 years ago

@techsavvytravvy Drop the ;; requirements and you essentially have F# syntax

0 0 0 17 0

View Details

@ChShersh type RadioGroup<'T> = { Choices: 'T list DisplayName: 'T -> string Selected: 'T option } Ideally, would also have constraints that 'T is a discriminated union and 'T's in Choices are unique values but I'd rather have defined ordering than set ordering.

0 0 0 66 0

View Details

Sharp Cells @SharpCells

3 years ago

@MangelMaxime I believe .NET changed something about time formatting recently to use a non breaking space instead of normal space

1 0 1 67 0

View Details

Sharp Cells @SharpCells

3 years ago

@KooKiz If you use VS Code instead of notepad++ you could use F# with its inbuilt REPL just highlight the relevant fragment and press Alt+Enter. Hex and binary literals are fully supported

0 0 0 81 0

View Details

Sharp Cells @SharpCells

3 years ago

@wes_walke .NET scripting for Excel with a focus on F# sharpcells.com

0 0 0 15 0

View Details

Sharp Cells @SharpCells

3 years ago

@dsymetweets @florence_dev You could produce native exports on .NET side with F# and call it from python using their C interop features

0 0 0 72 0

View Details

Sharp Cells @SharpCells

3 years ago

@VicmoExcel @celia_excel @AhmedOyelowo @OzExcel @Crisp_EXCEL @wynhopkins It also can't be named just an apostrophe '

1 0 1 61 0

View Details

Oleg 🇺🇦🐍 λ @TheOlegarchy

3 years ago

This is a fantastic idea!

Dmitrii Kovanikov @ChShersh

3 years ago

A really cool idea for REPL: The 'explain' command that takes a piece of code and describes its every part in a beginner-friendly way. I don't recall any programming language doing this. Here's my prototype for OCaml 👇 What do you think?

74 223 2K 132K 299

0 1 3 230 0

View Details

Sharp Cells @SharpCells

3 years ago

@Tyrrrz IReadOnlyList is a poor way to communicate to consumers that the collection won't change. It actually says you can't change it but I might. Return an ImmutableList or ImmutableArray if you want to communicate immutability.

0 0 0 88 0

View Details

Sharp Cells @SharpCells

3 years ago

@tjain73 @FastFSharp +1 for Everything search. Almost instant search and indexes NTFS volumes in seconds

0 0 0 55 0

View Details

Sharp Cells @SharpCells

3 years ago

@SchlenkR @FableCompiler Maybe try something like this benchmark set github.com/krausest/js-fr… Removing single case union is generally good for performance. InlineIfLambda allows CEs in particular to get highly optimised. Expect Fable and .NET to be very different for performance

1 0 2 68 0

View Details

Sharp Cells @SharpCells

3 years ago

@WillEhrendreich @FastFSharp @dsymetweets @ChetHusk @isaac_abraham You may also need to do some pointer type conversions using the NativePtr module fsharp.github.io/fsharp-core-do…

0 0 0 18 0

View Details

Sharp Cells @SharpCells

3 years ago

@WillEhrendreich @FastFSharp @dsymetweets @ChetHusk @isaac_abraham F# doesn't work with pointers the same way as C#. In the P/Invoke call you can replace byte* with IntPtr or nativeint and it should work.

2 0 0 36 0

View Details

Sharp Cells @SharpCells

3 years ago

@leonhanbaga @Jonathan_Blow Fair point. Probably I should have qualified with "trivially converted". Can't say I've ever had the need to convert a function that wasn't primitive recursive into an iterative loop.

1 0 3 1K 0

View Details

Sharp Cells @SharpCells

3 years ago

@Jonathan_Blow I suppose it's always possible if part of the things you do includes recreating a call stack on the heap

1 0 3 2K 0

View Details

Sharp Cells @SharpCells

3 years ago

@FastFSharp Maybe treat your ROSpan<char> as ROSpan<int64> or even VectorXXX types for faster hashing

0 0 0 42 0

View Details

Sharp Cells @SharpCells

3 years ago

@illiaromanenko Glad to see other languages getting discriminated unions but it could be a little terser #fsharp

0 0 2 23 0

View Details

Sharp Cells @SharpCells

3 years ago

@FastFSharp I believe with strings they added analysis to compute the hash based on the shortest unique substring

0 0 0 60 0

View Details

Sharp Cells @SharpCells

3 years ago

@MrPeterLMorris If you can't then that sounds awful. I assumed it was like F# primary constructors where you get a single ctor body to do any checks in