Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Filter Ranges and Excel

Always enclose in quotes any ranges containing ".." that you type directly into a formula or into a parameter with the Excel function wizard.

Without quotes, Excel may interpret your range as a set of values from the worksheet.

For example, if you enter "49950..59950" (including the quotes), Excel will interpret the filter as a simple text string.  Without the quotes, 49950..59950 means all the values in rows 49950 through 59950.  Since each row has 16,384 cells, this is an array of over 163 MILLION cells.

In this example, if you omit the quotes, Excel will go into a very long calculation.  Usually the only way to stop this calculation is to end the process.  Consult your IT expert for instruction on how to end a process on your computer.

This functionality of Excel has nothing to do with Jet Reports.  However, Jet Reports users are more likely to accidentally enter a range that causes Excel to perform a long calculation because of the way ranges of values are entered using ".."

These range calculations are a basic feature of Excel and there is no way for the Jet Excel add-in to change this behavior.

If a formula references a cell that contains a range with ".." you do not need to type the quotes into the cell.  The quotes are only required when you put the range directly into a function parameter.

Published:

Filter Ranges and Excel

Always enclose in quotes any ranges containing ".." that you type directly into a formula or into a parameter with the Excel function wizard.

Without quotes, Excel may interpret your range as a set of values from the worksheet.

For example, if you enter "49950..59950" (including the quotes), Excel will interpret the filter as a simple text string.  Without the quotes, 49950..59950 means all the values in rows 49950 through 59950.  Since each row has 16,384 cells, this is an array of over 163 MILLION cells.

In this example, if you omit the quotes, Excel will go into a very long calculation.  Usually the only way to stop this calculation is to end the process.  Consult your IT expert for instruction on how to end a process on your computer.

This functionality of Excel has nothing to do with Jet Reports.  However, Jet Reports users are more likely to accidentally enter a range that causes Excel to perform a long calculation because of the way ranges of values are entered using ".."

These range calculations are a basic feature of Excel and there is no way for the Jet Excel add-in to change this behavior.

If a formula references a cell that contains a range with ".." you do not need to type the quotes into the cell.  The quotes are only required when you put the range directly into a function parameter.

For an optimal Community experience, Please view on Desktop