The unit handling when it comes to the "Data->Convert Units" dialog is inconsistent. converting a cell with 3m to mm results in 3000. converting a cell with a header row: length [m] 3 and then converting the cell with the 3 to mm results in 3000mm We should fix the first case to create 3000mm in the cell. Code should be in UnitsImpl::convertCellUnitsForColumnRange
@Ben: that would be one for you and might be a simple one for the beginning.
Fixed by http://cgit.freedesktop.org/libreoffice/core/commit/?h=feature/unitver&id=c565edd82b3bf77a9e2333610b495a2916e4ab16.
Test added (on feature branch) in: http://cgit.freedesktop.org/libreoffice/core/commit/?h=feature/unitver&id=6a75eeb0c3dc12844557027f0df443e1b57269c6