https://bugs.documentfoundation.org/show_bug.cgi?id=94393
--- Comment #4 from Elmar <rob...@iafrica.com> --- Looking into the matter, it seems that there is a difference in approach between Excel and Calc. In Excel, you can create the list in cells, then link the cells from the cell which is to be a dropdown. No named range is created. In Calc, you can create the list in cells, but then you need to name the range. In the dropdown cell, you reference the named range. I then saved the the file I added the dropdown using Calc. I opened the new file using Excel, the new dropdown I created worked (cell B30), but none of the others (which had been created using Excel) worked any longer. The Name that was created in Calc to define the range is also not visible in Excel. Unfortunately, even though govts claim to support open source, they tend to all use MS. Consequently they create forms which one has to complete. If you are an exclusively Open user (and do not have the MS tools), then this can be a problem. I checked this out in OpenOffice Calc, and it acts in the same way as LO Calc. Thus it is not a regression or bug, but an inconsistency between Excel and Calc. Not sure how you deal with this, -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs