« first day (840 days earlier)      last day (3179 days later) » 

12:00 AM
RELOAD!
There are 1497 unanswered questions (94.3207% answered)
 
@Quill What rot.
 
@Hosch250 Yeah. 'What's your motivation in the office?': well, I'm being paid to do my hobby.
 
@Quill "Oh, I get to be with my mistress all day..."
Yeah ???....
 
Makes me want to do some pair programming
 
I bet we are going to get sent to the Nth monitor.
 
12:04 AM
meh, either way
 
I don't see other room owners around, and I sure don't have a problem with that, so; yeah :)
 
@Duga Is there a plot of this?
 
@IsmaelMiguel Ask @rolfl for the query
 
What query?
 
@IsmaelMiguel the query
 
12:13 AM
For what?
The plot?
 
It just maps unanswered, new users, new posts,
that kinda thing
 
Zombies?
 
Oh
I was asking a plot
 
@Phrancis not because you don't see 'em...
;-)
eh, it's Friday night
 
HELP!!
I just activated invisibles in VS, so I see every space and everything!
How did I do that, and how can I undo it?
210
Q: Why does the Visual Studio editor show dots in blank spaces?

SNAI have a strange bug in the Visual Studio text editor. All my blank spaces are replaced by a "." public class Person { int age; } looks like this public..class..Person.......................... {.................. ..int age;................... }..................... I reset the settings t...

I should post an answer.
 
12:26 AM
78
Q: Show space, tab, CRLF characters in editor of Visual Studio

BohnVisual Studio 2010 Pro: Where are the settings so that the editor can show the space, tab, paragpraph, CRLF, etc. characters? I can do it in NotePad++ though.

 
8
A: Why does the Visual Studio editor show dots in blank spaces?

mehatzri~ FOR VISUAL STUDIO 6 ~ use: ctrl+shift+8 to toggle on/off. (or manualy go to: Edit> Advance > "View Whitespaces") goodluck! Works also for Visual Studio 2008, when Tools/Options/Environment/Keyboard/Mapping Scheme: Visual C++ 6 is selected.

VS 6.0??!
 
Man that's ancient
we're already at 2015.0
 
12:46 AM
...........
per MS marketing dept.
 
^^ LOL.
Also had 28.8k modem as the de-facto, default internet connection.........
Copyright © 2015 1995 Netfirms.
Hello @IntensifierDescriptorMan
 
1:05 AM
As phrased, this is not an appropriate question for Stack Overflow. If you are asking for suggested improvements to your code, you want Code Review (read this guide first!). Otherwise, you should read the questions to not ask and what is on-topic. — Shepmaster 35 secs ago
 
in Cardshifter TCG, 1 min ago, by Phrancis
I need to buy www.FizzBuzz.lol for @Simon and @Mat'sMug :)
 
@Quill that was a nice answer you left on Meta.SO
 
@RubberDuck Thanks.
 
Has anybody made a VBA FizzBuzz, BTW.?
 
@Phrancis Two memes in one statement?
Or would it be three?
 
1:12 AM
Hey, an Outlook script would be fun, where it counts the words in your emails and replaces the words by Fizz, Buzz and FizzBuzz accordingly.
Certainly would make the old inbox a bit more fun
 
Lol. That would be fun.
0
A: 10 Million Questions - Let's Share Some Stories That the Number Doesn't Convey

RubberDuck How to create a read-only property exposed to COM? I posted the question and the answer, but Hans Passant is the real hero here. I was working on a COM library to be consumed by VBA. I'd never done anything like this before, so needless to say, I spent a good amount of time digging around ...

 
Run it on your coworker's computer and make them think the new client is an absolute looney.
 
O. M. G. I have Outlook on my work laptop. And I want to write a script to aggregate some information based on the word content of some emails. Now I have a legit excuse.
 
That would be awesome.
 
Wait wait, that's RubberDuck using Stack Overflow as a rubberduck while working on... Rubberduck. Awesome! — Mat's Mug 11 secs ago
 
1:18 AM
@Mat'sMug meta meta meta
 
You bunch of quacks ;)
 
=;)-
I was working on Rubberduck too. That was just at the beginning of the Git library.
 
3rd link
 
