I am using SUM() -function to calculate a sum from a cell range from the same sheet, like
At some point I noticed Calc automatically adding sheet name to cell range.
Is Calc doing this automatically in some situations? I know sheet names are being updated if sheet they are referring to is changed, but if no sheet name is used in the first place?
This became a problem to me, as Calc did not highlight anymore referred cells of the function when selecting the function input line. After testig a bit, I noticed this is caused by the fact that sheet name used has a space (or any other special character) on it. When using a sheet name without special characters (and thus without hyphens), UI shows the selection correctly.
See attachment referred-cells-highlight.ods
Is this a bug in Calc?
Version: 22.214.171.124 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6 CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; Locale: fi-FI (en_US.UTF-8); Calc: group