« first day (1760 days earlier)      last day (1420 days later) » 

12:01 AM
RELOAD!
[bruglesco/FleetCommand] 1 commit. 18 additions. 6 deletions.
[rubberduck-vba/Rubberduck] 6 issue comments.
[Zomis/minesweeper-flags-client] 2 commits. 40 additions. 16 deletions.
[Zomis/minesweeper-server] 2 commits. 26 additions. 13 deletions.
[Minesweeper] Games Played: 117, Bombs Used: 81, Moves Performed: 15978, New Users: 7
 
 
2 hours later…
1:59 AM
Interesting - this is from MZ-Tools update:
> MZ-Tools 8.0.0.1578 released (April 1, 2019)

- Enhanced [#13886] (All): A warning is now shown if a toolwindow is too small.
 
So they hear what we heard of the problem? @this
 
I presumed that they had the same problem themselves where toolwindows randomly opens too small.
wut. Just visited SO. O_O
LOL
 
 
9 hours later…
10:49 AM
Just ordered a mod for my laptop. 1080p, here I come :-)
 
11:19 AM
New monitor for a laptop, @mansellan?
Also, thank GOD the April Fool's formatting isn't applied to chat
 
yea, I'm very glad they didn't pull it over to mod tools either.
btw: 424 downloads for the green release
2
 
11:40 AM
@FreeMan yep, replacing the useless TN panel with a 12.5" IPS from LG. The mod looks a little tricky though, hope my soldering skills are up to it!
 
11:53 AM
Impressive. I'd have never though to replace the screen. Especially since soldering is involved! (My soldering skills were never up to a task like that)
 
12:30 PM
@Vogel612 wah that's... fast!!
428
 
@Duga That's surprising, considering that the interface is supposed to be a reference type.
 
@this I was surprised, too.
 
1:11 PM
> **Rubberduck version information**
Version 2.4.1.4627
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4813.1000
Host Executable: MSACCESS.EXE


**Description**
Members _within_ a module _are_ sorted according to the sort option setting, however, the modules themselves are _not_ sorted by this setting.

**To Reproduce**
Steps to reproduce the behavior:
1. Using the `'@folder` annotation, put several modules in an RD folder
2. C
 
1:44 PM
Ahhh bliss ...
Windows is actually properly respecting the CPU usage bound I've given it
and that means my CPU isn't overheating anymore \[T]/
now I only need to find a way to turn off CodeAnalysis running on test builds...
 
@Vogel612 was that a "praise the sun" emoction?
 
why yes it was :)
 
I hope you get further than me - last time I looked, it doesn't look trivial. :(
FWIW, I'd want to keep RD's custom code analysis on at all time.
 
there should be a way to skip analyzers, I just need to find it
sigh.... it still doesn't work ...
dammit
ugh... I uninstalled IntelliJ from this machine.
 
1:56 PM
hmm ... I may have been missing a single space in my test cases...
 
2:08 PM
weird... tests for Templates fail for me locally...
 
localization strikes again?
 
I thought so at first, but it doesn't seem to be the case...
I'll open the PR and see whether Duga shouts at me
 
> Note that this doesn't enforce the same constraints as the VBE when parsing the lineSpecialForm. Most notably, the form `foo.Line -(x, y),` does not provoke a parser error, even though it does not compile.

The grammar should correctly deal with all cases that do compile.
 
2:38 PM
wow... i didnt realize that VBA supported this...
For Each c In Controls
  If TypeOf c Is CheckBox Then
    c.Value = False
  End If
Next
it can handle typeof
i just didnt even think that something like that would work
 
too many people use TypeName() or VarType(), and never get to know about the TypeOf operator.
Even though TypeOf is better --- it can tell you whether you are dealing with a ADODB.Recordset or DAO.Recordset; TypeName() only gives you a Recordset which is unhelpful.
 
Helpful to know that.
 
[rubberduck-vba/Rubberduck] build for commit 2c2512d3 on unknown branch: AppVeyor build succeeded
 