Zak
hw to post photos in chat?
 
As much as I hate SO sometimes, writing that gave me the warm & fuzzy feels.
 
1:21 AM
hey @Zak, saw you earlier today - welcome to The 2nd Monitor / Code Review!
if you have a url, just paste it
or click the [upload...] button
 
@Zak just post a link that ends in an image extension.
Or that ^^
 
Zak
not quite
 
remove the querystring part after .jpg
 
oh well
 
1:23 AM
http://i.imgur.com/3UuKbN8.jpg
 
Zak
ooh awesome
anyway
this, is not my cat 0.0
 
so you write VBA?
 
Zak
yep
 
~hides~
 
@Phrancis lol, you're surrounded!
 
Zak
1:24 AM
I know some basic javascript
messed around with HTML a decade ago, so what little I remember is most likely out of date
But I've spent nearly a year now doing spreadsheet stuff with vba, so I'm halfway competent
 
Certainly a useful skill to be able to manipulate Excel under the hood, IMO
 
definitely
 
0
Q: How to write concise and safe Rust code?

antoyoI started to learn Rust some time ago and I wonder if there is some way to write Rust code that is both concise and safe. Let's see an example. I wrote a software to generate random bookmarks and save them to a file, both in Rust and Haskell to compare. First, I'll show you the Haskell version:...

 
Zak
company I work for is in finance and investments so yeah, EVERYTHING runs on spreadsheets
 
@StackExchange Should this be on meta....?
 
1:27 AM
@StackExchange huh?
 
@StackExchange How to write concise and useful titles?
 
Zak
though I still shudder when I remember my first ever code
no declarations, just 12 nested if statements attached to a button
3
 
Lol
The way first code should be I guess.
 
@Zak Did you color it red and label it "DO NOT PRESS"?
 
Zak
nah, I don't think the button even had a label :)
it's probably still buried in the archived servers somewhere
 
1:30 AM
Rem HERE BE DRAGONS
 
Zak
I write code that looks halfway professional these days
but this is still a thing that happens
 
I bet it's itching @RubberDuck as well... have you heard of ?
 
Zak
damned photo
 
Private Function LPad(num)
    Select Len(num)
       Case 1:  LPad = "0000" & num
 
Zak
someone mentioned an upload button?
 
1:31 AM
yeah
 
@Phrancis Obsolete comment syntax detected. Would you like me to fix that for you?
(Of course I can't, but a moderator could.)
 
next to [send], to the right of the input box
 
I wish I was kidding, but my first code looked something like that up there.
 
@Zak Might be easier if you click the 'upload' button and choose 'From web'
@Hosch250 Thanks Clippy ;p
 
Nope, RD.
RD has an inspection for that. Just as @Mat'sMug.
 
Zak
1:33 AM
where is this magical upload button?
 
@Hosch250 I know, I saw when you guys made it, goofball ;)
 
@Zak You might not have it. You have to have a certain amount of rep.
 
Zak
ah, that'll be it then
 
But, it should be next to the Send button.
 
Zak
yep, not there
 
1:34 AM
That might also be why chat is not oneboxing photo links
 
I just added http://www. in front, and it worked
 
@Phrancis Maybe, I think that is because he didn't use the .png.
 
@Zak Reminds me of my old workplace
 
lol, just noticed "# times I've crashed Excel today"
2
 
Zak
I made the mistake of sharing Companies House' new open data policy
 
1:36 AM
 
Zak
the directors decided it'd be cool to filter every company in a 50-mile radius by their last corporate account filing
that covers about 25% of all the countries in the UK
companies
 
When a @jonskeet answer isn't quite good enough, I'm #SOreadytohelp http://stackoverflow.com/help/badges/62/populist?userid=2792531
 
That's a lot of companies
 
Zak
so about 3 Million accounts across 2 years. and another 9 million to wade through to get there
 
@Phrancis or maybe just 2ndmonitor.com
 
1:38 AM
@nhgrif you're supposed to link to your profile
 
www.2ndMonitor.lol
 
Zak
when you find yourself hitting excel's row limit, you know things aren't going to turn out well
2
 
@Zak or that you're using Excel as a database
2
 
What are you doing that for?
 
