« first day (1719 days earlier)      last day (1461 days later) » 

5:00 PM
but then again, i'm not really an expert, so what do I know about quality languages haha.
 
> Object-oriented programming is an exceptionally bad idea which could only have originated in California.
 
@Hosch250 I was talking about this the other day in the other chat room.
A number of criticisms have been levelled at the Java programming language and the Java software platform for various design choices in the language and platform. Such criticisms include the implementation of generics, forced object-oriented programming, the handling of unsigned numbers, the implementation of floating-point arithmetic, and a history of security vulnerabilities in the primary Java VM implementation, HotSpot. Additionally, Java, especially its early versions, has been criticized for its performance compared to other programming languages. Developers have also remarked that differences...
There is literally a whole f******* page dedicated to this on Wikipedia.
 
> Haskell is so strict about type safety that randomly generated snippets of code that successfully typecheck are likely to do something useful, even if you’ve no idea what that useful thing is.
 
> The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense.
@Comintern That's one of the F# arguments.
 
Yeah, same philosophy.
 
5:01 PM
Yeah, that's the #1 thing I love about it.
If it compiles, it almost certainly works.
 
So I was looking up the dictionary for the word bitter. Didn't have a entry; only a picture of Dijkstra
 
> It is practically impossible to teach good programming to students that have had a prior exposure to BASIC: as potential programmers they are mentally mutilated beyond hope of regeneration.
> Don't compete with me: firstly, I have more experience, and secondly, I have chosen the weapons.
 
Rip Rubberduck community.
 
> About the use of language: it is impossible to sharpen a pencil with a blunt axe. It is equally vain to try to do it with ten blunt axes instead.
LOL.
 
@Hosch250 Yesterday, in the other chatroom we had a discussion about this question: cseducators.stackexchange.com/questions/5417/…
 
5:04 PM
> Programming is one of the most difficult branches of applied mathematics; the poorer mathematicians had better remain pure mathematicians.
 
lol i'm a pure mathematician rip.
 
Saw that.
 
rip my life.
dijkstra senpai why?
 
See Buffy's answer:
 
I'm going to start leaving that as a comment on all the VBA questions.
 
5:04 PM
> Have you learned architecture and databases?
I totally went oh my gosh, design patterns are a HUGE part of architecture...
 
@Comintern "It is practically impossible to teach good programming to students that have had a prior exposure to BASIC: as potential programmers they are mentally mutilated beyond hope of regeneration." ?
:P
I tend to agree with Lightness Races in Orbit's answer: cseducators.stackexchange.com/a/5427
 
Yeah, more/less.
Design patterns are just names for frequently recurring patterns to solve problems.
It's good to go through them so you are familiar with past work.
And so you know what coworker Joe is talking about.
But, as far as that goes, don't pay too much attention to them, really.
If you do, you are almost certainly going to end going "I'll use X pattern", then forcing the problem to fit the pattern, instead of finding a pattern the problem fits.
 
For me, I find that as soon as you introduce a new programmer to design patterns they overuse them.
 
That ^
 
and then they have to unlearn everything.
 
5:10 PM
I know the names of half a dozen. I forgot the rest.
 
I don't know the names of any, but I technically have a book on the subject.
But honestly, I strongly disagree with Buffy's answer because of this quote: "So, it may well be that your curriculum is flawed, but not teaching the patters in the Gang of Four book is not the only indicator. (Some of those authors are friends of mine, in fact). "
emphasis mine.
 
Buffy drank to kool-aid.
 
I really do not think that lack of Gang of Four is a reason to say the curriculum is flawed lmao.
 
It's no coincidence that they're named after the Gang of Four in China.
Buffy advocates the Cultural Revolution. Lightness is Deng.
 