i had no idea.
 
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4884?src=pr&el=h1) Report
> Merging [#4884](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4884?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/2925035f5210cb7f56792554a43f6e44052acb82?src=pr&el=desc) will **not change** coverage.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #4884 +/- ##
=======================================
 
2:43 PM
ima link it again... pgacon.com/…
 
[rubberduck-vba/Rubberduck] build for commit 2c2512d3 on unknown branch: 64.53% (target 0%)
 
its a large part vb6
 
@Duga I'm somehow not surprised that the test failures are only local
 
but there is a lotta stuff that works for vba in it
 
it also helps to realize that TypeName() and VarType() are built to work with variants specifically and was never meant to be used as a general purpose reflection function.
@Vogel612 what was the error you got?
 
2:44 PM
different depending on which of the 5 failing tests you want to know?
 
oh my.
heck, put it all up here.
 
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4884?src=pr&el=h1) Report
> Merging [#4884](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4884?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/2925035f5210cb7f56792554a43f6e44052acb82?src=pr&el=desc) will **not change** coverage.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #4884 +/- ##
=======================================
 
BuiltInTemplate_ExistingFile_NotCreated:
Message: Moq.MockException :
Expected invocation on the mock once, but was 0 times: h => h.Exists
No setups configured.
No invocations performed.

---

BuiltInTemplate_File_Autocreated:
Message: Moq.MockException :
Expected invocation on the mock once, but was 0 times: h => h.Exists
No setups configured.
No invocations performed.

---

BuiltInTemplate_ReturnsCorrectCaption:
Message:   Expected string length 40 but was 20. Strings differ at index 0.
  Expected: "Klasse mit PredeclaredId-Attribut (.cls)"
^^ there you go
 
this smells like a localization problem
the giveaway is that IsUserDefined is true.
it's as if it's not actually picking up the template correctly from the resource file
 
hmm ... I have no clue what that code does where and how, but I'll trust you there :)
 
2:56 PM
Hmm, the test is supposed to read this:
 
lol ...
 
IIR, the name property was meant to be a way to select the template file.
it's actually not for human consumption (that's why we have the caption resource)
hmm or did they wanted to localize hte file name, too?
need to dig that PR/case out.
 
3:11 PM
if it was intended for localization, the template selector needs to be aware of the currently used locale
 
yeah; not sure which way should go but have to pick one or other.
 
I'm having images of biting a colleague now.
It's his fault. He said "you bit me" instead of "you beat me" (about posting a link before he asked for it).
 
I assume that's not really what you want to have images of?
 
Not really, LOL.
5
A: Single word request for ..love-ditsy

Patrick MHolding a flower with a smile plastered on her face? Sounds like she might be twitterpated North American informal 1. Infatuated or obsessed: Gus is still hopelessly twitterpated by Lee smiling into each other’s eyes, a seemingly twitterpated couple glided 1.1 In a sta...

LOL, my family uses "twitterpated" too.
 
tbh, the word makes me think that we're making a pate out of twitter.
 
3:21 PM
Your head's in a whirl. Next thing you know, you're walking on air!
And you completely lose your head!
(Quotes from that scene from Bambi.)
 
alright, that's what I call a productive afternoon :)
Happy reviewing :)
 
Why'd you remove all the categories?
 
added one at the top of the file instead
removes redundancy and makes adding new tests easier
 
MEH freaking gitlab addon for VS2017
 
3:36 PM
Oh, nice.
 
it has told me its had an update for a couple months now, wont let me update it. i finally got off my butt and uninstalled it
so i can update it.
 
