[Solved] Err510

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

[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.
O0en Office 4.1.6, Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32857
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 24.8 on Xubuntu 24.10 and 24.8 portable on Windows 10
Alex1
Volunteer
Posts: 793
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands

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.15 & LO 24.8.3 on Windows 10
Locked