Maybe I should make an account on CS Educators and spread my (apparently) unpopular opionions
You want to get good scrub? Don't waste your time on Webapps. They're shiny, but they're not that important right now. Study a lot of math. Start off with a lightweight language like Python. Solve some small programming puzzles like Lisp 99. Try a couple of "bigger" programs like making a mandelbrot set or something. Make sure you have someone review your code a lot. Try to make a lisp interpreter. Go to C to learn more about hardware. Next try something strongly typed like Haskell or Idris.
Try your hand at J. Also, slowly lean off StackOverflow, get better at reading the docs.
Probably would get immediately downvoted to oblivion lol.
 
5:24 PM
I started with C++.
Switched to C# for WPF.
 
@Hosch250 LOL SAME!
 
Learned F# several years later, to get into FP.
 
holy moly clarinet, and C++
hahahahahaha
 
Got a job in web.
I almost never need SO. Barely ever used it compared to other sources, TBH.
 
@Hosch250 I tend to avoid it now because they are more worried about getting the job done rather than doing it right.
The docs are written by talented people who also have intimate understand of what they created, so I really try to stick to them the best I can. Sometimes I still need to use SO for my job though lol.
 
5:29 PM
First I avoided it because I got banned for being a vampire. When I worked that ban off by not logging in for about a year I found I couldn't contribute anything because all the C++ questions I could've helped with were answered.
Then when I switched to C#, Skeet, Lippert, and a few other users have everything covered.
The rest are just help vampires.
That is, questions.
 
@Dair You've apparently never read the VBA documentation.
 
Now, I avoid it for the same reason you do. I can't support where they are taking the business, so I avoid relying on it.
 
@Comintern This is true.
i'm trying to get better at reading the docs too because I want to start programming without internet.
 
I have an open issue on an MS docs page where the used the wrong language in a code sample.
 
@Comintern The translation is left as an exercise to the reader :P
 
5:32 PM
@Dair I have a gut feeling that the demand won't be very high for programmers post apocalypse.
 
Crazy idea: I want to go and do some outdoor climbing and be able to bring my computer and work on math/cs outdoors.
 
@Dair Nice.
If I wasn't a programmer, I'd probably be a guide in a park, or something.
 
well, I want to do that, I haven't done that yet :P
 
@Hosch250 :twitches: Were
 
well i've done outdoor bouldering without the computer haha.
 
5:34 PM
Crazier idea - use an extension cord for a belaying rope so you can work for longer than a couple hours.
 
@this Not sure. Probably out west.
 
No. were, not was
If I were you, I would use "were" for subjunctive moods.
 
Oh, I thought you mis-spelled "where".
Oh, "weren't"?
 
i'm supposed to design a logo for the website i'm working on and inkscape wont launch for some reason...
 
yes, as I understand the grammar.
 
5:35 PM
I think it works either way. Want to take it to EL&U?
 
Nah. My grammar is the gospel.
(!)
 
Is that a grammatically correct use of "nah"? I thought it had a comma after it.
 
It is now.
3 mins ago, by this
Nah. My grammar is the gospel.
 
Oh, snap!
 
:-D
 
5:40 PM
The Grammar According to This.
 
That!
 
FWIW @this is correct there, regardless of his grammar-deity status
 
unrelated - a sanity check - there is no way to get a detailed error message for those stupid 1004 errors?
 
in Excel?
 
Yes
 
5:41 PM
depends how the error is happening
 
I'm guessing you mean other than Debug.Print Error(1004).
 
it's usually thrown when you try to use a worksheet function with invalid arguments, or when you try to set a range's formula to something it can't parse
 
You have check your sanity at the door sometimes when you use the Excel OM. AFAIK there isn't a way to get anything more specific from it.
 
I'm doing PivotTable.AddFields and getting AddFields method of PivotTable class failed which is very descriptive and helpful in telling that I did something wrong.
 
i.e. manually doing what you're trying to do programmatically, would pop an error message
 
5:43 PM
Off to the docs.
 
Yeah, good luck with that.
 