Zak
true, but I haven't the first clue how to go about using a database :)
and it's basically just one giant list
and a load of giant folders
 
1:39 AM
Oh! oh! I love databases
 
you remind me of myself 10 years ago.
2
 
 
@Zak Sounds like a database to me.
 
@Mat'sMug I linked to the badge?
 
 
1:39 AM
you did :)
 
Zak
in fact
1
Q: Matching between files and a list of filenames at scale

ZakGiven a folder typically containing ~250,000 small (20-100kb) files in HTML format (they open as single-sheet workbooks in Excel) and a list of ~ 1 million filenames, I need to open all the files that match the list and Do Stuff. Overview of Main code Loop: "Test 1 Start" to "Test 1 End" Once we...

that's it
 
@Mat'sMug I linked to my earning of the badge.
 
yeah that
 
> ?userid=2792531
 
I guess it's good enough
 
1:40 AM
user image
3
 
no way
 
31 mins ago, by Phrancis
in Cardshifter TCG, 1 min ago, by Phrancis
I need to buy www.FizzBuzz.lol for @Simon and @Mat'sMug :)
 
@Zak that code needs better indentation and fewer comments
 
Zak
in my defence, it was mostly written 6 months ago :)
 
1:42 AM
Even Access would be an upgrade over storing so much data into Excel
 
Zak
I'm a lot more acquainted with best practices now
 
@Phrancis (emphasis on "even")
 
Zak
access is next on my list of things to figure out how to use
 
@Zak Might want to start sooner rather than later :)
 
Zak
it's workable in its current form
and I sincerely hope work can't find something even larger to work on
 
1:44 AM
Well, you have not experienced the joys of set-based data sets, evidently
 
Zak
but yes, there are lots of things I don't know I don't know
 
@Zak skip access and go straight to SQL Server. Much less painful.
 
@Zak that's exactly how I went about it. Excel > VBA > Access > SQL > SQL Server > C# & .net > screw VBA > more C#, more .net > get a VB6 programmer job > implement .net stuff in VB6/VBA > screw the VB6 job > ...
2
 
That ^ sounds about right.
 
7 mins ago, by Zak
so about 3 Million accounts across 2 years. and another 9 million to wade through to get there
 
1:45 AM
I'm in the "I hate VB.Net" stage right now.
 
That's a trivial amount of data for any database worth its salt
 
note, I never had a VB.net stage
@Phrancis except MySQL
 
You're not missing anything. God Webform websites are awful.
 
morning all
 
MySQL could handle that fairly easily. Just with more headaches for the DBA ;)
 
Zak
1:46 AM
probably :)
 
hi @mplf!
 
Hey there @mplf.
 
Zak
I spent a week in Blackrock's analytics division (London) when I was at uni
 
hello. how is everyone?
 
@RubberDuck ASP.NET is ASP.NET in C# too ;-)
 
1:47 AM
@mplf Good good!
 
@mplf been worse :)
 
1
Q: Netscape bookmark file generator

antoyoI started to learn Rust some time ago and I wonder if there is some way to write Rust code that is both concise and safe — in particular, avoiding unwrap(), casting functions and try!(). Let's see an example. I wrote a software to generate random bookmarks and save them to a file, both in Rust a...

 
Zak
ALADDIN runs $15T of investments and has a dev. budget of £500M a year. It was REALLY cool to muck around with
 
@Mat'sMug the answer to that is more alcohol
 
@RubberDuck That's what I work on, for the moment
 
1:47 AM
Yeah @Mat'sMug, but asp.net is worse in VB.Net
 
@mplf Speaking of which... beer ight back!
 
@Quill web sites or web apps?
 
@RubberDuck websites
 
My condolences. They're terrible abominations.
 
haha
 
1:49 AM
@Phrancis haha well it is nearly 3am so mines a vodka.
 
lol. we're implementing a ground up replacement in MVC soon anyway
 
At this point, I'm just compiling C# dlls and calling the library code.
 
Zak
maybe I should share my questions in chat more often :) my rep just doubled in the last 10 minutes
 
@Zak I don't know what you're talking about
 
Zak
though admittedly, not exactly hard when it's still in only 2 digits
 
1:50 AM
Just don't over do it. =;)-
 
