Ask Your Question

what is err:512

asked 2017-09-06 08:31:48 +0100

cj_polich gravatar image

I am trying to create a time sheet, I started using excel, but it couldn't handle the length of the formula, it has several variables(show,more than 5 hours, after 12 am before 8 am), so I programmed it in blocks(the different combinations of show calls in time slots). I found that Calc could handle longer formulas. While combining these blocks(19 of them), after combining the first 8 I received an err:512 code in the cell. The error code is not listed in the documentation. Have I reached the maximum formula length? If I have do you have any suggestions on how to proceed.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-09-06 08:57:53 +0100

JBF gravatar image

Formula with too many token:

Very long formula is bad design because it make formula unreadable. You should use intermediate cells to calculate partial results.

edit flag offensive delete link more

answered 2017-09-06 08:56:13 +0100

Grantler gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-06 08:31:48 +0100

Seen: 593 times

Last updated: Sep 06 '17