@MathieuGuindon Ha ha ha, that is assuming that there's a direct analogue. Not all methods are a button on UI.
Just asking ecause ADO and DAO has Errors and Access has AccessError but Excel....
 
...has 1004.
 
^
 
5:45 PM
It's not really that different than an HRESULT_FAIL - it's context specific.
 
> **Rubberduck version information**
Version 2.4.0.4550
OS: Microsoft Windows NT 10.0.17763.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11328.20070
Host Executable: WINWORD.EXE



**Description**
I have a number of classes/module which have the '@IgnoreModule annotation. I'm seeing that the code inspector is reporting 'Assignment is not used' in a couple of these modules.
 
That means look at the state of the object you're using and the arguments you're passing and see if they make sense.
 
@Duga huh, isn't that handled in the base class?
 
@Comintern IOW, it's too much work for them to say "you done misspelt one of your field's name, you moron"
 
@MathieuGuindon Not if it overrides Declarations for some reason.
 
5:48 PM
> Was the annotation added by the "ignore in module" quick-fix? What is the actual comment line (and if possible, the surrounding code)?
 
Why is that virtual?
 
no idea
is anything overriding it??
 
Checking now.
@this It's usually something like a Range from a different sheet or something like that.
AssignmentNotUsedInspection calls the DeclarationFinder directly instead of using the base implementation.
 
ugh
huh, there's no UI to ignore that inspection at module level??
 
In fact, there appear to only be 16 inspections that use the Declarations or UserDeclarations from InspectionBase at all.
 
5:53 PM
woah
 
> Confirming, '@Ignore is, uh, ignored, at individual result level, too.
 
I'm guessing no based on the code.
It's behind next here, but not that far.
 
I've the same build as the OP
 
I unfortunately have Excel workbooks open that I can't close right now or I'd rebuild to test it.
The fix appears to be trivial though. State.DeclarationFinder.UserDeclarations --> UserDeclarations
 
5:57 PM
In theory you could hotswap the assembly files, no?
(assuming you do not need to change the Ruberduck.dll)
 
In theory.
 
Wait, is the dll even locked?
we lock the TLB for sure
can't remember if DLL gets locked.
 
It's in use.
 
Duh, yes. it has to be. Deployment explicitly checks for that.
 
6:10 PM
wth
@rene that +10 answer (now +9) is terrible, unjustified advice. Popping a MsgBox doesn't require enabling VBA code to write & modify VBA code as it's running. Don't tick that checkbox unless you're actually doing meta-prorgamming in VBA, or need to run code that does. I can't believe the votes on that answer, the OP (both here & there) has nothing to do whatsoever with the VBIDE API. I wish I could downvote that answer thrice. — Mathieu Guindon 10 secs ago
 
I just read it and down-voted it too.
WTH? "A: Disable all security features and try again"
 
I know this is an old answer, but since this Q&A is being linked to, there needs to be a comment here that says DON'T DO THIS. This is terrible, unjustified advice that is outright dangerous. Don't tick that checkbox unless you're doing actual meta-programming in VBA, or need to run code that does. This answer is wholly inappropriate for this OP here. The ONLY reason to check this box is if you're using the VBIDE API and you know what you're doing. Otherwise, this is a massive macro-virus security hole. — Mathieu Guindon 13 secs ago
@Comintern IkR?
and 100% chance it won't change anything, and 75% chance the checkbox will remain ticked, because "eh, what could possibly go wrong"
scans the other answers - wow, I wish I could unsee that page
 
That is a good one, though:
1
A: Cannot run the macro... the macro may not be available in this workbook

DoyletI had the same problem as OP and found was due to the options declaration being misspelled: ' Comment comment Options Explicit Sub someMacroMakechart() in a sub module, instead of correct; ' Comment comment Option Explicit Sub someMacroMakechart()

 
3
A: Cannot run the macro... the macro may not be available in this workbook

VigneshHad the same issue and I 'Compiled VBA Project' which identified an error. After correction and compiling, the macros worked.

