VBA Rubberducking

Vogel612

00:01

@Duga I'm not that happy with how the test was changed, because I can't verify the way the option was supposed to work in the first place... I also don't like that there is no added test case...

Duga

REFRESH!

[Minesweeper] 95 Games Played. 49 Bombs Used. 12865 Moves Performed. 17 New Users

[rubberduck-vba/Rubberduck] 60 additions. 0 deletions. 3 commits

[rubberduck-vba/Rubberduck] build for commit 7082d835 on next: AppVeyor build failed

BUILD FAILURE!

Vogel612

00:28

@Duga ah... it seems to be the release creation process

Mathieu Guindon

01:02

ah, the token expired again

Duga

01:17

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created branch rubberduck-vba-releasebot-patch-1

[rubberduck-vba/Rubberduck] web-flow pushed commit b288249e to rubberduck-vba-releasebot-patch-1: Update appveyor.yml

> null

Vogel612

01:37

@MathieuGuindon is the expiration based on date? or on recent usage?

(or rather lack thereof)

Mathieu Guindon

yeah it's date-based (selectable, I put 90 days)

Duga

[rubberduck-vba/Rubberduck] build for commit b288249e on rubberduck-vba-releasebot-patch-1: AppVeyor build succeeded

Mathieu Guindon

my ISP has been "upgrading" my package to some "preview" 1GBps connection. Speed's completely stupid crazy fast and my browser and git are losing random packets!

everything works fine if I turn off the Ethernet adapter and use wifi

I decided I wasn't going to upgrade :D

Duga

02:11

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created comment on pull request #6010: Update appveyor.yml PAT (encrypted)

> :white_check_mark: Build Rubberduck 2.5.2.6111 completed (commit github.com/rubberduck-vba/Rubberduck/commit/7424cbcec5 by @rubberduck-vba-releasebot)

[rubberduck-vba/Rubberduck] build for commit b288249e on rubberduck-vba-releasebot-patch-1: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] codecov[bot] created comment on pull request #6010: Update appveyor.yml PAT (encrypted)

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) Report
> Merging [#6010](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) (b288249) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/9059983548e456c8452218ec

[rubberduck-vba/Rubberduck] codecov[bot] edited comment on pull request #6010: Update appveyor.yml PAT (encrypted)

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) Report
> Merging [#6010](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) (b288249) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/9059983548e456c8452218ec

Duga

02:23

[rubberduck-vba/Rubberduck] codecov[bot] edited comment on pull request #6010: Update appveyor.yml PAT (encrypted)

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) Report
> Merging [#6010](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) (b288249) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/9059983548e456c8452218ec

[rubberduck-vba/Rubberduck] codecov[bot] edited comment on pull request #6010: Update appveyor.yml PAT (encrypted)

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) Report
> Merging [#6010](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/6010?src=pr&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=rubberduck-vba) (b288249) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/9059983548e456c8452218ec

Mathieu Guindon

02:46

bwahaha it was the "register for COM interop" checkbox

Duga

09:15

[rubberduck-vba/Rubberduck] awb95 opened issue #6011: Broken Hyperlinks at Wiki page VB, VBA, VBE and COM References

> see page: https://github.com/rubberduck-vba/Rubberduck/wiki/VB,-VBA,-VBE-and-COM-References

The Hyperlinks to the Microsoft pages:
- VBA language Specification
- Office VBA File Format Structure
must start with https:// instead of http://

The Tech Ed 2000 presentation seems to be dead.

Offline Office VBA Help Files leads to an archived repo with no content but maybe it's accessible through history.

Duga

09:57

[rubberduck-vba/Rubberduck] build for commit b288249e on next: 97.34% (target 0.00%)

Duga

10:17

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Prerelease-v2.5.2.6112

[rubberduck-vba/Rubberduck] build for commit b15503ad on next: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] build for commit b15503ad on next: 97.58% (target 0.00%)

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #6007: Indent fails to indent procedure - cause difficult to find - many commented lines - reserved word perhaps.

[rubberduck-vba/Rubberduck] Vogel612 closed issue #6007: Indent fails to indent procedure - cause difficult to find - many commented lines - reserved word perhaps.

> I'd consider this fixed in the latest pre-release with the merge of 6008, this issue can be reopened when that is not the case :)

FreeMan

11:01

@MathieuGuindon Glad you posted that - it prompted me to go run a speedtest on my machine. I'm getting the same mid-100 speeds with and without my VPN connected. Not good on a 1GB connection. Now I have to call my ISP.

Duga

11:33

> Fix #5929 .
The 'then'-Statement triggered an Indent even tough the line got continued with ':'.
Edited Test for IfThenElseOnSameLine to contain valid VBA Code and check #5929

Duga

11:53

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created comment on pull request #6012: Fix Indent if-then-colon #5929

> :white_check_mark: Build Rubberduck 2.5.2.6113 completed (commit github.com/rubberduck-vba/Rubberduck/commit/0c29367d0b by @awb95)

[rubberduck-vba/Rubberduck] build for commit 1054c585 on unknown branch: AppVeyor build succeeded

Duga

12:42

[rubberduck-vba/Rubberduck] awb95 created comment on issue #5852: Indenter line continuation, alignment

> In think the Indenter does exactly what it should.
As @nVenticDW discoverd the Indention ist dependent on the 'Align Continuation'-Setting

If Enabled the continuation is aligned behind the Assignment Operator (Not as assumend by @Vogel612 at the "="-String)
```
' Ignore Operator
Sub Test()
foo = bar _
& baz
End Sub

' Don't Ignore Operators
Sub a()
foo = bar _
& baz
End Sub

```

If 'Align Continuation' is diabled the continuation is Aligned to th

Duga

13:12

[rubberduck-vba/Rubberduck] awb95 created comment on pull request #6008: Fix Indenter #6007

> This PR fixes also #5355

Duga

15:31

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.SmartIndenter/LogicalCodeLine.cs of pull request #6012: Fix Indent if-then-colon #5929

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.SmartIndenter/AbsoluteCodeLine.cs of pull request #6012: Fix Indent if-then-colon #5929

[rubberduck-vba/Rubberduck] awb95 pushed commit 81d51250 to next: Fix Restore alignment Stack on ')'

[rubberduck-vba/Rubberduck] awb95 pushed commit 12545234 to next: Fix existing Test - wrong Indenter Setting

[rubberduck-vba/Rubberduck] web-flow pushed commit 749024a1 to next

Merge pull request #6009 from awb95/dev-5960-Inconsistant_indentation

Fix inconsistant indentation #5960

[rubberduck-vba/Rubberduck] build for commit 12545234 on next: 97.58% (target 0.00%)

[rubberduck-vba/Rubberduck] awb95 synchronized pull request #6012: Fix Indent if-then-colon #5929

[rubberduck-vba/Rubberduck] retailcoder closed issue #5355: Indentation issues after a complete loop secuence in a single line is commented out.

[rubberduck-vba/Rubberduck] awb95 synchronized pull request #6012: Fix Indent if-then-colon #5929

Duga