Category Archives: News

Fix merged cell problems with Rainbow 11.1

Fix merged cell problems with Rainbow 11.1

If you ask any professional Excel developer about merged cells, they will almost certainly say something that can’t be repeated here! Merged cells can produce incorrect calculation results, prevent sorting and filtering in data tables, cause errors in macros, and waste large amounts of time when spreadsheets have to be updated.

Of course if your spreadsheet is effectively a desktop publishing app, used simply to format and display text, then merged cells can be extremely useful. But not many spreadsheets fall into this category! And actually most of the formatting effects provided by merged cells can be achieved (with just a little more effort) by using an appropriate combination of column width, word wrap, fill colour, and borders.

If merged cells are causing problems in your spreadsheet, it’s a bit fiddly to track them down in Excel, and very time-consuming if you need to un-merge them. That’s why we have added a Merged Cells Tool in the latest version of Rainbow, as in the composite screenshot above. And to complement this new function, in the Summary Report we have added a column showing the number of merged cells and their total area.

As you can see above, the Merged Cells Tool produces a report listing all merged cells, and it also offers a range of options for un-merging merged cells. These include the ability to place the un-merged content at any specified location within the former merged area (whereas by default Excel simply places the content in the top left corner of the area). So for instance if you have a spreadsheet that uses merged cells to display quarterly results spread across three monthly columns, you can un-merge the quarterly results into the middle column to maintain the same visual layout.

As always with a new release of Rainbow, we have also fixed a number of minor issues and made a few other usability improvements. So do try this latest release and see what you think!

Manage all your spreadsheets with Rainbow 11.0

Manage all your spreadsheets with Rainbow 11.0

You may have already noticed that with the release of Rainbow version 11.0 there are now two editions of Rainbow that you can download from our Home page: Rainbow Analyst Professional (Rainbow Pro) and Rainbow Governance. And if you download Rainbow Governance after having used an earlier version of Rainbow Pro, you will immediately see… Continue Reading

Find more hidden errors with Rainbow 10.1

Find more hidden errors with Rainbow 10.1

Rainbow has always been about finding hidden errors, and version 10.1 introduces a new analysis option (in Risk Map and Formula Scan) that detects error values lurking hidden in your IF() statements. A simple example would be where cells B3 and B4 contain the value 0, and B5 contains the formula “=IF(B3>0,B3/B4,0)”. In this case… Continue Reading

Rainbow 10.0 adds perpetual licence

Rainbow 10.0 adds perpetual licence

For Rainbow 10, we’ve responded to requests from a number of users for Rainbow to include a perpetual licence. So all Rainbow version 10 licences will now allow you to continue using the same version of Rainbow even after the licence period has expired (but you will not be able to install any updates released… Continue Reading

Rainbow 9.2 saves time for your team

Rainbow 9.2 saves time for your team

With Rainbow 9.2 we’ve built on the behind-the-scenes changes in version 9.0 to deliver significant new front-end capabilities: We’ve integrated Rainbow’s in-depth testing capabilities (in Risk Map and Logic Analysis) into the Formula Scan function (renamed from Formula Groups). Formula Scan can now perform a battery of tests on each formula as it scans, and… Continue Reading

New Rainbow Pro 8.2 more intuitive than ever

New Rainbow Pro 8.2 more intuitive than ever

We’re always looking for ways to make Rainbow Pro easier to understand and use, and in the just-released version 8.2 we’ve built on our “interactive reports” technology to deliver a whole new level of product integration. You can see this very clearly in the Summary Report screenshot above, showing the 20 interactive buttons (in column… Continue Reading

Stop “Too many different cell formats” errors

Stop “Too many different cell formats” errors

Have you encountered a “Too many different cell formats” error message? This often occurs as a result of copying or importing worksheets from one workbook into another, because by default Excel also imports all the custom styles (cell formats) from the source workbook. Generally there are about 50 basic styles, but when worksheets have been… Continue Reading

Rainbow Pro 8.1 easier for new users

Rainbow Pro 8.1 easier for new users

We’re very proud of Rainbow Pro’s rich set of analysis functions, but a few users have told us they have found it difficult to know which functions to use, and they would like something simpler. So we’ve responded to this by releasing Rainbow Pro version 8.1, which has a dual-menu system, as you can see… Continue Reading

Do it with fewer clicks in Rainbow Pro 8.0

Do it with fewer clicks in Rainbow Pro 8.0

We’re always looking for ways to make Rainbow easier and quicker to use, and the latest release of Rainbow Pro 8.0 helps you get where you’re going with considerably fewer mouse clicks. Even the Rainbow installer (the RainbowPro.exe file that you download) now makes things much easier; it not only copies the Rainbow add-in file… Continue Reading

Back to topAdministration