[Solved] Err510

Discuss the spreadsheet application
Locked
DWDun
Posts: 111
Joined: Thu Aug 29, 2019 11:08 pm
Location: OK

[Solved] Err510

Post by DWDun »

In re-writing a previosly correct Formula that was written using the same data, the same references, the same computer with the same operating system, the same version of Open Office Calc, in just trying to make it a little more elegant, absolutely everything looks like it should to be fully and correctly functional, but it tells me I have a missing variable, or two contiguous operators, but I do not, and it insists on adding a extra ) to the end of the Formula. Is Err510 triggered by having contigious operators of different categories suc as comparative, text, reference, etc? There are no instances of ajacent operators from the same category. And why would Calc insist on adding an extra ) to the end? Does this indicate another unspecified error somewhere in the Fomula? Any suggestion or assistance would be greatly appreciated.
Last edited by MrProgrammer on Sun Nov 03, 2024 5:08 pm, edited 2 times in total.
Open Office 4.1.15, Windows 11
User avatar
Hagar Delest
Moderator
Posts: 33630
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Err510

Post by Hagar Delest »

Can you upload a sample file? Without seeing the details of the formula, it's rather difficult to tell.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
Alex1
Volunteer
Posts: 852
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands, EU

Re: Err510

Post by Alex1 »

This looks like the same problem as viewtopic.php?t=112005
Why do you start a new thread if that has been solved?
AOO 4.1.16 & LO 25.8.3 on Windows 10
Locked