Sometimes, copying formula text from another application can introduce hidden, illegal characters. Re-typing the formula often resolves this. 4. Correct Function Structure
Two values or cell references are placed next to each other without an operator, such as =A1 B1 . Err:509
When working with complex formulas in LibreOffice Calc, you may encounter the dreaded Err:509 . This error code is frustrating but relatively simple to diagnose. It almost always indicates a within a formula. Sometimes, copying formula text from another application can