Cell formatting / alignment when importing a SYLK file is not supported Example : The line "F;FG0C" is supposed to center the previous cell content (Format / General / 0 decimal / Center), which is not the case. It's currently ignored.
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Dear Laurent Haas, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Created attachment 184697 [details] SYLK sample file Minimal SYLK cells alignments sample file
Created attachment 184698 [details] Screenshot of sample file on LibreOffice Screenshot of the SYLK sample file on LibreOffice (no alignment)
Created attachment 184699 [details] Sample file opened in Excel Screenshot of the SYLK sample file opened in Excel
Here is a sample file attached with cell alignments and how it's rendered in LibreOffice (no alignment taken into account) and in Excel (Version Microsoft® Excel® pour Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 32 bits).
Confirmed Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f0ff4243d45b11f372a2ed824fbb8806de9cb595 CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 17 March 2023