Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

This is an existing file as example, having the issue I reported.
Unfortunately is it in Dutch, but anyway. example.xls 
The sheet called "voedingsschema" uses pull down menu's which allows you to
select products from the other sheet, called "calorietabel". What you now
see in e.g. cell B19 is that it shows a number ("117" in this case), whereas
it is supposed to show the name of the selected product. I guess that the
word "brinta" was intended.
The interesting part is that the pull down menu's in cells C3, C4 and C5 do
work, but those pull down menu's do not refer to a list of words on another

For reference have I created a second file from scratch, showing the
intended behavior:
Here I made a list of options on one sheet and a choice on the second sheet.
Now the selected option become visible.

View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.