VBA Rubberducking

@skiwi gummi anka

@SimonAndréForsberg Testing a new feature?

Duga

[Zomis/Rubberduck] Zomis pushed commit 3b49b8d7 to next: initialized swedish translation by copying the defaults

@Mat'sMug Du har en gummianka?

6:13 PM

@RubberDuck Not really. Figured I could start working on the Swedish translation

OH!

Awesome.

@SimonAndréForsberg you'll have to add an entry for the language name itself, Language_SV

@Mat'sMug I have no clue how to do that.

I also don't have Visual Studio or anything installed, so I can't really test out the translations.

shouldn't be a problem

it's an XML file at the end of the day

when you encounter the Language_EN and Language_FR entries, just copy one and make it Language_SV

what you need to do, is to create a new .resx file

called RubberduckUI.sv.resx

assuming "sv" is the culture code for "Swedish"

Duga

[retailcoder/Rubberduck] ckuhn203 commented on issue #580: TestMethods aren't discovered if their signature doesn't begin the line

> Ping back #570 where this was discovered.

[retailcoder/Rubberduck] ckuhn203 added label critical to issue #581: TestExplorer shows Intialize/Cleanup methods when it shouldn't

[retailcoder/Rubberduck] ckuhn203 commented on issue #581: TestExplorer shows Intialize/Cleanup methods when it shouldn't

> Ping back #570 where this was discovered.

6:25 PM

