Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

@dts errors and dependent cells not updating #923

Open
jdrowell opened this issue Nov 26, 2024 · 1 comment
Open

@dts errors and dependent cells not updating #923

jdrowell opened this issue Nov 26, 2024 · 1 comment

Comments

@jdrowell
Copy link

I was working on the attached file (renamed to .txt to be able to attach), and all formulas were working. It basically has a new line for each month, and calculates the next month by getting the previous date, adding 31 days, and extracting @year and @month from that. Then another @dts is called to manufacture the first day of that month.

After quitting sc-im and reopening it with that file, I get these errors:

@dts: invalid argument or date out of range

I can use "q" to skip an error, but there is one error for each line of the spreadsheet. After it finally opens, the updates don't cascade properly. If I update the first month to "1", only the next line is recalculated. If I update it to "1" again, then the 3rd line is also updated. So a lot of functionality is broken in this scenario.

I had the problem when running v8.3, upgraded to v8.4 but there was no visible improvement.

fina.sc.txt

@jdrowell
Copy link
Author

I just changed it to use @if for calculating the next year and month (instead of @year and @month), and still get the same @dts error. It seems that any time I use @dts using cell references instead of hard coded values it gives that error when I reopen the sheet.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant