« first day (2596 days earlier)      last day (584 days later) » 

00:03
REFRESH!
[Minesweeper] 85 Games Played. 49 Bombs Used. 12739 Moves Performed. 10 New Users
 
1 hour later…
01:06
 
13 hours later…
14:08
Ah, Excel, you silly, wacky dude...
8
Q: Excel's "Highlight Duplicate Cells" is highlighting values which are actually different

ChrisSimple test case: Create new workbook Format column A as "Text" Enter the following into cells A1 and A2: 1234567800000639 1234567800000630 Select Column A, and in the "Conditional Formatting" submenu, select "Highlight Cells Rule" > "Duplicate Values". Excel is highlighting these as dupli...

14:18
seriously that's a bug
Yeah, that's what the answer states - a known bug. Maybe we need Mug to swing his big MVP stick to get them moving on fixing that. ;)
 
5 hours later…
19:54
I've released a new version of the visualizer github.com/zspitz/ANTLR4ParseTreeVisualizer/releases , with a latest-version check inspired by RD. But this release also publishes a NuGet package for the UI components, making it possible to embed in third-party applications such as Rubberduck.
20:22
@Duga Seems to me there was something about this a couple of years ago...
20:35
@FreeMan This? github.com/rubberduck-vba/Rubberduck/issues/… The settings control -- which includes the tokens and nodes visible by default -- could be surfaced, with some preset values.
@ZevSpitz See, I knew I'd seen that somewhere before!
@FreeMan but do you know that we know that you know?
21:13
> I endorse giving a nudge to this feature as the VBA IDE's Ctrl-H find and replace feature is woefully inadequate for doing anything except the simplest find and replace operations, and one should not have to copy code to an advanced text editor (such as UltraEdit), use its RegEx-based search and replace feature to edit that code, and then copy it back into the VBA IDE code window if RubberDuck is a "full-featured" IDE for VBA.

Also in this vein, the Refactor > Rename capability should suppo
> 1. Hasn't this been implemented already? The linked PR seems to have been closed.
2. Is this / should it be implemented using .NET regular expressions? Or the VBScript regex engine, which AFAIK is the only regex engine available to VBA?
22:04
@this For some value of "we", yes I knew that you knew that I knew.
> Zev: So far as I can find, no RegEx-based search and replace function has been implemented on any of the RD menus. If I missed it, my apologies.

The second part of my suggestion--related to the general one--re scoping and RegEx capabilities for Refactor > Rename--is also not implemented so far as I can tell.

All of this would be very useful.
22:29
> There has been a first implementation of this feature for a long time. However, it has some serious issues, e.g. in its handling of COM wrappers, and is only present in debug builds. I think nobody has worked on it for several years.
> Thanks, Max. I hope someone gets back into it, but I know it would be beyond my capabilities to do so.
23:12
> Thanks @zspitz, looks awesome.

I think there's great value in embedding this into RD. It's likely of most appeal to power users, rather than "Joe in Accounting", so it would make sense to put this behind a "developer mode" switch, but for those who understand it this would be invaluable.

What do others think?
23:48
[rubberduck-vba/Rubberduck] 1373 stars vs. [decalage2/oletools] 1639 stars

« first day (2596 days earlier)      last day (584 days later) »