Clickable-url works in Xlsx not in Ods

[canonex]

This is:

- [x ] a bug report
- [ ] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

It is expected that the code suggested in:
change-a-cell-into-a-clickable-url
works the same across formats

What is the current behavior?

Doing:

$writer = new Xlsx($spreadsheet);
$writer->save('BUG.xlsx');

the Url in cell is correctly save

Doing:

$writerO = new Ods($spreadsheet);
$writerO->save('BUG.ods');

the cell is just text without Url

What are the steps to reproduce?

<?php

require __DIR__ . '/vendor/autoload.php';

// Create new Spreadsheet object
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();


$activeWorksheet = $spreadsheet->getActiveSheet();
$activeWorksheet->setCellValue('A1', 'Hello World !');

$spreadsheet->getActiveSheet()->setCellValue('A2', 'http://example.org/');
$spreadsheet->getActiveSheet()->getCell('A2')->getHyperlink()->setUrl("http://example.org/");


$writer = new Xlsx($spreadsheet); 
$writer->save('BUG.xlsx'); //OK

$writerO = new Ods($spreadsheet);
$writerO->save('BUG.ods'); //MISSING URL

?>

Attached the results.

What features do you think are causing the issue

...cant say, I would check getHyperlink() or setUrl() output.

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

Ods is affected.
Attached the results files (Xlsx working and Ods not).
2023-07-31_19-23-53_BUG.ods
2023-07-31_19-23-53_BUG.xlsx

Which versions of PhpSpreadsheet and PHP are affected?

I have tested in PHP 8.1.12 and PhpSpreadsheet 1.29.0.