Zak
oh damn.
 
@Zak Overdoing it is fine as long as they are the right questions /cc @RubberDuck
 
Zak
just forgot I've got 19 multi-accounts I've been neglecting for the last hour
 
eh, I've had Rubberduck opened in Visual Studio for about an hour. lines of code written: 0.
 
1:51 AM
To be fair, it's a good question. I'm not sure how I missed it. Absentee room owner I guess...
It's ok Mug. Winter is coming.
 
@Mat'sMug Did I tell you about the dynamic query I got working yesterday? First time seriously using DSQL (and cursors) but managed to build the skeleton of something that will do exceptions record-matching across 22 DBs or so.
 
@RubberDuck did you see this? we're up to 89 now!
 
Cursors!? blasphemy!
Oh! Nice.
 
starred VBEX as well
 
@RubberDuck Well, I feel sure my DBAs prefer that I query a bit of information on one server at a time and release, rather than keep 22 connections open in a transaction ;)
 
1:54 AM
@Mat'sMug lol. I forgot to star before
 
OMG!! we're 10 stars short of 100!!!
 
I just shove the data I need into a temp table and then do everything from the same spid
 
Zak
question / request for those of you who know VBA. I'm currently re-writing this using my best interpretation of TDD and the phrase "refactor mercilessly". When I'm done would anyone be willing to do an in-depth review of it?
3
Q: Automating the aggregation and filtering of an 8-worksheet spreadsheet

ZakEvery piece of business that gets written (E.G. an adviser's client puts an additional £10k payment into a pension plan) goes in a spreadsheet called the SubSheet. It's split into 8 worksheets for different kinds of business, each with lots and lots of columns. E.G. "Adviser" "First Name" "Invest...

 
Someone should really consider hiring new DBAs where you're at.
 
Zak
what are stars?
 
1:55 AM
GitHub stars
the SE equivalent of upvotes :)
 
what's getting GitHub stars?
 
@Zak I actually have that favorited for an early morning review.
 
@Zak RD is pretty good at reviewing VBA.
@mplf Rubberduck, of course!
 
@RubberDuck no you don't - that fav is mine!
 
I have a love hate relationship with the comments in that code.
Nonsense... Check again. Lol
 
1:57 AM
The purpose of the code, as I understand it, per your description seems to be easily accomplished with a pivot table. That, or you need a database, not excel. — Raystafarian 2 days ago
 
Zak
I honestly had no idea what pivot tables were until I read that comment
 
Comment blocks like that seem like a great idea early on in your career, but they burn you sooner or later.
 
pivot tables are Excel's most powerful and useful feature
 
Zak
honestly, I'm still just trying to learn good habits atm.
up until a couple of weeks ago, I'd never heard of CamelCase
 
idk. PasteSpecial >> Transpose...
 
1:59 AM
Rubberduck 1.3 code inspections would flag these Call statements as obsolete. The inspection somehow got broken in the 1.4 release though
 
Zak
and I'm only just getting it through my head that things should be broken down into single-operation subs/functions as much as possible
 
@Zak that's PascalCase - camelCase starts with a lowercase ;-)
 
Zak
and they should (generally) be designed to be as re-usable as possible
 
@Zak On a related note, can the close voters redact their vote seeing as the code is now included
 
@Phrancis That depends on your DB server config and how you're querying it. Although I agree, 22 queries in one transaction is excessive
 
2:00 AM
@Zak I sure could write a review - use reasonable names.
Dim I                                   As Long         '/  General counters
Dim J                                   As Long         '/
Dim K                                   As Long         '/
And with all those arr's, you look like a relation of Long John Silver.
 
that alignment is a PITA to maintain
arr -> "pirate notation"
 
0
A: 10 Million Questions - Let's Share Some Stories That the Number Doesn't Convey

nhgrifJon Skeet isn't an expert at everything. I always seen excellent answers from Jon Skeet. He is a legendary contributor to the site. His answers always strive to explain the why behind the problem, and for someone like myself who strives to collect as much knowledge about their profession as po...

 
Zak
this I have noticed :)
 
Zak
but it's not too onerous. yet.
 
2:03 AM
Hey, since when is Office Dev open-source on Github?
 
