« first day (1566 days earlier)      last day (1614 days later) » 
00:00 - 12:0012:00 - 00:00

12:17 PM
> Hi Rubberduck team,

I am using Office 2016 on Windows 10.
I downloaded and installed Rubberduck to try it out. No matter what functionality I choose to open (Code Explorer, TODO Explorerer), It always open Test Explorer.
 
12:32 PM
> @ndthanh - Which version, exactly, of RD are you using? Go to `Rubberduck | About`, then click the light-grey `Copy version information to clipboard` text in the top right box.

I get no repo in:

Version 2.2.0.3751
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4732.1000
Host Executable: EXCEL.EXE
> Version 2.2.0.3795
OS: Microsoft Windows NT 10.0.17134.0, x64
Host Product: Microsoft Office x86
Host Version: 16.0.10730.20102
Host Executable: EXCEL.EXE
> #4370 could be very much related. Could you try using the keyboard shortcuts to open other windows (e.g Ctrl+Shift+I for the Inspections Window)?
 
grumble grumble
 
> Repo!

I just installed .3795 and confirm this behavior. Also in .3794, .3791, .3786, and .3782, but NOT in .3762.

As a workaround, install .3762 - you won't be missing much in functionality. Mostly it's been back-end reorganization stuff in between the releases.
 
12:48 PM
@Duga @Vogel612
 
yea, that's kinda expected
 
> Thank you for your response.
@Vogel612 , the shortcut works and the Inspections Window opens.
 
considering that I broke most of the registration for presenters, that's exactly the behaviour that's fixed in the PR that references the issue I linked
I still won't push the merge through, because it's my own code..
 
1:29 PM
[rubberduck-vba/Rubberduck] build for commit 205846e2 on unknown branch: AppVeyor build succeeded
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4380?src=pr&el=h1) Report
> Merging [#4380](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4380?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/117639d4166048f81561bef1849bb0387b3d8ca1?src=pr&el=desc) will **decrease** coverage by `0.02%`.
> The diff coverage is `36.59%`.


```diff
@@ Coverage Diff @@
## next #4380 +/- ##
=======================
[rubberduck-vba/Rubberduck] build for commit 205846e2 on unknown branch: 57.17% (target 0%)
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4380?src=pr&el=h1) Report
> Merging [#4380](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4380?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/117639d4166048f81561bef1849bb0387b3d8ca1?src=pr&el=desc) will **decrease** coverage by `0.02%`.
> The diff coverage is `36.59%`.


```diff
@@ Coverage Diff @@
## next #4380 +/- ##
=======================
 
2:09 PM
Morning gents
 
yo!
 
2:23 PM
how goes?
 
slow. really sloooow. working on some very uninteresting administrivia. :(
 
Im updating my project information stored in one note
and yeah, it was kinda my idea to use one note
 
Except it's not totally true.
There's uh, Eval for instance.
feelsDirty++;
 
Thought as much. But better not recommend it. Who knows what EVAL it will be used for...
 
^
 
Just today I had a case where I was really unhappy with the way I mapped the fields of a recordset to the members of a UDT. The only real "solution" I came up with involved Eval. So in the end, I stayed unhappy.
 
2:52 PM
Who knows what Eval lurks in the hearts of men?
2
 
"Generally when folks start thinking this way the answer is" - I was fully expecting "use PHP" there ;-) — Mathieu Guindon 32 secs ago
 
Eval("Do: Me.Beat(): Loop")
 
@Inarion given that you can align the SQL to the UDT, you could probably abuse the CopyMemory API for this operation.
LSet would be safer but that requires you to have a 2nd UDT and that doesn't work if you have strings or arrays since they aren't pinned to the UDT.
 
@this Not sure that makes it more maintainable... +1 for the hackiness though. ;)
 
Something like For each fld in .Fields: CopyFieldValue fld.Value, udtOffset: Next
this does require the SQL to be ordered in same way UDT is, which is a lesser problem.
 
2:59 PM
Does that mean SQL has the same memory layout/conventions regarding string pointers?
 
irrelevant.
 
you're dealing with a recordset, and copying its field's value.
 
Someone kill them quickly. Please.
 
Oh, yeah. It's already in VBA's memory space.
 
3:00 PM
@FreeMan @Comintern, I believe that was you with the reference...
@Hosch250 nuke from orbit!
 
@Hosch250 it's PHP. What do you expect?
 
@this I'd expect it to be more "dreaded" than VB6 in SO dev survey. the world is doomed.
 
