Kategorien
Allgemein

Confluence Excel Macro: Last Row and Column is Not Working

If you encounter the issue, that the „last row“ and „last column“ setting is not working in Confluence´s Excel macro, this is a pitty. As to find in the comments of the official bug report (including steps about how to reproduce) at Atlassian (https://jira.atlassian.com/browse/CONF-31741), they won´t fix this issue, because the Excel macro is deprecated.

Since I´m using the macro quite heavily, I´ve played a bit around and found the following workaround that might be also working for you:

  1. Add your Excel attachment
  2. Add the Excel macro
  3. Set last row/ column
  4. Save the page
  5. Edit the page
  6. Add a new version of your Excel attachment
  7. Save the page

Now the settings in „last row/ column“ are applied correctly.

Kategorien
Allgemein Learning

The Starfish Retrospective

In most retrospectives, we´re using the plain „What went good? What went wrong?“ – technique via a roundtable, noting down the outcome of this, then start discussing possible solutions for the „wrong“ things, coming up with action items to solve them, decide to take the actions, and ask participants for their ROTI (Return of Time Invested).

Kategorien
Allgemein

QuickLinks for August 2011

Here a quick list of articles I´ve read during the last month:

Kategorien
Allgemein

FitNesse & FitSharp: Some troubleshooting (2)

Could not load file or assembly…

When setting up FitNesse & FitSharp for a project recently, I ran into a really strange problem. I tried debugging using FitSharp´s RunnerW.exe and got the following error message:

Kategorien
Allgemein

QuickLinks for July 2011

Here a quick list of articles I´ve read during the last month:

Kategorien
Allgemein

In an ideal world…

…when you arrive at the developer´s desk to let him know that his changes have broken the nightly build he tells you, that he´s already fixing the issues.

#ILoveMyJob

Kategorien
Allgemein

QuickLinks for June 2011

Here a quick list of articles I´ve read during the last month:

Kategorien
Allgemein

QuickLinks for May 2011

Here a quick list of articles I´ve read during the last month:

Kategorien
Allgemein Programming

MS SQL / T-SQL: Get a random date

Lately I needed to get a random date from an MS SQL Server, and it was a real pain to find something on google about it. Luckily I stumbled upon the blog of Ben Nadel who has written a great article about Getting A Random Date From A Date Range In SQL.

Kategorien
Allgemein

CruiseControl.NET, Powershell and paths with spaces

Yesterday I included the execution of a Windows Powershell task into our CruiseControl.Net Buildserver in order to include the execution of some (more) tests into the build. I stumbled upon a posting of Vasily from QA Questions on how to do that: CruiseControl.NET: PowerShell tasks, otherwise I would have tried using the CruiseControl´s Exec-task to do it.

Before changing CruiseControl´s configuration I tried to make it work on the command line, just to go sure the Powershell script is doing what it is expected to do and found out that handling blanks in paths is a -bit- very weird when using PowerShell, but I found a solution described by Dave Donaldson at his blog: Running a PowerShell Script with a Space in the Path, which worked quite well for me.

But when it comes to CruiseControl.NET´s config-file, I still did not manage to execute the powershell script, reason is that there are two entries, one for the scriptpath and one for the script itself; so I´m not able to set the quotes correctly:

<tasks>
  <powershell>
    <script>myScript.ps1</script>
    <executable>C:\WINDOWS\system32\windowspowershell\v1.0\powershell.exe</executable>
    <scriptsDirectory>C:\my Directory\anotherDirectory</scriptsDirectory>
    <successExitCodes>0</successExitCodes>
    <buildTimeoutSeconds>60</buildTimeoutSeconds>
  </powershell>
</tasks>

One may argue that I just should place the Powershell script somewhere else, but I don´t like to use dirty workaround if there _must_ be a proper solution. And what if I´m not able to put it somewhere else?
What I´m using for now is to use the old 8-character directory name that was still common back in times of Windows 95, so in this case „C:\MYDIRE~1“. (To find this out, just execute „dir /x“ on the commandline). But I´m not very happy with this solution.

Any ideas/ proposals/ hints how to solve this properly? Thanks in advance!