If you enable the Navigator (View > Navigator), and use Drag Mode > Insert as Hyperlink, it pastes the full URI to the selected name range.
Is there a way to have it produce relative names?
System
- LibreOffice 3.5.7.2, English, Build ID: 350m1(Build:2)
- Component: Calc
- Operating System: Ubuntu 12.04, English