Matthew Gray

Results 35 comments of Matthew Gray

I created my own "Today" button. It is also useful to have a button "Cancel"

I did not dig enough deep but inserting expression `if ($StartRow -eq $EndRow) {$rows = 0}` after line 182 would resolve the issue and would give some hints to further...

Try to comment setting `powershell.powerShellDefaultVersion`. It worked for me on several computers.

@EdCallahan The value of `Windows PowerShell (x64)` does not work (dont know why) and causes the PS extension never start.

> I know that this setting says it "has no effect on Windows" _but_ I can reproduce the hang when it's set to its default (true) and it stops hanging...

Test snippet for whom it may concern ```powershell function Use-Culture { param ( [System.Globalization.CultureInfo]$culture = (throw "USAGE: Use-Culture -Culture culture -Script {scriptblock}"), [alias('sb')][ScriptBlock]$scriptblock = (throw "USAGE: Use-Culture -Culture culture -Script...

`EPPlus` does not update `app.xml` file in openxml definition, that's why Excel can see `ps_created_name` range name which is present in `workbook.xml` file, but `EPPlus` cannot. This is definitely a...

At shallow sight `Open-ExcelPackage` does not utilize `useStream` property that is why `stream` property is empty.

The problem is with illegal chars in filepath because the module uses default `-path` parameter which `Resolve-Path` treates brackets `[]()` as a regular expression. There should be introduced a new...

The work around would be to rename the file removing brackets `[]()` before using `Import-Excel` ```powershell $newname = Rename-Item -LiteralPath -NewName (split-path ( -replace '[\[\]\(\)]') -leaf) -PassThru Import-Excel $newname.fullname ```