Why in spreadsheet, formula of horizontal summation of 4-column is not giving correct result instead error

While during older version, no problem at all, my present version is 4.2.0.2 Thank you very much!

Please try 4.2.0.4

Remember that any x.x.0 version is not recommended for production (in particular x.x.x.2 means RC2 or Release Candidate 2).

In any case if you can share a link to an example file and/or report the bug in Bugzilla

https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice

it would be important to check if it is indeed a regression.