> I'm going to merge this PR given the urgency of the fix, but I'd like to echo @MDoerner's comments about the CW configuration, they should be addressed in either a small-ish tech-debt PR, or a (rather large, admittedly) dockable-stuff/command mapping redesign PR.
 
I usually refer to PHP as an "SQL injection engine" rather than a "programming language".
2
 
3:02 PM
yikes!
63
Q: Can I use NDA materials to force my employer to pay my salary if I haven't signed NDA agreement?

wasdI've been working with this company for a quite some time, we don't have any formal agreement, I haven't signed anything. At the same time among our clients were some really big and well known companies, who gave us some documents and asked for NDA. My employer shared with me those documents, so...

 
[rubberduck-vba/Rubberduck] Vogel612 pushed commit 51fd03f2 to next: Inject ReparseCommand into ReparseCommandMenuItem, see #4370
[rubberduck-vba/Rubberduck] Vogel612 pushed commit 8df46dd8 to next: Fix leftover CommandBase ctor injections
 
@Hosch250 I've seen this "concept" in a few languages so far and I'm still not clear why one would voluntarily use it. My brain seems to spontaneously produce a knot when reading this.
 
Update DockablePresenter injection mechanism

This change also motivates #4379
[rubberduck-vba/Rubberduck] Vogel612 pushed commit 2daeca8a to next: Fix goof with vbe design mode, fixes #4370
 
@Inarion IKR?
 
Merge pull request #4372 from Vogel612/whoopsies-cleanup

Clean up the whoopsies that snuck into prerelease 3782
 
3:03 PM
And here I was reading about writing clean and obvious code in my C++ book...
 
For embedded systems that need to be failure-resilient and be hard/soft real-time and have limited memory/computing power.
 
@Duga CF #4379
 
I just told work if they asked me to write PHP I'd quit and linked that article.
3
 
@MathieuGuindon IKR - it's surprisingly low for dreaded. I attribute it to web developer bias.
 
3:09 PM
@Vogel612 awesome!
 
@this WordPress.
 
shudders
 
for now I'll keep trying to put a dent into the mess of java application I'm working on rn, tho
 
^^
wordpress is pure unadulterated evil.
 
Wordpress.com is cool for blogs, though.
I love it for the free blogs--where I don't have to use the PHP.
 
3:12 PM
I have a whole weekend to myself again coming up. AC/SCP will either work, or die.
wait, WP isn't just blogs and a racket for plugins?
 
@MathieuGuindon Our company site is now done completely in WP so the marketing people can make changes without a developer (in theory).
In practice, it's a steaming pile that doesn't work.
 
@MathieuGuindon Check out wordpress.org.
 
@MathieuGuindon work, work, work! work! work! Work! WOrk! WORk! WORK!!
 
@Comintern i hope they don't try to link their WP with their accounting database or something like that.
 
3:25 PM
@this The accounting database has its own problems, but fortunately that isn't one of them.
 
Then again, it might not even have to be linked; just running WP might be big enough hole to let hackers in and help themselves to accounting database and the rest.
 
I did figure out 2 remote DNS vulnerabilities and one potential SQL injection attack on it though. Have those conversations documented filed away to CMA when someone else finds them...
 
can they add their own plugins? If so, then you're basically gambling that they won't put in an inerrant plugin...
 
The custom code is the problem. The dev group we hired didn't know WTH they were doing.
 
meep!
 
3:29 PM
Luckily it's on a dedicated web server that's not even on the same domain, so the target area is fairly limited.
We'd probably lose a bunch of contact information, possibly serial numbers, stuff like that. Other than the site itself that is.
I'd also feel more comfortable if everything was patched up to date...
 
@MathieuGuindon Hadn't thought of that. I actually like term. :+1:
 
I have open-source/closed-source contributions.
Some recruiters think I should call the closed-source contributions just "employment".
 
3:44 PM
@MathieuGuindon This made my morning. Thanks Mug.
 
4:08 PM
I'm in favor of AC staying. If you can get it to behave like a good ducky.
 
oh, me too
oh nice - answer a SO question, earn a follower on Twitter
and the answer made no mention of RD
@rubberduckvba Oh man, you just helped me out at StackOverflow. And want to thank you again hahaha. And I must knew you're from Quebec, you people are the best. ALWAYS =P
Love the illustration! +1 Still annoys me to do a null check when I don't care if the bag was incinerated though. I'm totally including this extension method in all future projects: IEnumerable<T>.IsIncineratedOrEmpty()Greg Burghardt 23 hours ago
lol
 
