I had trouble getting Calc to follow this formula: = 0.0004689*(B4^0.55)*(B6^1.1)/(B2^0.65) As I typed it, if I skipped *, I'd get an error, saying that Calc had detected an error, and asking to autocorrect the formula. Since I don't want to lose what I've typed, I click no. At this point, Calc would sometimes chop out part of the formula, losing part of what I've typed, leaving gibberish, and requiring me to start over. I can't reliably reproduce this.
Thanks for the report, Marja. A couple questions about the steps to try and reproduce: - Which asterisk * were you leaving out? The first one of the second one? - Which part of the formula would be chopped out? Please also try to reset your user profile ("Help > Restart in safe mode") and see if you can still see the issue. Cheers
Any of them. Trying again, if I reject corrections, I get Err:509. If I accept corrections, I get = 0.0004689*(B4^0.55) instead of = 0.0004689*(B4^0.55)*(B6^1.1)/(B8^0.65) So it's dropping 2 out of 4 terms. If I start re-typing the rest, it just goes to Err:509 now.
I recall times it dropped the 0.0004689, I think that involved typing the last terms, and then re-typing the first. But I only see it drop the B6 and B2 terms in Safe Mode.
I typed =0.0004689(B4^0.55)*(B6^1.1)/(B2^0.65) and it did not ask me anything. Do I have to activate some option? Do you still see this with 7.4? Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ed259e5efe432386b54c553cbc644b3b64976852 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 5 January 2023