A set of free User Defined Functions for Microsoft Excel® to create Sparklines :
the simple, intense, word-sized graphics invented by Edward Tufte & implemented by Fabrice Rimlinger.
I installed the app in Excel 2007. Love the ribbon bar implementation. However, it causes excel 2007 with SP1 to crash. It looks like the charts keep trying to recalculate causing the event to keep firing...
I rebooted after the install, created a 6 data point line chart, and added a formula =randbetween(1,50) to a cell not involved in the chart.
I've had to deinstall from my machine. The sparklines 3.2 that I had, was working fine.
I'm working on release 3.3 sheet embedded XL 2007 from several days. I've noticed that there is an error on RedrawSparklinesOnSheet() function at line 16. The correct instruction should be:
If Left(shp.Name, 4) = "Sprk" Then shp.Delete
The wrong instruction cause all custom images (not sparklines, but jpg, bmp, ... inserted by user on sheet) to be deleted.
I'm not sure that new releases are affected by the same problem.
However, I never end to thank you for this great excel improvement. I like sparklines !
I have been having a similar problem as Bob. I had to uninstall everything and start from zero. Does anyone know what is going on? I have had problems whenever I use offset, rand, randbetween, and (I think) vlookup.
Ditto on crashes. Any volatile functions in the spreadsheet (OFFSET, INDIRECT, etc) cause Sparklines to get into a loop that ends up hanging Excel. The error is 'Out of stack space'
If I had to guess, the recursive nature of the calls to the calculate routine are stacking up.
If I had to fix it, it would be something like.
Static BeenHere as Logical
IF BeenHere Then exit Sub
' do something BeenHere = True ' while you are doing this, the worksheet calculate event fires so you re-enter the subroutine ' done what you needed to do.
The scales work now with the tickinterval. One request: can you explain "Base"? The manual say the default is 1. If I input 1, the scale doesn't show up. If I leave it blank, the scale works fine. If I put in 10, I get log.
Re: add-ins. I had Solver and Analysis enabled. Sparklines seems to work better with them disabled. I do have a bunch of other add-ins, but I haven't disabled them and measured performance.
11 comments:
I installed the app in Excel 2007. Love the ribbon bar implementation. However, it causes excel 2007 with SP1 to crash.
It looks like the charts keep trying to recalculate causing the event to keep firing...
I rebooted after the install, created a 6 data point line chart, and added a formula =randbetween(1,50) to a cell not involved in the chart.
I've had to deinstall from my machine. The sparklines 3.2 that I had, was working fine.
I'm working on release 3.3 sheet embedded XL 2007 from several days. I've noticed that there is an error on RedrawSparklinesOnSheet() function at line 16.
The correct instruction should be:
If Left(shp.Name, 4) = "Sprk" Then shp.Delete
The wrong instruction cause all custom images (not sparklines, but jpg, bmp, ... inserted by user on sheet) to be deleted.
I'm not sure that new releases are affected by the same problem.
However, I never end to thank you for this great excel improvement. I like sparklines !
Bye
I have been having a similar problem as Bob. I had to uninstall everything and start from zero. Does anyone know what is going on? I have had problems whenever I use offset, rand, randbetween, and (I think) vlookup.
Ditto on crashes. Any volatile functions in the spreadsheet (OFFSET, INDIRECT, etc) cause Sparklines to get into a loop that ends up hanging Excel. The error is 'Out of stack space'
If I had to guess, the recursive nature of the calls to the calculate routine are stacking up.
If I had to fix it, it would be something like.
Static BeenHere as Logical
IF BeenHere Then exit Sub
' do something
BeenHere = True
' while you are doing this, the worksheet calculate event fires so you re-enter the subroutine
' done what you needed to do.
BeenHere = False
Exit sub
release linked seems to have same problem mentioned in March/April - is there an updated version?
Sparklines is a great tool. Thanks for your hard work.
I've had some difficulties in XL2007. It seems to work better if I uninstall other add-ins, but is still buggy.
One major issue: I can't get the Scales to work.
Here's a typical call:
"=scaleline("R",10,1,200,,50,,,,10)"
Am I missing something obvious?
Again, thanks for a great tool and thanks for sharing.
Regarding the ScaleLine issue.
Not really a bug, but you need to specify at least one TickInterval parameter.
Try the following : =scaleline("R",100,,200,,50,10,,,10)
It is something easy to change in VBA, I will include the change in the next release.
Regarding interference with other add-ins.
I had a couple of feedback related to this (Palo add-in), unfortunately it's hard to reproduce all situations...
If you could tell me what add-ins you have on your PC, I might have an idea of the kind of interference.
Regards
Fabrice- Thanks!
The scales work now with the tickinterval. One request: can you explain "Base"? The manual say the default is 1. If I input 1, the scale doesn't show up. If I leave it blank, the scale works fine. If I put in 10, I get log.
Re: add-ins. I had Solver and Analysis enabled. Sparklines seems to work better with them disabled. I do have a bunch of other add-ins, but I haven't disabled them and measured performance.
Great update, thanks !
Post a Comment