In PlanMaker HD, any formula containing the "ROWS" function will generate a false circular reference warning if the specified array value includes the current cell. Since it's not really a circular reference, I don't receive these warnings in Excel.
PlanMaker still correctly evaluates any formula containing ROWS, but the warnings are a nuisance.
I'll send a very simple example file.
-bsbd
ROWS can generate false circular reference warning [UPDATED]
ROWS can generate false circular reference warning [UPDATED]
Last edited by bsbd on Tue Sep 29, 2015 5:25 pm, edited 1 time in total.
Re: ROWS can generate false circular reference warning [UPDATED]
I discovered that this is also an issue with three other similar functions, ROW, COLUMN, and COLUMNS.
The good news is that I received a reply from SoftMaker support with a hotfix, but it was only for the Windows version which does me no good. They did say that the fix will be in the next updates for Android.
The good news is that I received a reply from SoftMaker support with a hotfix, but it was only for the Windows version which does me no good. They did say that the fix will be in the next updates for Android.
Re: ROWS can generate false circular reference warning [UPDATED]
Please wait for the next service pack and try again as soon as it is available . It should solve these issues.
Sven Leßmann
SoftMaker Software GmbH
SoftMaker Software GmbH