Ask Your Question

Any simple calculation using '+' '-' '/' or '*' gives me 'No pivot table found at this position.' followed by '508' or '509' depending on how I format the entry. LibreOffice 5.1.2

asked 2016-06-09 17:29:54 +0200

Manticore gravatar image

updated 2016-06-11 19:55:30 +0200

Examples: =(C4/A4), =(C4A4), =(C4+A4), =(C4-A4) give 'No pivot table found at this position.508' =C4/A4, =C4A4, =C4+A4, =C4-A4 give 'No pivot table found at this position.509' I have never even heard of Pivot Tables until this problem occurred.

Just noticed - the status bar at the bottom gives 'Error: Invalid semicolon'

It's all just become a whole lot more complicated. I tried a different Window Manager (Enlightenment rather than my usual XFCE) & the problem disappeared. Hey Ho! Taking it over to the XFCE forums.

edit retag flag offensive close merge delete


That rather indicates that within Enlightenment the en-US locale is used for UI, and in XFCE you have another UI language/locale set you usually work with and for that a non-matching LibreOffice language pack has been installed.

erAck gravatar imageerAck ( 2016-06-13 10:43:19 +0200 )edit

After trying a couple of other Window Managers + running LibreOffice straight in X with no WM - all of which gave me the same problem. : * I Solved It! *

Not XFCE. Not LibreOffice. I normally set the system RC-LANG to en_GB.UTF-8 and RC-LC-TYPE to en_GB.ISO-8859-1. Some recent update has removed the RC-LC-TYPE setting. For some reason Enlightenment overrides this while other WMs including XFCE do not. Seems like LibreOffice does not like UTF-8

Manticore gravatar imageManticore ( 2016-06-17 09:19:38 +0200 )edit

LibreOffice is perfectly fine with UTF-8

erAck gravatar imageerAck ( 2016-06-30 18:42:36 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-06-09 20:41:14 +0200

Manticore gravatar image

I've got: libreoffice-writer- libreoffice-calc-extensions- libreoffice-writer-extensions- libreoffice-base- libreoffice-mailmerge- libreoffice-filters-optional- libreoffice-calc- libreoffice-math- libreoffice- libreoffice-draw- libreoffice-pyuno- libreoffice-impress- libreoffice-l10n-en- I've been using LibreOffice & it's ancestors right back to StarOffice & never had this problem - I'm totally baffled.

edit flag offensive delete link more


Instead of adding that as an answer to the the question, which it is not, adding it as comment or just an edit to the original question would had been better. However.. what UI language do you use, and if it is not en-US then it is missing from that list. And which distro are we talking about anyway..?

erAck gravatar imageerAck ( 2016-06-10 13:34:49 +0200 )edit

answered 2016-06-09 18:13:50 +0200

erAck gravatar image

Likely the version of your installed LibreOffice language pack does not match the installed LibreOffice program version. They MUST be of the very same release version.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-09 17:29:54 +0200

Seen: 47 times

Last updated: Jun 11 '16