Continuing with the joke, you have a bunch of lng's too.
 
@Zak you have an interesting mix of good and bad habits. I think you'll be a fine programmer. Just gotta break the bad ones and reinforce the good ones. I'll definitely review that in the morning.
 
Zak
pitfalls of being self-taught in a company with nobody more experienced to leearn from
if you want to hold off 24 hours or so
my re-write will hopefully be finished by this time tomorrow
 
@Phrancis wut?! that's pretty cool! (it's the documentation that's up btw)
 
Yeah I know, still nice
'/  Change Log:     | Author            | Date          | Description of Changes
Indicator of a problem, to me :)
 
2:06 AM
@Phrancis source control in VBA is ...marginal
 
Not so much a code smell, as more of a red flag that you need a VCS
@Mat'sMug You could just use Github like everyone else, ya know ;)
 
@Mat'sMug Hey, didn't @RubberDuck just write it for Rubberduck?
 
Zak
yeah, I figured that one out a week ago :)
still trying to work out how to work github :)
 
Use RD! It has SC built in.
 
@Hosch250 RD 1.4 has GitHub source control indeed.. it's more of a "beta" feature though at this point
 
2:07 AM
There are plenty of experts on Github here
 
@Hosch250 yeah, but the library is still more reliable than the add-in at this point.
 
Zak
I managed to get my vba into a repository,but couldn't figure out how to edit the code IN github
 
Local source control works good. I know, because I tested it and killed the bugs with my own [somewhat less than] fair hand.
 
Heh... I wonder if I can go fix the VBIDE docs now...
 
+ BitBucket if you prefer the Atlassian route (Disclaimer, I have code in both)
 
Awww man. I should probably be supporting bit bucket too.
 
@Zak Two ways, you can use the command terminal on your PC (i.e., the git part of github), or make changes using the website (the hub part)
 
use GitHub for Windows, works great
 
GitHub for VS works better.
 
@Hosch250 not for VBA
 
2:09 AM
Easier said than done in VBA. You need a way to get the code from the host document into the file system & back.
 
You still have to use the command line.
@Mat'sMug No...
 
SourceTree FTW
 
I wonder if I can even open a VBA project in VS.
Probably not.
 
Well, you could just copy your VBA scripts into folders on Github as text files
 
it'll think the files are vb.net, and the compiler will blow up
 
2:10 AM
@RubberDuck there is no win in SourceTree. Just Source and a Tree, mutually exclusive ;-)
 
You don't need the compiler to commit, though, I shouldn't think.
 
no, but it's ... well, it's a hack :)
 
Zak
ah screw it. I'm not getting any sleep anyway. think I'll just head into the office now and get an early start on re-coding my project.
 
Zak's IDE is throwing a warning for undefined symbol: weekend
3
 
^^
interesting feature request:
4
Q: Can we have an "edit question" magic link for answer comments?

durron597Yet another request for a magic link. In the following situations: I answer a question, the asker replies to me in a comment, and I want to reply to them asking them to edit certain information into the question The asker adds extra information as an answer instead of an edit I want to give t...

> feel free to [edit/q] your question to add foo into bar
 
Zak
2:16 AM
@nhgrif especially since nobody's going to know I've been in and I don't get paid by the hour.
but hey, coding is fun
well
can be fun
does mean I have to chuck out mystery cat though
 
If I come in on a Saturday, I trip an alarm and cops get me out
Not that I tried
> but.. I work here, officer!
 
Ohhhhh. I remember those days. Now when I code for fun I do it for the good of the community. Or just for fun.
3
 
Zak
:)
I like learning how stuff works
and I like stuff that makes internal sense
 
I think most good programmers do.
That is why they are good.
 
Zak
and I like being able to do stuff that's magic to other people
3
I think my best thing
 
2:20 AM
programming at work is too much hastle. Nobody cares about quality or standards and those who do are told to shut up
2
 
If you want to do stuff that's magic, .
@mplf You work at the wrong place.
2
 
coding for the community is a matter of pride.
 
I like how I was once told "you can't implement a real rename refactoring for VBA" - and then did it
 