@MathieuGuindon If it wasn't in your SO profile, that would be some serious stalker chops.
 
One day you're going to have a crowd of people outside your house wearing rubberducky suits chanting your name.
 
4:24 PM
@MathieuGuindon the answer was pretty funny
 
That o prefix is useless, wrong, and actively harmful. If you haven't read this excellent article from the author of the VBA language specifications (and CEO of Stack Overflow), I'd warmly recommend it. That prefixing habit is called Systems Hungarian, and it was nothing more than a big huge stupid misunderstanding - the inventor of Hungarian Notation / Apps Hungarian never intended for anyone to encode the data type of a variable in its name. Would be nice if SO answers stopped propagating it. — Mathieu Guindon 6 secs ago
#ThereISaidIt
 
#VeinsBack
 
#ThereIUpvotedIt
 
4:39 PM
:)
 
4:50 PM
> An unhandled exception of type '<unknown>' occurred in <unknown>.
WTF, .NET? That's like Excel VBA error helpful right there...
2
 
@Comintern C'mon, that's easily a comintern-level error. Just right for your paygrade!
 
TBH, I think I know the problem...
 
making my point, dude.... :D
 
LOL
I'm just curious how far down the rabbit hole you need to be before the CLR can't figure out what happened. Didn't even know the executable name.
 
5:21 PM
wouldn't that be easily achievable with a out-of-process communication?
e.g. "someone's talking to me and I have no clue who the hell it is and it's talking gibberish"?
 
5:55 PM
@Vogel612 You are cleaning up the .csproj's for RD, right?
I'm considering proposing doing it at work. Any tips on how to do it?
 
@MathieuGuindon you're not the only one reaching the limit:
And I need that new users read how to ask before posting and that they read how to include a complete and verifiable example of WHAT THEY TRIED. We. Are. Not. Here. To. Do. It. For. You. — Simo 33 mins ago
 
@FreeMan Title should be "Plz write da codez 4 me".
SO is so mean.
They don't help me.
Much elite-ists.
 
SO should automatically set that as the title of any question that doesn't include code.
 
SO and volunteers can only help those that are willing and capable of helping themselves.
 
TFW you have 7GB in your recycle bin...
 
6:03 PM
lol
@IvenBach 2nd line: They do not help me at all.
5-7-5, dude...
 
575?
 
Much elitism
 
FWIW, that's not a poem. That's just a string of metered sentences.
To be a poem, it must have rhyme and flow.
Gets off my hobby horse
 
@Hosch250 I think some rappers might be confused on that subject. Maybe you can educate them...
 
Haiku (俳句) listen (plural haiku) is a very short Japanese poem with seventeen syllables and three verses. It is typically characterized by three qualities: The essence of haiku is "cutting" (kiru). This is often represented by the juxtaposition of two images or ideas and a kireji ("cutting word") between them, a kind of verbal punctuation mark which signals the moment of separation and colours the manner in which the juxtaposed elements are related. Traditional haiku consist of 17 on (also known as morae though often loosely translated as "syllables"), in three phrases of 5, 7, and 5 on...
> in three phrases of 5, 7, and 5 on...
 
6:07 PM
@FreeMan Oh... I give little to no thought to the words coming out. Asking me for poetry or structured wordings is a tad much.
 
SO is so mean
They do not help me at all
Much elitism
 
must have rhyme and flow
or it is not poetic
gets off hobby horse
 
FTW!
 
@this The only thing I have to say about rap can be said with my 2x4 of correction.
I think rap is a crime against humanity.
 
Hear, hear!
 
6:13 PM
I could write SO haiku all day.
 
@Comintern That bad? I would hope you'd at least manage so-so hakius....
 
can i haz the codez
my try is quite atrocious
you're not welcoming
 
Need to come up with one that includes [help center] and [tour] to be used as a standard copy/pasta on the 'gimmie de codez' posts
 
if you saw the tour
you'd write an mcve
check the help center
 
Why don't you write me
The code I asked for nicely
SO is much bully
</off-topic>
Back to work for me.
 
6:20 PM
@Comintern we have a winner! Consider that well used!
 
@Comintern if you'd read the tour
 
error ten o'four
on the activeworkbook call
four thousand questions
 
We have a haiku-ist that resides at our pond.
 
lol
 
@IvenBach "off-topic" and "back to work for me" work as part of it too!
 
6:26 PM
rubberduck chat room
is getting so off topic
back to work for me
 
