# Latest **URL:** https://forum.xltoolbox.net/latest.md?page=5 [Latest](https://forum.xltoolbox.net/latest.md) · [Categories](https://forum.xltoolbox.net/categories.md) · [Tags](https://forum.xltoolbox.net/tags.md) **Page:** 6 --- ## [Fixing LaserJet network connectivity](https://forum.xltoolbox.net/t/fixing-laserjet-network-connectivity/128)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 20, 2016, 5:35am UTC](https://forum.xltoolbox.net/t/fixing-laserjet-network-connectivity/128 "2016-11-20T05:35:13Z")
I recently bought a used HP LaserJet P2015dn printer as a replacement for a Brother HL-2030. The Brother printer annoyed me with its sheer never-ending fan which came on even when only a single page was printed. I know t… --- ## [Formelgenerator](https://forum.xltoolbox.net/t/formelgenerator/127)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 20, 2016, 5:30am UTC](https://forum.xltoolbox.net/t/formelgenerator/127 "2016-11-20T05:30:39Z")
Instead of writing our every group for which you want to generate a formula, you can let the Formula Builder collect all group names that occur in the “Input Groups” cells. The output will be in alphabetical order. T… --- ## [Multi Histogram](https://forum.xltoolbox.net/t/multi-histogram/126)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 20, 2016, 5:15am UTC](https://forum.xltoolbox.net/t/multi-histogram/126 "2016-11-20T05:15:00Z")
The multi-histogram feature has been cited in this publication: Drake, A. (2015) Mapping of Massive Ground Ice Using Ground Penetrating Radar Data in Taylor Valley, McMurdo Dry Valleys of Antarctica. University of Uppsa… --- ## [Fixing Rails deployment errors with Capistrano](https://forum.xltoolbox.net/t/fixing-rails-deployment-errors-with-capistrano/125)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 20, 2016, 3:54am UTC](https://forum.xltoolbox.net/t/fixing-rails-deployment-errors-with-capistrano/125 "2016-11-20T03:54:07Z")
After upgrading a Rails web application from Rails 4.2 to Rails 5.0 and attempting to deploy it using Capistrano, I got stuck on “Your Ruby version is 1.9.3, but your Gemfile specified 2.3.1” errors that gave me quite a… --- ## [ELISA curve-fitting](https://forum.xltoolbox.net/t/elisa-curve-fitting/124)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 20, 2016, 2:33am UTC](https://forum.xltoolbox.net/t/elisa-curve-fitting/124 "2016-11-20T02:33:39Z")
Fitting a curve onto the standards results of an ELISA is not straight-forward. However, Excel can be coerced to perform the curve fitting using the Solver addin. In this blog post I collect some online resources on curv… --- ## [Move/Extend Chart Range](https://forum.xltoolbox.net/t/move-extend-chart-range/123)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 11:57pm UTC](https://forum.xltoolbox.net/t/move-extend-chart-range/123 "2016-11-19T23:57:14Z")
With the left and right arrow buttons on the toolbar/Ribbon, you can easily change the source cells for you chart. Use this feature to browse through data sets. This is a companion discussion topic for the original e… --- ## [Transpose Wizard](https://forum.xltoolbox.net/t/transpose-wizard/122)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 11:27pm UTC](https://forum.xltoolbox.net/t/transpose-wizard/122 "2016-11-19T23:27:49Z")
In indexed format, each well is written into an individual row. Well ID’s are given in the “A1” style (where the letter indicates the row and the number the column on the plate). Note that the data of interest (the Ct v… --- ## [Hochauflösender Graphikexport aus Excel](https://forum.xltoolbox.net/t/hochauflosender-graphikexport-aus-excel/120)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 11:16pm UTC](https://forum.xltoolbox.net/t/hochauflosender-graphikexport-aus-excel/120 "2016-11-19T23:16:12Z")
Sie können entweder einzelne Diagramme exportieren oder ganze Layouts, etwa falls Sie eine große Abbildung mit mehreren Graphen haben. In dem Fall markieren Sie einfach alle Zellen, die die Graphen umschließen, und expor… --- ## [Diagramme beschriften und markieren](https://forum.xltoolbox.net/t/diagramme-beschriften-und-markieren/119)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 11:09pm UTC](https://forum.xltoolbox.net/t/diagramme-beschriften-und-markieren/119 "2016-11-19T23:09:24Z")
Das nebenstehende Beispiel veranschaulicht die Funktionsweise: Dieses Diagramm enthält zwei Datenreihen: 1, 3 und 5 in Spalte A und 4, 3 und 2 in Spalte B. Unterhalb der Daten wurden Beschriftungs-Texte in die Zellen ge… --- ## [Using InnoSetup to install Excel addins](https://forum.xltoolbox.net/t/using-innosetup-to-install-excel-addins/118)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 10:48pm UTC](https://forum.xltoolbox.net/t/using-innosetup-to-install-excel-addins/118 "2016-11-19T22:48:19Z")
Installing a native Excel addin (.XLAM or .XLA file) is a two-step process in Excel: This is a companion discussion topic for the original entry at https://www.xltoolbox.net/blog/2013/12/using-innosetup-to-install-exce… --- ## [Fixing 'Server execution failed' problems on Windows](https://forum.xltoolbox.net/t/fixing-server-execution-failed-problems-on-windows/117)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 10:43pm UTC](https://forum.xltoolbox.net/t/fixing-server-execution-failed-problems-on-windows/117 "2016-11-19T22:43:16Z")
After reorganizing folders on my network shares, my Windows machine (VirtualBox) would refuse to start the Explorer or ‘My Computer’. The solution is to fix ‘User Shell Folders’ settings in the registry editor. This is… --- ## [Daniel's XL Toolbox - Farewell](https://forum.xltoolbox.net/t/daniels-xl-toolbox-farewell/115)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 9:55pm UTC](https://forum.xltoolbox.net/t/daniels-xl-toolbox-farewell/115 "2016-11-19T21:55:54Z")
I’m sorry that the XL Toolbox did not meet your needs. Please check again later. I am continuously working on improved and new features! This is a companion discussion topic for the original entry at https://www.xltoo… --- ## [Change Chart Size](https://forum.xltoolbox.net/t/change-chart-size/114)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 9:50pm UTC](https://forum.xltoolbox.net/t/change-chart-size/114 "2016-11-19T21:50:18Z")
While current version of Excel (2007-2013) let the user easily set the size of a chart in inches, such a feature is not available in older versions of Excel (2003 and earlier). The XL Toolbox offers a function to set th… --- ## [Upgrading to Ubuntu 13.10 with Apache 2.4](https://forum.xltoolbox.net/t/upgrading-to-ubuntu-13-10-with-apache-2-4/113)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 8:01pm UTC](https://forum.xltoolbox.net/t/upgrading-to-ubuntu-13-10-with-apache-2-4/113 "2016-11-19T20:01:03Z")
Ubuntu 13.10 has been released. It is only a minor evolution from Ubuntu 13.04. Yet I was intrigued by the promise of a more responsive Unity UI, so I adopted early. This is a companion discussion topic for the origina… --- ## [Two-Way ANOVA](https://forum.xltoolbox.net/t/two-way-anova/112)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 7:46pm UTC](https://forum.xltoolbox.net/t/two-way-anova/112 "2016-11-19T19:46:12Z")
Currently, the 2-Way ANOVA of the XL Toolbox has the following limitations. They will be addressed in a future release. This is a companion discussion topic for the original entry at https://www.xltoolbox.net/2wayanov… --- ## [Keyboard shortcuts](https://forum.xltoolbox.net/t/keyboard-shortcuts/111)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 7:28pm UTC](https://forum.xltoolbox.net/t/keyboard-shortcuts/111 "2016-11-19T19:28:16Z")
Daniel’s XL Toolbox allows you to define keyboard shortcuts for commonly used functions. Keyboard shortcuts can be globally enabled and defined in the Preferences (see screenshot, right). This is a companion discussi… --- ## [Local file sharing with Samba and VirtualBox guests](https://forum.xltoolbox.net/t/local-file-sharing-with-samba-and-virtualbox-guests/110)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 7:01pm UTC](https://forum.xltoolbox.net/t/local-file-sharing-with-samba-and-virtualbox-guests/110 "2016-11-19T19:01:13Z")
VirtualBox is an excellent tool to run one or many virtual Windows machines on a Linux host. Its shared folders offer convenient access to the host file system from the virtual machines. However, shared folders may not b… --- ## [Diagramm-Design](https://forum.xltoolbox.net/t/diagramm-design/109)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 6:29pm UTC](https://forum.xltoolbox.net/t/diagramm-design/109 "2016-11-19T18:29:40Z")
Die meisten Einstellmöglichkeiten sind selbsterklärend. Wichtig ist die Liste der Datenreihen-Formate (siehe Abbildung). This is a companion discussion topic for the original entry at https://www.xltoolbox.net/de/char… --- ## [Smart custom error bars](https://forum.xltoolbox.net/t/smart-custom-error-bars/108)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 6:22pm UTC](https://forum.xltoolbox.net/t/smart-custom-error-bars/108 "2016-11-19T18:22:52Z")
Excel’s® built-in method to add custom error bars to charts is rather complicated. Daniel’s XL Toolbox provides a simple way to add “smart” error bars to your graph with a single mouse click. This is a companion dis… --- ## [Copy chart format](https://forum.xltoolbox.net/t/copy-chart-format/106)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 6:12pm UTC](https://forum.xltoolbox.net/t/copy-chart-format/106 "2016-11-19T18:12:34Z")
When any of the options are selected, you will see an asterisk (“\*”) next to the caption of the tabs General, Title, or Axes and Grid. To clear all options at once, click on the “Clear” button to the right. This is a… --- ## [Thinkpad T430s Experience](https://forum.xltoolbox.net/t/thinkpad-t430s-experience/105)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 5:57pm UTC](https://forum.xltoolbox.net/t/thinkpad-t430s-experience/105 "2016-11-19T17:57:55Z")
Although a little off topic, I would like to write about my experience with a Thinkpad® T430s. I recently upgraded from my old machine, which was a Thinkpad T61. Prior to purchasing the new machine, I read lots of review… --- ## [Fixing network printing issues on Linux](https://forum.xltoolbox.net/t/fixing-network-printing-issues-on-linux/104)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 5:23pm UTC](https://forum.xltoolbox.net/t/fixing-network-printing-issues-on-linux/104 "2016-11-19T17:23:25Z")
I have an HP LaserJet P2015dn printer that used to cause me headaches and has been causing trouble for some time now again. This is a companion discussion topic for the original entry at https://www.xltoolbox.net/blog/… --- ## [Turning off scrolling in Excel without a scroll-lock key](https://forum.xltoolbox.net/t/turning-off-scrolling-in-excel-without-a-scroll-lock-key/103)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 3:20pm UTC](https://forum.xltoolbox.net/t/turning-off-scrolling-in-excel-without-a-scroll-lock-key/103 "2016-11-19T15:20:56Z")
If the arrow keys do not move the cell cursor in Excel, but rather the entire sheet, then the ‘scroll lock’ function is most certainly turned on. To turn it off, simply press the Scroll Lock key on your keyboard. But wha… --- ## [.NET & VSTO add-ins: Getting the prerequisites right](https://forum.xltoolbox.net/t/net-vsto-add-ins-getting-the-prerequisites-right/102)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 3:17pm UTC](https://forum.xltoolbox.net/t/net-vsto-add-ins-getting-the-prerequisites-right/102 "2016-11-19T15:17:50Z")
Depending on Windows and Office version, there are various different scenarios of the prerequisites that need to be met in order to install and run a VSTO add-in. This is a companion discussion topic for the original e… --- ## [Add/edit watermarks](https://forum.xltoolbox.net/t/add-edit-watermarks/101)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 3:13pm UTC](https://forum.xltoolbox.net/t/add-edit-watermarks/101 "2016-11-19T15:13:03Z")
Watermarks are text boxes on charts that can contain any information, e.g. initials or a date. This is a companion discussion topic for the original entry at https://www.xltoolbox.net/watermarks.html --- ## [Design Charts](https://forum.xltoolbox.net/t/design-charts/100)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 3:12pm UTC](https://forum.xltoolbox.net/t/design-charts/100 "2016-11-19T15:12:54Z")
By default, Excel produces charts that do not satisfy the needs of a scientific publisher: Thin lines, unfavorable colors with low contrast (blue on gray in Excel 2003®) or too much eye candy (gradients and shadows in E… --- ## [Annotate and label charts](https://forum.xltoolbox.net/t/annotate-and-label-charts/98)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 2:58pm UTC](https://forum.xltoolbox.net/t/annotate-and-label-charts/98 "2016-11-19T14:58:43Z")
The example left demonstrates how the Annotation feature works: The chart has two chart series: 1, 3, 5 in column A, and 4, 3, 2 in column B. In addition, there are some cells below the data from which the labels for the… --- ## [NG - Next Generation](https://forum.xltoolbox.net/t/ng-next-generation/97)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 2:57pm UTC](https://forum.xltoolbox.net/t/ng-next-generation/97 "2016-11-19T14:57:34Z")
As of version 7, the Next Generation incorporates a number of legacy features such as ANOVA, formula builder, errors bars, group allocation, etc. These are seemlessly integrated in the Next Generation. Over time, all of… --- ## [Export Excel charts to SVG files](https://forum.xltoolbox.net/t/export-excel-charts-to-svg-files/96)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 2:21pm UTC](https://forum.xltoolbox.net/t/export-excel-charts-to-svg-files/96 "2016-11-19T14:21:22Z")
To add the ability to export Excel charts to scalable vector graphic (SVG) files is a high priority in Toolbox development. However, even though I have started to write some code, it will take a very long time before it … --- ## [Linear Correlation](https://forum.xltoolbox.net/t/linear-correlation/95)
**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\ **Replies:** 0\ **Last updated:** [November 19, 2016, 2:17pm UTC](https://forum.xltoolbox.net/t/linear-correlation/95 "2016-11-19T14:17:13Z")
Correlation tests if there is a relationship between two variables that do not logically depend on one another. This is a companion discussion topic for the original entry at https://www.xltoolbox.net/correlation.htm… [Previous page](https://forum.xltoolbox.net/latest.md?page=4) [Next page](https://forum.xltoolbox.net/latest.md?page=6)