4 ms·
I hope you sell your IP to Microsoft Excel. This would be a major time saver feature for a lot of the Excel world.
by kylered 11y ago
I hope you sell your IP to Microsoft Excel. This would be a major time saver feature for a lot of the Excel world.
- mazesc 11y agoThis is already in Excel as FlashFill, so don't know if you're being sarcastic. http://research.microsoft.com/en-us/um/people/sumitg/ http://research.microsoft.com/en-us/um/people/sumitg/
- kylered 11y agoNot sarcastic... I didn't know about FlashFill. I looked at the videos, and it seems that it's not as powerful as this tool. In excel the results would be a custom cell format combined with custom text functions.
- mazesc 11y agoNot sure about the implementation in Excel. At least the paper (POPL 2011) describes more powerful functions, containing e.g. case distinctions and simple loops. There are some examples in there. I'm not an Excel expert, but would be surprised if cell format could do that.
- JBiserkov 11y agoLike so? https://www.youtube.com/watch?v=UccfqwwOCoY https://www.youtube.com/watch?v=UccfqwwOCoY
- sixothree 11y agoI could have used this hundreds of time in Visual Studio. We often process messages with hundreds of fields. So I will have a class from specs (usually excel) with a number of properties, then I need a method to populate each of those from some other object, then I need a method that does the reverse - populates some other object from the properties. This happens over and over for us. Typically I just use a Notepad++ macro. But I could probably use this as it stands, just having it in visual studio would be really incredible.
- MichaelGG 11y agoInstall a vim emulator inside of Visual Studio, then use macros.