3:52 PM
posted on April 01, 2019 by CommitStrip

 
[rubberduck-vba/Rubberduck] build for commit 007aa433 on unknown branch: AppVeyor build succeeded
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4885?src=pr&el=h1) Report
> Merging [#4885](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4885?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/2925035f5210cb7f56792554a43f6e44052acb82?src=pr&el=desc) will **decrease** coverage by `0.01%`.
> The diff coverage is `100%`.


```diff
@@ Coverage Diff @@
## next #4885 +/- ##
=========================
[rubberduck-vba/Rubberduck] build for commit 007aa433 on unknown branch: 64.53% (target 0%)
 
I'm decidedly over SO april fools 0.2 seconds in...
 
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4885?src=pr&el=h1) Report
> Merging [#4885](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4885?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/2925035f5210cb7f56792554a43f6e44052acb82?src=pr&el=desc) will **decrease** coverage by `0.01%`.
> The diff coverage is `100%`.


```diff
@@ Coverage Diff @@
## next #4885 +/- ##
=========================
 
@IvenBach Same.
 
Glad they have an easy way to undo the "FUn"
 
4:09 PM
coughunicornistcough
 
Spring allergies already hitting you?
 
I don't have allergies.
 
4:26 PM
Ebola-chan just got to him :P
 
 
1 hour later…
5:44 PM
@Feeds apparently, CommitStrip & SE had the exact same idea!
 
5:58 PM
@Vogel612 The template tests should be fixed in my PR.
 
@Hosch250 Having gone through the WinForm examples I now appreciate WPF more. A lot better idea as to what the hecks going on too.
 
 
2 hours later…
8:23 PM
> **Rubberduck version information**
The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box:

Version 2.4.1.4627
OS: Microsoft Windows NT 10.0.17134.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11328.20222
Host Executable: EXCEL.EXE

**Description**
On Error Goto -1 is a legitimate statement to clear a previous On Error statement
See https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/statements/on-erro
 
@Duga hmm that's interesting. I wonder if somebody updated that doc.
pretty sure it was not documented when I looked
Besides, it's still a code smell if you have to use it.
facepalm
Use the breadcrumbs, Luke
 
@Duga bwahaha
 
@Duga LOL. How fitting.
 
> Thanks for reporting! I'm not sure if you saw the entire message (or perhaps a separate inspection):

```
While this is legal, this is poorly documented "feature" that means something different -- the error state is also cleared in addition to disabling any error handling. However, this can be ambiguous as a negative line label of -1 may end up as a target and excessively complex error handling usually indicates a need of refactoring the procedure.
```

The linked documentation is actual
> Thanks for reporting! I'm not sure if you saw the entire message (or perhaps a separate inspection):

> While this is legal, this is poorly documented "feature" that means something different -- the error state is also cleared in addition to disabling any error handling. However, this can be ambiguous as a negative line label of -1 may end up as a target and excessively complex error handling usually indicates a need of refactoring the procedure.


The linked documentation is actually for
> The title of the page you linked to is **On Error Statement _(Visual Basic)_**.

Note also references to: `Whenever possible, we suggest you use structured exception handling in your code, rather than using unstructured exception handling and the On Error statement. For more information, see Try...Catch...Finally Statement.`
Also references to: `Throw Statement`

That's _not_ VBA, which is what you're using in Excel.
 
I bet ThunderFrame would have loved that his inspection got a report today on this day.
7
 
8:35 PM
> I am a bit confused here. Where exactly is it relevant that the commands are transient? As far as I know, they are all injected or constructed inside the constructor of a view model. I do not think that we use factories for them.
 
@this Indeed he would have!
 
> Commands are explicitly marked as transient during the registration for example here:

https://github.com/rubberduck-vba/Rubberduck/blob/9afe3bb26688ebbd107edd54e4e51a1cbe0ba9c9/Rubberduck.Main/Root/RubberduckIoCInstaller.cs#L733-L745

Other objects such as `ParentMenuItems` are similarly registered with same lifecycle.
 
AFAICT any On Error statement resets the current error state. On Error GoTo -1 seems to suppress error handling exactly like Resume Next does.
 
no
 
8:50 PM
missing something
 
AIUI, if you used it outside the error handler, it's no different from On Error GoTo 0
the real difference comes in what happens inside the error handler
you've probably seen SO questions where they find that changing error handler while handling an error do not work
 
no, actually coding scrap code to figure it out
 
there, the -1 would actually clear the error and reset the state
gosh we need a VBAFiddle....
 
Sub test()
    On Error Resume Next
    Debug.Print "Before resume next:", Err.Number
    Debug.Print 42 / 0
    On Error Resume Next
    Debug.Print "After resume next div/0:", Err.Number
    Debug.Print 42 / 0
    Debug.Print "After resume next div/0:", Err.Number
    On Error GoTo -1
    Debug.Print "After goto -1:", Err.Number
    Debug.Print 42 / 0
    Debug.Print "After goto -1 div/0:", Err.Number
    On Error GoTo 0
    Debug.Print "After goto 0:", Err.Number
    Debug.Print 42 / 0 'throws
the only error thrown here is the div/0 after GoTo 0
GoTo -1 behaves exactly like Resume Next
 
try and compare those 2
Public Sub x()
    On Error GoTo Oops

    Debug.Print 1 / 0

    Exit Sub

Oops:
    On Error Resume Next
    Debug.Print 1 / 0
End Sub

Public Sub y()
    On Error GoTo Oops

    Debug.Print 1 / 0

    Exit Sub

Oops:
    On Error GoTo -1
    Debug.Print 1 / 0 'INFINITE LOOP!
End Sub
 
8:55 PM
thanks for the warning :)
 