And I fixed it.
Except for one unit test that is failing :(
 
Zak
was somebody wanted to modify our recorded business spreadsheet to auto-send certain columns from user-defined lines in an email to our investment team. I had never done any vba in outlook before. I turned around 7 minutes later and gave them a finished macro :)
 
2:21 AM
Meh
 
Hehe, you did the real work.
 
@Mat'sMug I thought I was moving on to something better. Turns out I was wrong, oh so wrong. And I AM the standard there. Turns out, the standard is nothing more than a rubber stamp actioned by senior mangement
 
Actioned, do you mean Sanctioned?
 
Zak
mystery cat update: It's found my cupboard and has promptly burrowed into my clother-pile
 
@mplf If you are an American, and know Java web, Ruby-on-Rails, Android, or iOS, I might be able to get you a job.
 
2:22 AM
sorry, that was tagged to the wrong person @nhgrif
seems I might have had a little too much vodka...
 
@mplf I know your pain
@mplf I know your pain lol
 
What's the commit strip about too much vodka and Russian Roulette on prod servers?
 
@Hosch250 search 'russian roulette'
 
@nhgrif I'm a Brit and I know Java, PHP, Python (some), Bash, Go, Ruby and some C#
Mostly tho, I'm Dev-Ops
 
@Zak Nice looking cat.
We had one cat adopt our family that was so sweet it wouldn't even hunt the birds under its nose.
Some family members are allergic to cats, though, so we didn't keep it.
 
2:27 AM
1
Q: Animate each list item in order - one after another (custom animation)

dvLdenI was wondering what the proper way is of animating each element, whether it's span, div, li, img... It doesn't really matter, but in this case, I am trying to animate list items ul > li with custom animation that I found on the web. It is basically created for animation of a single element's te...

 
@Mat'sMug Vodka isn't the pain, that would be the Ricard I've just moved on to. Hello hangover
 
May 26 at 15:13, by Quill
@RubberDuck I have 7
 
We have 4 dogs. One for each of us adult kids.
 
Damn you Rubberduck. You crashed VSDiagnostics because of your funky nested blocks
 
in VSDiagnostics, 1 min ago, by Jeroen Vannevel
It crashes on public string Name { get { { return "ParameterCanBeByValInspection"; } } }
 
2:31 AM
@Hosch250 it's not Russian Roulette until you add the kahlua so probably 5:1 odds
 
@JeroenVannevel scoping issues?
 
No, I just don't expect people to put their return statement in a getter in a block
So I immediately casted it to a ReturnStatement
which causes a slight issue when you have a BlockSyntax
 
that'd call for a "remove redundant scope" inspection/fix
 
Got dishes to do. Let me know how things work out with VSDiagnostics.
 
2:36 AM
I have some bourbon and some CSS to do. Should be a fun rest of the evening ;D
 
@JeroenVannevel R# does it ;-)
 
We'll get there!
 
I know you will
 
Oh boy. A using() statement inside a method counts as 1 statement, even if that wraps 20 lines of code
that's a nasty one
 
Evening. Finally.
 
2:45 AM
@JeroenVannevel interesting. same with if() ?
what about while() and everything else that defines a scope?
 
let me write up a test scenario
Yep, both if and using
so I assume the others as well
I'll add a block to the tests as well
aaand that one as well
I guess that explains it then
 
Anyway, there was a reason I came in here tonight. A week ago I posted a clock for review. I thought maybe a few of you might be interested to see how that clock has evolved (and the real reason I had for writing it)... (maybe it's not perfect but apart from missing unit tests I am very happy with it) :-) github.com/mproffitt/PyKryptos/tree/develop
 
0
Q: Mergesort Linked List

thesillycoderProvide an implementation to sort a linked list using MergeSort. Can you please critic my code and provide your thoughts on where I should improve my code. import java.util.Iterator; import java.util.NoSuchElementException; public class LinkedList<T extends Comparable<T>> implements Iterable<T>...

 
@mplf Looks nice! I'll read up on it tomorrow after I had some rest
 
I reviewed your code using OS X, by the way.
 
2:58 AM
that's fantastic, I have no access to OS/X so was only guessing through past experience that it worked on that platform :)
 
Python works on most platforms unless you do terminal/cmd commands
 

« first day (840 days earlier)      last day (3179 days later) »