[libreoffice-users] Question about Calc and Data Validity

Hi!  So, I need to create a spreadsheet with a column of drop-down 
values.  I found how to do that using the "Data > Validity" menu 
option.  I created a drop-down menu column and it works fine.    Of 
course, I need to export this as an Excel file and I found Excel handles 
drop-down menus differently.  *sigh*

So, I was able to define the drop-down menu in Calc using the Excel 
approach and it works fine (albeit ugly).

My question: has anyone had any experience with exporting spreadsheets 
with drop-down menus in a column to Excel format? Did it work?  Was it 
problematic?

Thanks in advance!

Peace...

"The Other" Tom


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy