I have started to try and convert an old excel spreadsheet over to LibreOffice. The sheets themselves were created in or about 1999. I have run into a few issues in particular the combo boxes are being populated with different data than what they were originally programmed with. Upon much investigation I was able to learn how to edit and create combo boxes but I have not been able to figure out how to add data to the combo box.
In Design Mode when I right click on the combo box and select “Control” and go to the data tab there is a field called “Source cell range”. In that field is listed the cell range where the current data for the combo box is coming from, and it is the incorrect cell ranges for that combo box. I originally had a formula in that field (in Excel it was different) that referenced a range of cells in another sheet. I have not been able to figure out how to add the same formula to the “Source cell range” field or even if that is the correct field for the formula to be placed.
In summary I am trying to figure out how to add a formula to a combo box so it will fill the combo box with data from a range of cells. It would be preferable if it would take the data from another spreadsheet.