Bug 131274 - When opening a CSV file with Calc, the default template is ignored.
Summary: When opening a CSV file with Calc, the default template is ignored.
Status: RESOLVED DUPLICATE of bug 86336
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Import
  Show dependency treegraph
 
Reported: 2020-03-11 10:45 UTC by Kouichi Nakamura
Modified: 2024-07-07 18:54 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 Kouichi Nakamura 2020-03-11 10:45:17 UTC
Description:
When opening a CSV file with Calc, the font setting of the default template is ignored. There appears no way to configure default font for CSV tables.

Steps to Reproduce:
Import a CSV file with Calc


Actual Results:
The font of the opened CSV file is always "Liberation Sans" no matter what font is used in the default template for Calc

Expected Results:
The users should be able to choose their font for CSV tables as well. 


Reproducible: Always


User Profile Reset: No



Additional Info:
It is odd that the default template is reflected by a new spreadsheet but not by an imported CSV file.
Comment 1 Heiko Tietze 2020-05-18 09:39:18 UTC
Please explain what the default template is and what you expect. If you mean Styles and Formatting > Default, that's a per document setting. And File > Templates > Manage Templates there is no default.
Comment 2 Roman Kuznetsov 2020-08-12 19:24:17 UTC
I understood the problem.

Steps:

1. Change Default cell style => change font to Liberation Serif
2. Save file as Template (File-Templates-Save as Template) and select "Set as default template option" there
3. Try create a new Calc file => we have a Libreration Serif font in every cell
4. Try import any CSV file
5. We have a Liberation Sans font in any cell with imported CSV file instead Liberation Serif

Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

My opinion - in this case imported data should have cell format from default Calc template even it was changed

I don't think it's a UX bug. Heiko?
Comment 3 Mike Kaganski 2020-08-12 19:39:37 UTC
This is not a bug.

A (default) template is like existing document that is opened and copied when you create a new document. It isn't used when you open any existing document, even if the format is simple, such as CSV.

The template can contain column widths and row heights; it may contain styles; conditional formatting; headers and footers... using the template for CSV would appear as if  all that info  was in the file.

Doing otherwise would create surprise in users when they open a CSV, see headers there, edit, save and see it reverted to old headers (not "no headers" as reasonable per format, but old headers from template).

It could *maybe* follow e.g. Options->LO->Fonts->Font Settings for HTML, Basic and SQL sources. Personally I would prefer a per-filter configuration, e.g. own configuration for CSV. But that's a different issue, requiring own report.
Comment 4 wpeaton4 2024-04-16 19:48:47 UTC
I strongly disagree that this is not a bug. When you import a CSV file, Calc is clearly using some kind of template to determine styles, page settings, etc. But it's not using the user defined template.
Comment 5 Heiko Tietze 2024-04-17 09:04:34 UTC
(In reply to wpeaton4 from comment #4)
> I strongly disagree...
Feel free to reopen tickets in this case.

Tested the issue and in fact Calc ignores the default template when opening CSV from the start center or via the command line.
Comment 6 m_a_riosv 2024-06-16 20:37:27 UTC Comment hidden (obsolete)
Comment 7 Mike Kaganski 2024-07-07 18:43:25 UTC

*** This bug has been marked as a duplicate of bug 86336 ***
Comment 8 Mike Kaganski 2024-07-07 18:54:43 UTC
(In reply to wpeaton4 from comment #4)
> I strongly disagree that this is not a bug. When you import a CSV file, Calc
> is clearly using some kind of template to determine styles, page settings,
> etc. But it's not using the user defined template.

No it doesn't use "some kind of template". It uses defaults and some calculated settings (e.g., column widths). And these defaults and calculated settings are *not* equal to a "template" concept, just because the set of defaults used when opening a CSV is very small, and many settings possible in templates are not applicable to CSVs.

(In reply to Heiko Tietze from comment #5)
> Feel free to reopen tickets in this case.

Oh really?

> Tested the issue and in fact Calc ignores the default template when opening
> CSV from the start center or via the command line.

Yes. And Calc also doesn't do many other wrong things. Just because someone says that "program doesn't do foo" doesn't mean that it needed to.