Ask Your Question

Libre Office vsn spreadsheet RIGHT function stopped working

asked 2020-01-27 23:28:20 +0200

Jrflanne gravatar image

It was working and I selected all in the column containing mixed calculation and manually entered text and paste special as text. Now 'RIGHT' doesn't work. Calculation fields work, but RIGHT doesn't. The column is formatted as General. ="anther column" works. It was working an hour ago and now it doesn't in any column. Any ideas of what happened?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-27 23:42:50 +0200

Jrflanne gravatar image

updated 2020-01-28 01:58:25 +0200

I might add, only RIGHT doesn't work. LEFT works, as does SUBSTITUTE). Tried Opebn Office, that doesn't work either. This is a kerfufle.

Well problem is solved because of an idiot user (me) forgetting there are packed spaces in the original field. So LO was returning spaces. This is a hangover from the original source file. The spaces get stripped out in R after a join. I'll leave this here in case somebody else happens to make the same mistake. Or else if a mod wants to delete it, pls do so. Thanks.

edit flag offensive delete link more



-1- Please EDIT your question if you want to add information. Answers should be answers (to the question on top).
-2- Describe what happens FIRST instead of what NOT happens. You may add of course what you EXPECTED to clarify things.
-3- Based on what is given I cannot reasionably answer. The mention of OpenOffice is either a joke or may give a hint, however: Did you "format" the cells where formulas don't work as expcted in the section 'Numbers' as "Text" (format code @). Cells treated this way take everything entered as a literal text, and a formula can only be recognized as one and work then if it NOT is taken as literal Text.
-4- We would know whether this guess is correct if you had reported wjhat you SEE in the cell where a formula didn't work.

Lupp gravatar imageLupp ( 2020-01-28 02:01:37 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-27 23:28:20 +0200

Seen: 51 times

Last updated: Jan 28