That too ^
 
the whole page is a collection of "me too!" answers
 
6:23 PM
it's a honeypot.
 
^
Now if we don't look like a voting ring... I don't know what does ~_~
 
gosh, Excel's OM is AF
 
AF? I'm guessing the 'A' is Access, and I have a good guess at the 'F' too...
 
Forgot one more A.
In particular pivottable and its child objects.
 
You think that's fun, you should try charts.
 
6:36 PM
pretty sure charts are easier.
 
Oh, so you haven't tried them yet.
 
last time I worked with them, they were straightforward.
But to be fair, they were just bar or line types.
No polar or 3-d pie BS
 
@Hosch250 woohoo, delete-vote frenzy!
 
@MathieuGuindon LOL. At least he had the sense to compile the project, though.
Most people wouldn't have dreamed of doing that, from what I've seen.
 
"compile before parse" RD setting is a godsend, apparently
 
6:45 PM
Probably is :)
 
> - Have you tried compiling your code?
> - I didn't, but Rubberduck can parse it.
> - So, you did.
 
@MathieuGuindon don't forget to thank a grammar deity for that.
4
 
I'd love to be able to watch their reaction when they get that messagebox when they try to parse uncompilable code.
"compile? what's that?"
 
7:26 PM
@Comintern It is actually correct that AssignmentNotUsed uses the declaration finder. It is not the declarations that get reported; it is the references. So, it just needs a Where(reference => !IsIgnoringInspectionResultFor(reference, AnnotationName)).
 
@M.Doerner OK, makes sense. I didn't look at it very closely.
 
Btw, don't we already have an open issue for this?
 
I didn't see one. There are a couple open issues for that inspection though.
 
My memory must have played tricks on me.
 
Holy cow.
 
7:32 PM
The same issue has popped up on a handful of other inspections. I'm wondering if we should start checking that at a single point in the code.
 
I was just "in the flow", and someone slammed a door.
I "woke up", and was disoriented for several seconds.
I couldn't even remember the layout of the office for a bit.
 
in Coding Projects and Factorio Heaven, Jan 28 at 22:51, by IvenBach
1: Breathe
2: Exhale
3: GoTo 1
 
@IvenBach I'm not irked. I think it's funny :)
 
Trying to get caught up with transcript. Lots went on since last night.
 
@Hosch250 "In the flow"... I'll have to remember that one, usually we just called that "asleep".
;)
 
7:40 PM
It's the official term for "in the zone".
 
@Dair That is Mugs dream job. I'm sure other ducks at the pond would work on RD solely if they got paid to do it.
 
He's marketing it to MS.
 
@M.Doerner @Comintern I know I've opened issues for '@Ignore being ignored, but all of mine seem to be closed at this point.
 
He wants them to buy it and make him chief PM.
 
Prime Minister?
Post Meridian?
Pencil Muncher?
 
7:43 PM
Product/Project Manager...
 
Papier Macher?
oh That's not as much fun.
 
@FreeMan sounds like a .... fibrous job.
 
@this Sounds like an accountant.
 
@this You must have skipped kindergarten.
 
@FreeMan Probably volunteered. Come to think of it, I don't remember getting paid for my kindergarten either.
 
7:51 PM
Or I was brught enough to know pencils aren't to be munched.
Unfortunately I may have sniffed a glue bottle or two....
 
@this How would you know it was a fibrous job if you hadn't tried it?
I was just thinking you probably learned the hard way.
 
Well, munching on pencil probably is going to add a lot of fiber to your diet, no?
 
@this Only if you swallow it.
 
Doesn't fiber in that context usually refer to soluble fiber? I didn't think cellulose was soluble.
 
unless if you munch it hard enough.
 
7:55 PM
might not be soluble, but it will be added to your diet if yer swallerin'
 
I'm guessing it isn't as bad for you as the paint.
 