Both of those have been copied and will be posted on a question soon.
@ticker says we need one for Error 91, too
 
@Hosch250 Don't have pre- or postBuild events.
 
@Vogel612 that's a good idea. Those who use it needs to be flogged. :p
 
It's pretty straightforward. But it's easiest when you start from scratch
Migrate the packages.config through the vs migration
 
get error ninety one
i thought items would be found
object is not set
 
6:36 PM
Have you pushed any of this?
We do have some prebuild events. Some docker run commands.
If you've pushed your changes to a different branch, I'd like to look.
 
6:54 PM
@MathieuGuindon Set obj = Nothing would attempt decrement the reference count by calling IUnknown.Release. If it hasn't been accounted for by calling IUnknown.AddRef, you may very well be trying to release an object that has already been destroyed.
Basically, if you get a weak handle you're responsible for it - not the runtime's reference counting mechanism.
 
thannks, edited
 
@Hosch250 ya, some of it is in a branch on my fork
Drinking on an empty stomach is really something...
 
I've heard it's highly intoxicating.
 
Not more than on a full stomach, just faster
 
7:15 PM
I can't know that, but this looks like a job for Rubberduck. Parse the project (click the "Pending" button in the Rubberduck command bar), right-click CATIA from the checkUUID procedure, on the line that says CATIA.DisplayFileAlerts = False, select "find all references" from the Rubberduck context menu; a toolwindow will pop up showing all the places this CATIA is used - if the "working code" indeed works, then one of the references will be a Set statement. See what it does, replicate accordingly. — Mathieu Guindon 5 secs ago
 
Nothing to impede the absorption of alcohol.
 
puking helps :)
 
#Experience
lol
 
haha
Never understood the appeal of alcohol.
 
7:23 PM
That or smoking. TBH, I think I'd puke if I tried to smoke.
 
@Hosch250 most definitely
 
and... done!
 
LOL.
 
If you took the tour. You'd write an MCVE. Check the help center. — FreeMan 21 secs ago
 
@FreeMan dat title though
@IvenBach obviously you're not in KY or TN :)
 
7:24 PM
:facepalm: He has no shame.
@MathieuGuindon Kentucky bourbon. What's in TN?
Whiskey?
 
@IvenBach Meth
 
@FreeMan sadly, the comment box doesn't allow for line wrapping (or does it...?)
 
@Comintern LOL
 
Tennessee sippin' whiskey. And meth...
 
@Comintern LOLx2.
WTF. I was right about my Whiskey guess.
 
7:27 PM
TBH I've kinda moved on from US Whiskey/Bourbon. Scotts do it much better :)
 
^
There are some really good bourbons, but nothing comparable to a really good scotch.
 
Scotch. Good for drinkin' and for hangin' your kid's artwork on the fridge
 
And good for going broke. My favorite at the local scotchery is about $30 a glass.
 
lol
I'm still at the exploratory stage
 
"scotchery"? Who knew?
Back in the old days, we called that a "Bar".
 
7:30 PM
can't be scotch if it's not scott
 
Made the word up just then. It seemed more appropriate than "watering hole".
 
lol
gave up on drinking a long time ago. Now I have absolutely zero desire for it.
saves money!
 
had a sip of Johnny Walker Red Label two weeks ago, got myself a John Barr last weekend, will probably get a Johnny Walker Black Label next week
 
@Comintern That glass contains 128 fluid ounces?
 
ol' George Thoroughgood had it right all along. One bourbon, one scotch, one beer
 
7:33 PM
I incorporated that into one of my posts.
 
JW - long time sponsor of McLaren F1. You're in good company
 
@IvenBach That glass contains Laphroaig 25.
 
25 - as in years old. Scotch ages. Well.
 
No way I'd pay that for a drink.
 
Better than buying a bottle for $500.
 
7:34 PM
SMH.
 
Although, that might be considered an investment grade scotch.
 
@Comintern it won't age in the bottle
 
No, probably not.
Especially with me around it.
 
hehe
@MathieuGuindon Very interesting article. I wasn't aware of the history behind that sort of notation. And so I've now edited my post. Thank you very much for pointed it out to me. I really appreciate it. Cheers! — Domenic 3 mins ago
didn't want to burst his bubble with the disemvoweling though
#OneMoreSavedSoul ...almost
 
His arrow code might burst that bubble for you. Thing looks sharp.
 
7:42 PM
pick your battles
but yeah
 
I'm really tempted to make a comment about how "ship-shape" it looks now.
 
