An error at user functions

An error at user functions - Help please! - 消息

#1 已发布: 2026/5/22 16:47:56
Valery Ochkov

Valery Ochkov

67个赞,共716个帖子。

组: User

See the end of the sheet.
iapws-1995.png
iapws-1995.sm (220.46 KiB)已下载 513 次。
已编辑 2026/5/22 17:26:14
#2 已发布: 2026/5/23 05:08:54
Alvaro

Alvaro

1,139个赞,共1,805个帖子。

组: User

Hi. Use line(#) for prevent the evaluation.

image.png

iapws-1995.sm (220.77 KiB)已下载 522 次。

Best regards.
Alvaro.
2位用户喜欢此帖子
Valery Ochkov 2026/5/23 08:36:01, Andrey Ivashov 2026/5/23 17:12:56
#3 已发布: 2026/5/23 08:36:34
Valery Ochkov

Valery Ochkov

67个赞,共716个帖子。

组: User

Thanks and why?
#4 已发布: 2026/5/23 11:03:47
overlord

overlord

600个赞,共1,381个帖子。

组: Moderator

This happens because your i is not empty.
Try to clear it or use something different for sum iteration.
j would be appropriate.

Regards

2026-05-23_13-59.png
2位用户喜欢此帖子
Andrey Ivashov 2026/5/23 11:18:20, sergio 2026/5/23 17:20:38
#5 已发布: 2026/5/23 11:19:15
Andrey Ivashov

Andrey Ivashov

2,344个赞,共4,057个帖子。

组: Super Administrator

Thank you overlord!

Another way is to use line() at the rhs:
image.png

Best regards.
#6 已发布: 2026/5/23 16:18:22
overlord

overlord

600个赞,共1,381个帖子。

组: Moderator

Don't know if this is a bug or limitation.
But when formula assigned to variable or used directly, it can be calculated.
When assigned to a function, it can't be parsed.

Regards

2026-05-23_19-16.png
  • 有新帖
  • 无新帖