@Dair This pond taught me to RTFM, but in a nice way.
Iven: Senpai's I have a question.
@Pond: docs.microsoft.com/en-us/office/vba/api/overview
 
Please RTFM?
2
 
It was more like RTM, but I read between the lines.
Can only lead a coder to the documentation, can't make them read it. Or understand it.
 
You could probably make them drink it though. Given a blender, some liquid to get it to the consistency of a smoothie, and a suitable amount of force or coercion.
 
8:02 PM
@Comintern the graphite should keep yer innards well lubricated.
@Comintern talk about your fibrous meal! Oh, wait, are you blending the monitor or some mythical API dead-tree book?
 
Either I guess. The monitor would probably taste a lot worse though.
 
Hmmm silicon 'n' glass!
oh, with a smattering of mercury, too!
yum yum
 
All kinds of tasty bits.
 
hopefully not the private bits, though.
 
You'd need one of those Blendtech blenders though.
 
8:07 PM
@this those are reserved for future use
 
Shhh... we're not supposed to talk about the private documentation.
 
at least not in mixed company. Looks around, notes Macs and Linux machines among the Windows users
 
@this Mmmm, the BIOS.
That's the tastiest part.
 
8:22 PM
hey, @Comintern - when you found that Symantic issue with consent.exe and mmc.exe when you were looking at the Excel crash reports, did you find that by searching on the Excel error message or one of the others or something else? If you happen to remember...
 
IIR I was searching for the error code that got logged to the WER.
 
rereading that symantic page, it looks like it's specifically related to the consent and mmc exes, not Excel. And we seem to be running 14.0 MP2 (whatever that means), not 14.2, so at a minimum, updating that couldn't hurt.
I'm sending a ticket in to the help desk. Might not help, but it couldn't hurt. Right?
 
Yeah, at very least they'll be aware of it. Let somebody else do the digging on it.
 
@FreeMan Now, you need to apologize to the li'l ducky. you hurt his feeling with all your blaming and shaming, ya know...
 
oh, I never blamed the duck. (I explicitly indicated that it was not duck related!) Don't gimme that!!
 
8:37 PM
yeah yeah
:D
 
I'll give the lil feller a feather tusslin', though, just for good measure.
wow, @feed. Top item was put on hold before it even hit the list!
 
I wonder if there's something to disable those stupid faux popups in the website
 
9:04 PM
Howdy all...new thoughts from my reading to share...iheanyi.com/journal/2019/02/03/…
 
9:16 PM
Wow, an Excel performance question that's borderline too broad. A: Start over.
 
10:08 PM
I have this undying hunch that explaining how logical operators and truth tables work would be more beneficial than providing you with code that implements your requirements correctly. — Mathieu Guindon 9 secs ago
 
Question: Why is the rename refactoring responsible to validate whether the new name is validand not the view model?
 
@M.Doerner it isn't... well, shouldn't be.
hey welcome back @AlexisDuque!
were you able to merge the latest upstream changes? I believe there's a handful of new resource keys
 
I was reading the PR
@MathieuGuindon How do I do it?
 
first, make sure you've committed any local changes
then, if you have setup a remote to https://github.com/rubberduck-vba/Rubberduck (aka "upstream"), then you can git pull from it, e.g. git pull upstream next
if there are conflicts, you can easily resolve them in Visual Studio with the Team Explorer toolwindow
 
Shouldn't that be a fetch, not a pull?
 
10:22 PM
right, I never fetch... maybe I should
 
I thought pulling always fetches implictly
 
Yes.
 
AIUI, fetch then pull is a good practice, as you get to review what got changed or something.
 
I gotta run, bbl
 
10:45 PM
the comand git add Rubberduck.Resources/ return warning: LF will be replaced by CRLF in Rubberduck.Resources/About/AboutUI.Designer.cs.
The file will have its original line endings in your working directory
the same for the rest of files
Aparentemente es una advertencia, pero, si agrega los archivos
Apparently it is a warning, but if you add the files
 