@urdearboy sure does. "it makes that ding-a-ling noise when I turn" -> "oh it's gotta be the {thing}, easy job, that'll be $5K" — Mathieu Guindon 11 secs ago
@Comintern only if you do it without using any vowels :)
 
I'm befuddled. This question was closed 21 minutes ago, but there's an answer from 16 minutes ago. How's that happen?
 
draft grace period
 
so he was working on the answer and it got closed while he was typing?
 
7:52 PM
I'm unsure what to make of the fact that my feta smells like yeast
 
Unfortunately, the "fetid" pun doesn't work in German.
 
Eh. Enough heat will fix it
 
8:09 PM
> bought a few vowels, reduced nesting & complexity by extracting single-responsibility procedures
 
8:24 PM
Vowels for sale, vowels for sale! Last ones left! psst, the government just suppressed them--there won't be any tomorrow!
 
nah they're not suppressed, just there's a 600% tariff on them now. well the accented ones anyway.
 
I've been reading The Innocents Abroad.
 
We don't need accented characters. We're fine with ASCII.
 
In some countries where they didn't have freedom of press, they'd do that to make a quick buck.
The newsboys would.
And occasionally, when a newspaper got sick of the gov, they'd write a flaming article and leave town until things settled down.
 
9:07 PM
The Big Brother has always existed. Thinking the opposite would be thoughtcrime. — ilkkachu 4 hours ago
clever
 
Duck check: How or where can I check for when a function was added? I'm looking for when the VALUE function was added to excel.
 
install Excel 1.0 on a VM, see if it's there?
 
Earliest I have is 2007, I think. And I know that's not that early...
 
I know it was there in 2K3
so probably in 97 & 2K and XP as well
why though?
 
Knee-jerk reaction is to -- on whatever textual number.
At some point the VALUE function didn't exist and curiosity made me wonder when it was added.
techonthenet.com/excel/formulas/value.php has Excel 2000 listed as earliest.
 
9:23 PM
TTQW
 
> The VALUE function was introduced in Excel 2007 and is available in all subsequent Excel versions.
Someone's wrong, LOL.
 
user image
2
VS has been remarkably unhelpful today.
 
MS only lists it to 2010: support.office.com/en-US/article/…
Probably because 2007 is out of support now?
 
No, they have 2007 on there too.
> Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2019 for Mac Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel 2019 Excel for Android phones Excel Mobile Excel Starter 2010
 
Just quickly @Hosch250 does this article affect expectations about what RD could do in C# from inheritance point of view? infoq.com/news/2018/09/…
 
9:38 PM
@PeterMTaylor for now the feature is limited to .NET Core
as such we can't use it :/
that being said, RD could do some things with that, but I don't think we stand to gain a lot from that
 
@Hosch250 MS are inconsistent with versions; they have a tendency to drop older support files but it's not hard and fast.
 
9:54 PM
@this remember the inconsistency can be traced by changes to business decisions too you know.
 
yeah, that's why the only consistent thing you can expect from Microsoft is inconsistency.
2
 
Assigned tasks have been completed. <ponder>Do I use this time to work on RD? It can validly be counted as training.</ponder>
 
@IvenBach self training.
 
My reason for employment was to get the main Workbook updated. The subsequent submittals that depended on that finished a couple weeks back. Now I'm back to doing just that. Writing Excel articles for co-workers on how to do things better.
 
10:22 PM
Hrm... #TIL Excel.XlPivotTableSourceType.xlDatabase. It seems MS secretly does consider XL to be a DB.
 
nah. that's just to connect to an actual database
I do that all the time.
and unlike Excel-as-a-database, it is read-only but can be refreshed to see the latest changes from other users.
 
10:53 PM
I've only had cursory experience with PivotTables. I wish I had more reason to work with them.
:barf: why does shWrite.Range("A" & row).PasteSpecial xlPasteValues rile me so much...
 
11:13 PM
@PeterMTaylor That isn't coming until C# 8.0 (@Vogel612 it's not out yet, and it's not just for .NET Core AFAIK).
It's primarily to support adding methods to existing interfaces without breaking old callers that you literally can't update because someone else controls them.
 
Late to the party, again.
I have one haiku for you @FreeMan.
Kids today are dumb.
I am way too old for this.
Now get off my lawn.
 
A widely talented pond.
2
 
11:41 PM
Home time.
 
@M.Doerner mwahaha that's excellent!!
 
00:00 - 12:0012:00 - 00:00

« first day (1566 days earlier)      last day (1614 days later) »