anakic

7 ms·

1.
by anakic 4y ago
Fala, Ivane:)
2.
by anakic 4y ago
Back online now
3.
by anakic 4y ago
Too bad about 8h of downtime in the middle of it trending, but yeah, can't complain too much about it:)
4.
by anakic 4y ago
Would love to! There's a library called Math.NET that I wanted to look into, but never got around to it (plus, I forgot 99% of the math I learned in college so wouldn't know how to use it). Can you get in touch via email: antonio
5.
by anakic 4y ago
Yeah:) Of course it happens while I'm asleep. Serves me right for loading the post with so many gifs... Back online now.
6.
by anakic 4y ago
Oh man, limit happened while I was asleep. Thanks for the stopgap measure. Just got the bandwith limit removed with my hosting provider.
7.
by anakic 4y ago
Hope you give it a go. I'd love to know how you get on with it if you do!
8.
by anakic 4y ago
Would love to know how you get on with it. If you'd care to share, please to let me know.
9.
by anakic 4y ago
Thanks for trying it and replying back here. It looks like I was using a pre-release version of QueryStorm while I was writing the blog post. I just released that version so if you restart Excel you should get an "Update available&quot
10.
by anakic 4y ago
I use Wix for the installer. Can't remember how I dealt with that particular issue, but ping me at antonio [at] querystorm.com in a day or two, if you're interested, and I'll have a look at how exactly I dealt with it.
11.
by anakic 4y ago
I like that a gifs shows so much in very little space, but I take your point about it being distracting. Regular mp4 videos you can play/pause explicitly might be a better option for the future.
12.
by anakic 4y ago
Unfortunately, no. Excel for Mac doesn't support either of the two technologies QueryStorm uses to talk to Excel (namely VSTO and ExcelDNA). Might be possible to build something that would work across all plaforms using Blazor and the
13.
by anakic 4y ago
Thanks! Wouldn't mind that outcome one bit. It's hard to get exposure and adoption for a platform like this without some serious muscle backing it. I suspect Microsoft has its sights set on the cloud, though, but still, it would b
14.
by anakic 4y ago
It's something to consider, for sure. Perhaps there's an easy win to be had there.
15.
by anakic 4y ago
You mean add the workbook itself into the folder as binary file to include in source control? I haven't, but it might make sense, to keep the workbook in sync with the source code.
16.
by anakic 4y ago
I was considering "for" but I wanted to imply that the IDE is actually located inside Excel, rather than being a separate program.
17.
by anakic 4y ago
Yep, that's the idea. You create a project that defines some custom functions, ribbon commands, context menus, shortcuts etc... and then publish it to a store. Then anyone who has the QueryStorm Runtime (and the url of the store you pu
18.
by anakic 4y ago
Yeah, I just checked and it fails on some gifs for me as well (but works on others for some reason). I'll leave it as is for now, best not fiddle with it while this post is trending.
19.
by anakic 4y ago
I would love to but I'm a bit scared to fiddle with the post now while it's trending. I think it's mentioned in a few places on the website, but not in this blog post. I do also use a bunch of other libraries, but yeah, Excel
20.
by anakic 4y ago
Yeah, you can import the folder back into the project and it will replace all of the existing files with the ones from the folder.
21.
by anakic 4y ago
Yeah, didn't get around to populating those yet. One-man show, so things slip by... ComponentSource is currently the only reseller: https://www.componentsource.com/product/querystorm-plugin Thanks for the heads up
22.
by anakic 4y ago
No idea, haven't seen this until now. Hopefully they provide a mechanism for allowing legitimate addins to get around it. Perhaps using a code signing cert (which I do) or an EV certificate would be appropriate. Security has been a bit
23.
by anakic 4y ago
Thanks! You can version control the code you write with QueryStorm, to an extent. There are basically two kinds of apps you can build with this: extension apps (where you build general excel functionality) and workbook apps (where you autom
24.
by anakic 4y ago
A bit of both. On the Windows side I can use VSTO or ExcelDNA to integrate with Excel, but neither is available on the Mac. One alternative I'd like to try is a web-based version which would use Blazor and the Monaco editor but I'
25.
by anakic 4y ago
I have to do my own marketing, so I'm trying to blog more often these days. Really glad to hear you enjoyed the writing!
26.
by anakic 4y ago
Thanks, that's great!! <3
27.
by anakic 4y ago
Thanks! Yeah, I probably should have made the title "...in Excel" instead of "...inside Excel". I wonder if more or fewer people would have clicked on it that way.
28.
by anakic 4y ago
At first I thought you were referring to VSTO, then I saw the "not to be confused with VSTO" part. I had no idea this ever existed. Thanks for mentioning it. I wonder why they decided to pull the plug back then.
29.
by anakic 4y ago
Thanks, good catch!
30.
by anakic 4y ago
It works on Excel 2013 onwards but only on Windows. Both x86 and x64 are supported. Mac isn't supported I'm afraid.

More ›