Category Archives: Read My Blog

JasperReports Oddities #2: Indenting in Crosstabs

The expectation that using the Left Indent or Right Indent facility for your JasperReports Text Field or Static Text to ensure that it is spaced “just so” is perfectly reasonable. Let’s test that theory – just drop in your text field, position it carefully, right align your text and indent by 5 pixels. It looks great in the Studio designer, just what you intended with your indent. And then you press “Preview”, your draft report is generated and … well, it’s no longer indented… Continue reading

Unwanted Chrome Apps on Mac OSX

Remember, Google is not your friend. If you need a reminder, install Chrome on your Mac and you’ll suddenly find that you have some additional Chrome Apps, e.g. YouTube. And it’s not obvious where you uninstall these, at least not at first glance.

But it is easy:

  1. Go to Finder
  2. Open your home folder (i.e. “/Users/~/”)
  3. Open “Applications”
  4. You should now be able to see a folder named “Chrome Apps”

Either you can delete this folder or open it and delete the apps one by one. Remember to empty your trash and they’ll be gone. Bad Google! (or is that Bad Alphabet nowadays?)

JasperReports Server Hyperlink Formatting

This little nugget applies to Jaspersoft 5.6.x and later, and was brought in due to bleeding effects on hyperlink styles in earlier versions.

There are many things you can do directly with styles in JasperReports, and perhaps hyperlink formatting on a field by field basis could be one of them with a lot of effort and some serious code abuse. But really?! You want to set hyperlinks using conditional styles for every field in every report in your server in an effortful way? Feel free, but there’s another method which is much simpler. Continue reading

Spreadsheet Use And The Risk To Your Business

This is a simple idea with, perhaps, complex and, from a business perspective, important implications. Nowadays, with the near-universality of spreadsheet use in so many businesses, it has become almost too easy for every user to “develop” a spreadsheet, whether for use only by themselves, by a small team or across the whole business. In fact most organisations have a de facto spreadsheet culture. Continue reading

What is a Spreadsheet Engineer?

Well, there’s a question: what is a Spreadsheet Engineer, as opposed to a Spreadsheet Developer?

We’ve already skirted around this in my previous article about Spreadsheets and Risk. Since nearly everyone can ‘develop’ a spreadsheet model by entering some data and saving the file we can extend the idea of ‘Spreadsheet Developer’ to anyone in your business who is using a spreadsheet package and creating their own spreadsheets. And make no mistake, there’s a definite risk involved in this, most often not even recognised. Continue reading

Spreadsheet Use And The Risk To Your Business

This is a simple idea with, perhaps, complex and, from a business perspective, important implications. Nowadays, with the near-universality of spreadsheet use in so many businesses, it has become almost too easy for every user to “develop” a spreadsheet, whether for use only by themselves, by a small team or across the whole business. In fact most organisations have a de facto spreadsheet culture.

But maybe first we need to have a little background and what better than the results from a survey of nearly 1,600 spreadsheet users? Continue reading

Excel 2010: the big macro turn on!

Not what it may sound like, but instead a quick guide to making sure you can run your macros in Excel 2010.

Macros are disabled by default in Office 2010 (Word 2010, Excel 2010, PowerPoint 2010, etc) for enhanced security. Enabling Macros is easy but Microsoft Office team has hidden it deeper inside Options. Continue reading

Excel: moving from menu to ribbon, pt. II

I did say, in the post Excel: moving from menu to ribbon, that getting a friendly developer to write a custom menu set-up for you to replicate the old 2003 menu is not the way to go. Irrespective, I consider myself both friendly and a developer so we do actually have an add-in available, for those who’d like to disregard my previous advice. Continue reading