Bug 144597 - Changes to fonts will not save
Summary: Changes to fonts will not save
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Dutch
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-18 22:35 UTC by Dutch
Modified: 2022-04-11 07:04 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dutch 2021-09-18 22:35:33 UTC
Description:
I have a number of .csv files. They all open with an unreadable font size. Changing the font and font size will not save. Have tried "save" from 3 locations. Always revert to original font.

Steps to Reproduce:
1. Start csv file
2. change fonts to larger and other font
3. Save

Actual Results:
No change to fonts or font size

Expected Results:
new font


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 m_a_riosv 2021-09-19 12:29:46 UTC
Test selecting a different Character set on the input window.
Comment 2 QA Administrators 2022-03-19 03:32:41 UTC Comment hidden (obsolete)
Comment 3 Dutch 2022-03-19 22:45:07 UTC
So what part of this do you not understand? Description:
I have a number of .csv files. They all open with an unreadable font size. Changing the font and font size will not save. Have tried "save" from 3 locations. Always revert to original font.

Steps to Reproduce:
1. Start csv file
2. change fonts to larger and other font
3. Save

Actual Results:
No change to fonts or font size

Expected Results:
new font
Comment 4 QA Administrators 2022-03-20 03:31:40 UTC Comment hidden (obsolete)
Comment 5 dougrobinson3491 2022-04-11 07:04:01 UTC
I believe this is to be expected, DUE TO SAVING TO CSV. Font changes aren't supported in CSV format - the file format itself does not allow for saving any information that would store fonts. The file is literally just values seperated by comma's. 

You can save as a standard file format and get font changes, but saving to CSV will not save fonts; this is true in other office apps like MS Excel as well. 

It's less an issue with this particular app and more an issue with the file format. 

For example, if you wrote an app on your own to attempt to accomplish this, you could not possibly add data to the CSV file to mark-up information about fonts, you would have to create a seperate file to hold that information as if you did include font data into a CSV file, other apps would not be able to read it as a proper CSV given the standardized format / expectations of that format.