i love how my loan processor is asking me for canceled checks for my rental history
im just like... what...
 
@AlexisDuque I usually choose yes- it should be using cRLF all over, I think
 
11:21 PM
@MathieuGuindon regarding this comment: stackoverflow.com/questions/54775555/…
I think we should be recommending using 6.1, almost never the 6.0, no?
 
@AlexisDuque There's a setting to handle that = git config --global core.autocrlf true
 
> I no longer can replicate this anymore with the current version. Closing.
[rubberduck-vba/Rubberduck] bclothier did something with some project card
 
@Comintern thanks
 
NP
My first RD commit ever trashed a bunch of line endings. :-D
 
@Comintern any insight in this? Hoping that your recent work might have knocked it loose and we could close that.
 
11:32 PM
I haven't seen anything like that in debugging. If anything, it should be stale now.
 
@Comintern I must redo the "commit"
?
 
@AlexisDuque What was the message you got?
If you need to commit it again with the new line endings, that's no big deal.
 
@this probably. IME 6.1 isn't on every workstation though.. not sure why, but never had any issues with 6.0, so...
 
Hmm. The reason is that I see 6.0 as buggy and broken. 6.1 is supposed to fix all that's wrong with 6.0
It should e on all workstations for post Win 7 SP1.
 
@Comintern
the comand git add <file> - return warning: LF will be replaced by CRLF in <file>
The file will have its original line endings in your working directory
 
11:35 PM
@Comintern did you remove aggregating from the IR TW?
 
@Comintern sorry for the ping overload -- would you remember off the top of your head if the indenter has a feature to fix the vertical spacing in e.g. this?
 
@AlexisDuque That should be fine.
@this Nope.
 
> This may have been fixed in recent commits, so closing this as stale.
 
@this you're very likely right.
 
hmmm. what's the threshold? I have 100+ results and it's not aggregated.
 
11:37 PM
@MathieuGuindon IIR it will maintain vertical spacing inside procedures.
 
I guess that's where regex replace would shine =)
 
^
 
^^
 
heck, provide a quick regex command for quick clean up
 
11:38 PM
@this Removing the aggregation should probably wait until we have inspection invalidation in place.
 
yeah, I'm just checking one other issue about the aggregation not displaying right text
 
The other option would be to virtualize the grouping, then aggregate as a sub-group, but I'd need to do some research on that.
Wasn't the aggregation issue just that it takes the text from the first inspection result or something like that?
I'm not sure that there's a way to sanely fix that without a complete aggregation redo.
 
:adds 200 more modules:
 
lol
 
yeah it's still an issue. Not surprised.
Didn't hurt to check.
 
11:42 PM
What issue number is that?
I should check to see if I'm remembering it correctly.
 
> Closing this as stale / norepro since we have no information here and lot of things have changed.
[rubberduck-vba/Rubberduck] bclothier project card. Enough said.
> Closing this as stale / norepro since we have no information here and lot of things have changed. If a MCVE can be provided, by all means, reopen.
 
Hmmm... there might be a workaround, but it would depend on a list of specific quick-fixes that wouldn't display dialogs. You wouldn't (for example) want to "quick"-fix a rename.
 
we hae to keep in mind that the aggregation is a hacky work around the performance issues we were seeing.
 
Maybe we need a SlowFix.
The root UX there would be to allow multiple selections with a quick-fix.
That would also involve classification though. I.e. Ctrl-A -> Ignore is an easier problem than Ctrl-A -> Generally Fix.
 
11:50 PM
i'm missing something
this issue is about the description text on the bottom pane being incorrect
what does that have to do w/ the quickfixes & selections?
 
$ git pull https://github.com/D3vlin/Rubberduck
Return:
From https://github.com/D3vlin/Rubberduck
* branch HEAD -> FETCH_HEAD
fatal: refusing to merge unrelated histories
 

« first day (1719 days earlier)      last day (1461 days later) »