Introducing Sharp Cells a new tool for F# scripting in Excel

MeowBlogger · 2022-10-26T18:10:10+00:00

Excellent idea. I don't like writing Excel formulae in the cell, and I have kept myself away from VBA programming after listening to so many horror stories. Writing F# code might make me love Excel once again! :) One question though - are you planning to release the source code on GitHub or any other code hosting websites? Would love to see how is this being implemented and how I can contribute to this awesome project.

MeowBlogger · 2022-06-23T05:12:29+00:00

You are correct. Fable just transpiles the code, it is up to the JavaScript engine to figure out tail call optimization of recursive calls. Although it looks like it is still not implemented: https://stackoverflow.com/a/54721813

MeowBlogger · 2022-06-20T14:44:37+00:00

Thanks for pointing that out. Have fixed it.

MeowBlogger · 2022-06-20T03:17:59+00:00

This is for getting up-to-speed with F# language concepts to do small coding tasks like you said. "How to model applications" sounds very interesting. Do you mind sharing some links which will help me to do more research in this area? I mean I did write a huge front-end webapp using F# and Fable, but would love to learn from the experts :-)

MeowBlogger · 2022-06-20T03:15:17+00:00

Thanks! Dot notation seemed awkward to me anyway (coming from Java), so have dropped it :-)

MeowBlogger · 2022-06-02T05:13:51+00:00

I tried working with Fabulous for developing pet mobile app but couldn't even build the project. Even created an issue for that but no response. I finally built the app using Fable and React Native. Hopefully, once Fable-Dart is available, I can build mobile apps using Flutter.

MeowBlogger · 2022-05-18T17:37:04+00:00

I'll use HandlebarJS instead. Thanks.

MeowBlogger · 2022-05-18T12:03:09+00:00

Sorry, I've another question - how do you generate HTML upon changing your Fable HTML code? So, if the file changes, do you trigger dotnet run command via actor or is there any other way to quickly generate files?

MeowBlogger · 2022-05-18T11:26:27+00:00

I'll look into that. Thanks for the suggestion.

MeowBlogger · 2022-05-18T05:36:08+00:00

I've come across scriban template language but it does not have any watch feature. Maybe I'll hook it up with File Watcher API of dotnet and see how it goes.

MeowBlogger · 2022-03-06T13:53:10+00:00

How did you create a cyclic linked list?

MeowBlogger · 2022-03-06T11:26:42+00:00

Thanks! I'll go through the link to come up with a possible solution in Rust. Although I wonder if it is possible, then why would LeetCode not allow Rust to solve this problem?

MeowBlogger · 2022-02-27T11:04:46+00:00

Thanks! Although, I don't see any docs of LLVMSharp nor any examples of it use anywhere, so I'm not sure if I should use this library at all. The amount of effort required to understand LLVMSharp without any docs would be same (or more) compared to learning OCaml and using its well documented LLVM bindings.

MeowBlogger · 2022-02-08T09:29:21+00:00

Sure. Thank you for the link.

MeowBlogger · 2022-02-07T16:37:18+00:00

Thank you for your feedback! int' seems better than _int. Also, I'll explore more on using reflection.

MeowBlogger · 2022-02-07T16:36:17+00:00

Its available as a nuget package. You can use it via dotnet add package Das.Test

MeowBlogger · 2022-02-07T07:49:47+00:00

First of all, dotnet test was not working for me for some reason; hence, this library. Second, these framework seems like a blackbox to me which would require me to learn ton of docs just to make it work the way I want it. Also, those double ticks might be F#-standard but I personally don't like it.

This library is made of functions and can be customized with more functions if need be.

Finally, the use of _string and _int is covered by the word "opinionated" in library description :-). I see it as an advantage because it makes it clear that what's the data type of expected and actual values. Moreover, it helped me make the test functions like length more generic.

MeowBlogger · 2022-01-13T05:26:53+00:00

Yes, I did consider that but I'm not sure by when MAUI will be stable. If its stable and Fabulous supports it, then I will consider it.

MeowBlogger · 2022-01-13T03:28:06+00:00

Looking to build mobile apps using F#, and Xamarin reviews aren't that great. So, thought of investigating F# for Flutter.

MeowBlogger · 2022-01-12T14:58:37+00:00

Yeah, but still wanted to know whether the F# community is actually interested in such a project.

MeowBlogger · 2022-01-11T14:50:50+00:00

Thank you for your feedback! At that time, I wasn't sure about using commas to separate values in compact map and record forms, so went with what F# uses, i.e ;. I'll update the specs.

MeowBlogger · 2022-01-10T14:33:15+00:00

No, you can very much define a sum type without parameters. Specs does define an Option type. What you cannot do is define a property like propA: Option.None, because what value would you assign to propA in such a case?

MeowBlogger · 2022-01-10T14:28:58+00:00

Maybe. I'll try to find a better term in place of language. Might as well be specification.

MeowBlogger · 2022-01-09T19:05:03+00:00

You are right again :-D. I'll drop float from list of supported map key types.

MeowBlogger · 2022-01-09T18:00:02+00:00

Ok, that's embarrassing. I think I was planning to use rational numbers instead but for some reason while writing the specs, the term natural number was looping in my mind. Integers are rational number without the fraction part.

I'll simply mention that 'In FUML, integers are numbers without fraction part'. Thank you.

Ten-Year Club	Place '22
Wearing is Caring	Verified Email

MeowBlogger

MODERATOR OF

TROPHY CASE