Named ranges from Excel sheet was working earlier. Now it has stopped working.

asked 2018-06-09 06:04:33 +0100

akadidal gravatar image

updated 2018-06-11 09:35:35 +0100

Named ranges from Excel was working fine earlier. Working on Excel 2016 OpenLibre 5.0 can some one please tell me what settings need to be changed for it to work.C:\fakepath\sample_Excel.xlsx

you will see that the pie chart and the bar chart in the excel is supposed to update automatically. it is using named ranges. the same thing with formulas assigned to text boxes. (in the last page) they all worked fine last week. now it does not! :(

edit retag flag offensive close merge delete



Named ranges still work. What is the exact problem? Can you be more specific about exact versions of your OS and LO? Can you upload a nonworking example? (how to upload)

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-09 07:44:01 +0100 )edit

Thanks Xoristzatziki. I have uploaded the file. The same file when I open in my open libre.

LO version LibreOffice 10m0(Build:2)

OS version DISTRIB_DESCRIPTION="Ubuntu 16.04.4 LTS" NAME="Ubuntu" VERSION="16.04.4 LTS (Xenial Xerus)"

akadidal gravatar imageakadidal ( 2018-06-11 09:38:50 +0100 )edit

Sigh. What is the "open libre"?

Then: thanks for the file; but to enable others to see the problem in the file, please provide exact steps, what is expected, and what you see. Like: "Go to steetX.C1 and put 12 there; now go to sheetY and see that chart over D12 doesn't show 123%, like it should; instead, it still shows 321%".

Otherwise, the file is usable in infinite ways, which puts too broad task to anyone who wants to help.

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-11 09:45:43 +0100 )edit
Mike Kaganski gravatar imageMike Kaganski ( 2018-06-11 10:10:57 +0100 )edit

When I open the file in Excel, I see that some of named ranges are invalid: specifically, Age_, Decay_but_Serviceable_, No_Decay_, Reject_. No idea if fixing that changes anything, and actually that should be unrelated, since the top two charts don't depend on those invalid ranges.

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-11 10:21:57 +0100 )edit

Understood Mike. (i'll update the questions with some more details)

akadidal gravatar imageakadidal ( 2018-06-11 12:51:14 +0100 )edit

Opening "manage names" dialog shows that almost all (except one:Percentage_sepcies) names have an equivalent name ending with underscore (ex:there is Reject and Reject_). The named range for those ending in underscores are all invalid. Maybe you created those names by some copy procedure, but probably MSExcel does not "like" them anyway.

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-11 23:10:59 +0100 )edit