you will see that in the first case, the On Error Resume Next has zero effect; you get a break dialog.
 
so the difference is an undocumented nefarious effect in error-handler subroutines
 
but with the second case, it basically resets everything.
Yes.
come to think of it, the VB.NET documentation doesn't really suggest that.
> GoTo 0 Disables enabled error handler in the current procedure and resets it to Nothing.
GoTo -1 Disables enabled exception in the current procedure and resets it to Nothing.
 
maybe they "fixed it" in VB.NET
 
Could be. Still, it's a dumb thing to use.
 
8:58 PM
^
 
> My point is that being registered as transient does not mean that the object gets created later than other objects or even once after the initial resolution of the object graph. All it means is that a separate object gets injected at each injection point.

So, if there is no automagic factory providing commands, all injected commands are there after the initial resolution.
 
I mean, if your error handler is so complex to warrant a legit use of On Error GoTo -1, you most likely need to refactor it, not use it....
@Duga but how does that prevents us from not having a command that is created after the event?
I don't see that guarantee, even if all objects were simply caching their commands. That means I have to walk up all consumers' tree to ensure that commands are not injected in a transient object.
 
wah, long-timer here
 
@this You mean, in an object resolved later, right?
 
> Here's the documentation for the `On Error` statement *in VBA*: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/on-error-statement

Note that `GoTo -1` isn't one of the documented options, and experimentation leads me to believe that in VBA `On Error GoTo -1` is indeed legal, but behaves exactly like `On Error Resume Next` outside of an error-handling subroutine, **and has nefarious, undocumented side-effects inside an error-handling subroutine**:

```vb
 
9:02 PM
no, by an object that is newed later, after the event.
 
It really does not matter whether the user is transient or a singleton. The same is true for the initial registration.
 
I don't want to assume that an object won't be newed up after the event
 
If you new it up later, the kind of registration is irrelevant.
No IoC is involved in newing things up.
 
Correct but if a object was created that had a transient dependency which is the command, wouldn't that be a new instance of the command?
 
9:03 PM
My point is that all this safety has nothing to do with the commands being registered with transient lifestyle.
 
in which case, it wouldn't have been there to receive the event that fired?
 
If you new something up that has a dependency, you will have to have the dependency at hand.
 
and you're telling me that a IoC container will never new something up on the demand after the registration has been done?
 
I get the point that you want to guard against creating commands too late. My sole point is that this really has nothing to do with the lifestyle they are registered with.
If you have a singleton you provide via an automigic factory and only resolve it later, it will only be created at thefirst request, AFAIU.
 
Yes, I appreciate that - I'm a bit surprised that IoC apparently news up everything during the registration; I would have expected that for a transient object, it'd be only new'd up when it was needed.
But you're telling me that is not the case.
 
9:07 PM
It only creates things, if you use it to resolve something, like via an automigic factory.
 
So, good to have that misconception cleared away
 
Newing something up does not involve the IoC container.
It is newed up immediately, because it is needed to satisfy some constructor dependencies.
 
Correct. When I saw that the commands were provided with a transient lifestyle, I was concerned that I might not be able to guarantee that all commands will be present when we fire the event.
and I did not want to change the lifestyle or walk up all the object graph to work out the actual lifetime.
 
That might still be the case, if somebody is really fast in closing the VBE.
 
Thank you again for clarifying!
 
9:10 PM
You are welcome.
Still, we have some view models that new up commands.
If we ever make the window creating lazy, we will have to guard against late command construction.
 
Ok - I know Comintern got rid some of those but I was not sure if we got rid of all the news.
 
Anyway, for most of the commands I actually do not reallt see why they are registered in transient scope.
 
I assumed because of the fact that they could be created & destroyed -- for example, the context menu
 
If we lazily construct the viewmodels, we might actually end up using the IoC container to resolve the dependencies at that time as well.
 
but that only make sense for the COM objects (the CommandBar stuff). I don't think we need to have separate instance of commands... do we?
 
9:13 PM
All those I can think of atm do not really have state.
However, I have not looked at all of them.
 
@this How does -1 reset error handling while still allowing it to jump to the Oops line label?
 
@IvenBach Err.Clear : On Error Resume Next
 
think of it as basically hard reset
 
Yeah more like that
 
a Err.Clear will not actually reset the "active error handler"
 
9:35 PM
Gotta experiment a bit more though... thinking it might reset to whatever the previous OnError statement said
 
ditto w/ On Error Resume Next
which is why if you run the x, you see that the On Error Resume Next inside the error handling subroutine had no effect
 
yeah that's key - it's kind of like Resume but without the resuming part
Still think we're 100% right to flag it
 
> Thanks for the quick reply, and the suggestion – much appreciated!


________________________________
From: bclothier <notifications@github.com>
Sent: Tuesday, April 2, 2019 9:33:43 AM
To: rubberduck-vba/Rubberduck
Cc: MegaDudeNZ; Author
Subject: Re: [rubberduck-vba/Rubberduck] On Error Goto -1 causes a "That's not real code" (Thundercode) error (#4886)


Thanks for reporting! I'm not sure if you saw the entire message (or perhaps a separate inspection):

While this is legal, this is poorly do
 
^^
oh, nice! It hides the email quotes!
 
> Hi Mathieu,

Thanks for the quick reply, and the suggestion – I’ll rewrite it accordingly. Much appreciated!

Nev



________________________________
From: Mathieu Guindon <notifications@github.com>
Sent: Tuesday, April 2, 2019 10:02:02 AM
To: rubberduck-vba/Rubberduck
Cc: MegaDudeNZ; Author
Subject: Re: [rubberduck-vba/Rubberduck] On Error Goto -1 causes a "That's not real code" (Thundercode) error (#4886)


Here's the documentation for the On Error statement in VBA: https://
 
9:44 PM
I don't get how -1 allows it continue, considering GoTo 0 doesn't.
Then again my error handling is still not the best.
 
GoTo 0 => "disable the current error handler and bubble upward"
Please make a distinction between current error handler and active error handler.
So doing a GoTo 0 inside an error handler --- the error handler is active, so it cannot be modified at that point.
you can clear the error but that has nothing to do with the error handler itself
the GoTo -1 both clears the error and inactivates the active error handler.
 
How does your y method then jump to an infinite loop? Is the active error handler disabled?
Based on what I understand Oops is the current error handler.
 
Correct and it gets activated on every Debug.Print 1/0
then we enter Oops line label, go to the On Error GoTo -1, which then inactivates the active error handler.
 
That contradicts what you wrote previously.
 
^
3 mins ago, by this
the GoTo -1 both clears the error and inactivates the active error handler.
 
9:52 PM
#wrods
 
That's my crutch.
 
as I said, to make a distinction between the current and active error handler.
inactivating the active error handler does not change the policy.
 
Did you mean that it clears the error state and deactivates the active error handler?
 
Yes, with the understanding that we are simply deactivating the state of the error handler
 
Oh right, you wrote current error not current error handler.
 
9:54 PM
see, it's not the best way to describe it. This is very confusing.
 
Oops is the Active error handler. If no error is found then there is no current error handler?
 
no, it's still the current error handler
it's set by the On Error GoTo Oops
we hit the Debug.Print 1/0, which then activates it
 
No, the current error handler is the one specified by the last On Error
 
and we go to the Oops.
I guess you could say On Error GoTo -1 is semantically equivalent to Resume Next
 
I can follow up to the where Oops gets called.
 
9:55 PM
except, that's not actually the Next
but more like Resume onTheNextLineFromHere
 
On Error GoTo -1 is having execution resume on the line after the line label where the handler is defined?
 
no, after the On Error GoTo -1 itself
 
:+1: That's the portion I didn't understand.
Got it now.
 
[rubberduck-vba/Rubberduck] build for commit 2925035f on next: AppVeyor build succeeded
 
9:59 PM
And that raises an error that will be handled in contrast to an error raised while an error handler is active.
 
^ correct.
 
This is really a good footgun.
 
Lost me again with that explanation.
 
the error handling behavior changes when there's an active error handler. And yes it's a great footgun.
Ok, @IvenBach back up to the x - it had the On Error Resume Next, right?
 
Yes.
 
10:01 PM
and did it work?
e.g. it was honored?
 
No. It brought up a dialog.
 
It bubbles up, right?
 
Correct
So when an error handler is active, On Error XXXX statement have no effect
 
Since Oops is the only handler, yes it bubble up to the application and the user.
 
because you can't change the policy while the error handler is active
You need to first inactivate the error handler by doing a Resume, Resume Next, Resume <label> or maybe even Exit <procedure>..... or doing a On Error GoTo -1
 
10:03 PM
You can handle the error further up in the in the call stack, right?
 
Of course. In that example we had only one procedure, though.
 
Just wanted to make sure.
So far, I never had handlers that might raise an error themselves.
Well, at least not without me introducing a stupid bug.
 
I have written multiple error handling because DAO does not have states about transactions.
 
Think I've understood GoTo -1 now.
 
Good; now forget it exists.
2
 
10:06 PM
^
similar to this:
Public Sub x()
  Dim db As DAO.Database

  On Error GoTo ErrHandler

  Set db = ...

  db.BeginTrans
  On Error GoTo TranErrHandler

  'do work

  db.CommitTrans
  On Error GoTo ErrHandler

  'do post-work

ExitProc:
  'Clean up....
  Exit Sub

TranErrHandler:
  db.RollbackTrans 'Fall through
ErrHandler:
  'default error handling stuff
End Sub
 
To use it sounds like a really bad idea.
 
However, this can be argued that this probably need to be broken up into smaller routines.
e.g. extract the transaction work into its own method so it has its own error handler.
 
i assume thats only for access backends @this?
 
So I am more inclined to think that if a routine needs multiple layers of error handler just to catch some state, it is probably doing too much.
Doesn't have to be. It can work with a remote SQL backend, too. But I rarely write code like this because I don't like doing transactions client-side.
I honestly didn't think we would actually get a issue report about the On Error GoTo -1, at least not so soon.
 
11:02 PM
@M.Doerner I'd never actually use it. To learn how to use it was hard enough.
 
Makes you think that they had gone to the trouble of implementing then looked at it, and said, "we may have made a mistake."
of course, they couldn't delete the implementation so they just didn't document it.
 
:grumble: WPF build errors stopping me in my studies.
 
hey, be happy you got build errors, not runtime errors.
 
I'm convinced the .NET framework doesn't want me to learn WPF.
 
11:44 PM
Hi folks.
Is this correct?
I mean the error inspection that on the line where is .BackColor = RBG(245, 245, 245)
That it was assigned without Set
 
yeah, this is wrong.
since BackColor isn't an object but a Long
 
aaand two consecutive crashes after that fix.
But that may be because I have like 500 inspections errors/warning/...
 
if you were already hitting 1 GB in memory usage, that'd be more likely
the number isn't a problem but the memory, especially if you're using 32-bit Access.
 
Excel
 
with 32-bit Excel, you can at least enable AWE
 
11:51 PM
Well right now, after I hit refresh, my Task Manager reports 400 MB.
awe? That's a setting in Excel settings?
 
were you doing a lot of fixes before the crash?
 
Tried just this one.
opened the document, clicked on the first one, that got fixed, thettn automatically got refreshed and crash.
 
Source for this statistics (bottom): fastexcel.wordpress.com/2016/11/27/…
so maybe I am using more then 1 GB.
 

« first day (1760 days earlier)      last day (1420 days later) »