@SimonAndréForsberg ideally you would also add the Language_SV entry "Swedish" in RubberduckUI.resx and "Suédois" in `RubberduckUI.fr.resx, too ;-)

..but I can do it if you don't

@Mat'sMug I still think you are doing that wrong.

also... when we add new features, we'll bug you for translations :)

@Hosch250 doing what?

The standard is to display each language in its own language.

The language drop-down.

right, I'll change that.

but every resource needs a key in every file

Yes.

Or it just falls back to the default.

6:27 PM

a missing key will fall back ... that ^^

@Mat'sMug You didn't see my commit, did you?

no

oh

lol

@SimonAndréForsberg Be sure to translate the .resx in Next.

yeah the latest stuff is in the 'next' branch

@Hosch250 I didn't even see any other .resx files anywhere else.

6:29 PM

There is this one:

github.com/retailcoder/Rubberduck/blob/master/RetailCoder.VBE/…

How on earth do you translate setter and letter? (let-er, not letter as in 'a')

What do you guys call your property getter/setter/letter?

@Hosch250 oh, didn't see that. I switch to next very quickly :)

get = 'hämta' in Swedish, but 'hämtare' (getter) sounds.... weird.

@SimonAndréForsberg in French I called them accessors and mutators

Swedish tends to incorporate a lot of words directly from English

I haven't been programming much in Swedish :P

6:31 PM

Lol.

I don't even know what a "letter" is in VBA

Me either.

also the "Passed" key is for the way parameters are passed into a method, ByRef/ByVal

Public Property Let FooBar(value As String)

All I know is that none of the refactorings work on the setter references.

it's basically a "property set" for value types

6:32 PM

When it has a getter/letter, it works.

When it is a getter/setter, only the declarations are changed, not the references.

thanks for twisting the metal

;-)

I should probably create an issue...

"property set" is only for reference types

@Hosch250 no need

OK.

the identifier reference code is very very frail and needs to be redone

6:36 PM

ugh, I have to decide where the & should go as well?

Yup.

well, it's xml... has to be xml-encoded..

hadn't realized that

In VS, it is just an & when you use the RESX editor.

the &amp determines the keyboard Alt key shortcut

yes, I know it's for the key shortcut

6:38 PM

if you don't put it, I'll put one in a random spot ;-)

Just be careful that you don't give the same key an & twice in a menu.

doesn't really matter, I won't really use the Swedish version. oh wait...

There you go, @Phrancis, that should do it for ya!

Now, back to FlightRadar to track Mom's flight into town...

@Mat'sMug I notice you haven't translated Rubberduck to French? Should I still translate it to Swedish?

I'd like the menu to say "Rubberduck" in all languages... but feel free to stick a "gummi anka" somewhere as an easter egg if you like

6:42 PM

ok

"petit canard" sounded kinda lame

They call Windows Windows in every language.

did you notice the code inspection easter egg yet?

the original message was going to be "dude, wtf?!"

but then I thought we could make a little tribute to SE

Talking about inspections, the one I did has a bug.

CodeInspections_NumberOfIssuesFound exists in French but not in English

6:45 PM

@Hosch250 they registered it as a trademark, too

It displays the first time, but not other times.

@SimonAndréForsberg ah crap.

@FreeMan Wow, that's really awesome! Let me try it on my machine and make sure it works, most likely you'll have an Accept very soon :)

Sadly, I've gotten pretty good at coming up with contrived solutions like that. Excel forces them.

I have also discovered that you can format multiple nested statements over multiple lines by using Alt-Enter to put a line break in code. Makes them much, much easier to read when you can have indention and multiple lines

It does seem that Excel requires hacks a lot :)

6:51 PM

I used to put long statements into notepad, format them to figure out where I was, fix 'em, then deformat to put it back in Excel. There's actually no need to deformat!

@Mat'sMug type hints is 'indicateurs de type' in French? Is it 'hints' or 'indicators'? Or what is it exactly?

Dim MyString$
Dim MyString As String

^^ same thing

first uses a "type hint"

I had a hard time translating that one

I think I'll first have to translate it into Java before I can translate it into Swedish...

3

WTF is a type hint?

the $ in MyString$

so is it like an alias?

6:55 PM

tells the compiler to declare the variable as a string

I think I will just translate it as 'typhint'

5 mins ago, by Simon André Forsberg

I think I'll first have to translate it into Java before I can translate it into Swedish...

I don't think Java has anything like it

I certainly hope it doesn't.

3

it's a relic from ...gosh, IIRC you declared strings like that in Commodore-BASIC

7:00 PM

Yeah. It goes wayyy back to when bytes in variable names really mattered.

@Mat'sMug looks like English might have that resource string after all, it just weren't at the same position as the french one.

Why don't you have the strings in the same order in both english and french resource files?

no idea

I never looked at the resource files under the hood

maybe they're just sorted differently in the designer

like, one by name, the other by key?

I'm using a file comparison tool to compare them line by line right now

so that I can see both the English and French translations at once

data name="Fix", should that be the verb 'to fix' or 'a fix'?

@SimonAndréForsberg that's the quickfix button, so more like "fix this"

@Hosch250 in the future please prefix resource strings with a bit of context that helps identifying where it's used ;-)

yes ^^

a little comment or something would help a lot in translating

7:07 PM

I think I'm guilty of a few ambiguous ones, too

data name="Type", should that be translated or not?

what does french say?

same as English

(which is why I ask)

if "type" is "type" in Swedish, yeah

"type" is "typ" in Swedish

<value>Two or more projects containing test methods have the same name and identically named tests. Please rename one to continue.</value>
A bit unclear: What should be renamed - a project or a test?

7:14 PM

a test

but indeed, that's ambiguous

feel free to rephrase ;-)

7:37 PM

@Mat'sMug When you edit the .resx files, what do you normally use?

Woot! Thanks for the Accept @Phrancis! Now I can downvote at SU! I'm so... excited?

glad I could help

@Mat'sMug TestExplorer_AddTestModule and TestExplorer_AddTestMethod, are those for 'a test method/module' or 'to test method/module'?

@FreeMan So am I, you have no idea how much time this will save us

Q: Search for column header, copy column and paste to another workbook

this one, however, I'm steering clear of...

-1

I have been playing with some code in a file "masterfile" that will open a folder, and loops through the folder opening each file, copying info from cell J1 to the 4th column in the "masterfile" as well as printing the file name into the first column of "masterfile, and then closes the file. It l...

@Phrancis interesting there's no Product only. Want to manually give it a scan, just to be sure? Seems odd to me, but you probably know your data better and that may be perfectly normal.

@SimonAndréForsberg sorry was AFK for a while.. I just double-click it in VS, it opens, and I... edit ;)

7:54 PM

phew, this seems to have taken me 1h 40 min

@SimonAndréForsberg that's the menu button for adding a test module and a test method, respectively

Duga

[Zomis/Rubberduck] Zomis pushed commit c8b96b06 to next: first version of Swedish translation

@FreeMan That actually doesn't surprise me much, usually if the Product is Wrong, the Brand will be wrong as well. It's due to them adding new products ad-hoc at the store level (it's an electronics retailer)

=IF(A2=A4,F2&"/"&F3&"/"&F4,IF(A2=A1,"",IF(A2=A3,F2&"/"&F3,F2)))

That's how people forget that you can name variables in real languages

They are named variables! They are column/row named!

8:08 PM

a is also a named variable :D

Yes, but A1 describes precisely and exactly what (or rather, where) the variable is :)

@Phrancis I'd guess Worst Buy, but I'm sure you can't tell us, and, phrankly, I don't want to know...

@skiwi If only I could star that more than once...

Something gave up on me here...

@FreeMan ... How... uncanny ;)

Jeroen Vannevel

I just wrote an abomination

3

8:18 PM

@Mat'sMug That one is used in a couple places, I believe.

@SimonAndréForsberg That is probably a noun.

It is the label for a button.

@FreeMan I just confirmed with my admin's data set for the manual data cross reference, and hers did not have one with only Product either, so we're good :D

@skiwi You have almost as many tabs open as I do! You need to invest in the little button:

organize your browser's life into classes! :)

@Hosch250 still, Inspections_QuickFixButtonText would be less ambiguous ;-)

Yes, it would.

Until it is used somewhere else besides the quick fix button.

So, either we create a new key with an identical value, or we give that one a generic name.

Better have a new key with an identical value. It's only identical until it needs to change in one place but not in the other.

8:33 PM

I was doing that at first, but you made a comment about translating something twice.

I suppose I can handle those ones.

8:43 PM

in Tavern on the Meta on Meta Stack Exchange Chat, 1 min ago, by Shog9

I hate ticker feeds. Please never use them.

lol

Don't ya'll just love how Excel silently adds in the maximum number of rows under certain conditions?

in Tavern on the Meta on Meta Stack Exchange Chat, 28 secs ago, by Jason C

@HomegrownTomato You're stuck in a pre-Bill-resignation attitude. The tooltips on the upvote and downvote buttons have since been reversed.

@Phrancis eh?

See y'all!

Bye, thanks again!

8:56 PM

later!

@FreeMan It's all good with my tabs, there is just a backlog of 1400 tabs.

9:33 PM

That Dim text As scalarIn inside the loop is evil. It doesn't do what you think it does. — Mat's Mug 1 min ago

9:50 PM

Huh, so my boss thinks she can just dump this massive manual data cross-reference project on my that she expects me to spend 4 hours every single week looking at a spreadsheet with thousands of rows...

And insist that I don't try to improve it... Hah we'll see about that! Bet I can get it down to 30 minutes instead of 4 hours

then you can spend an extra 3 hours and 30 minutes posting CR answers every week!

Right

She keeps trying to pile more stupid work on me, then realize I can do it 10X faster because I automate manual work

She really doesn't understand than when I'm here for lack of something better to do, I'm actually learning stuff.

10:09 PM

TTQW!