Issue 125594 - Option to set default font used when opening csv/txt files
Summary: Option to set default font used when opening csv/txt files
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-09-07 04:40 UTC by apache
Modified: 2014-09-08 05:48 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description apache 2014-09-07 04:40:15 UTC
Currently for the files that are imported/open directly (Open with.. from OS), the font used is always same (OS's serif). There is not proper way to change this.


For users such as data scientists who primiraly work on unformatted data, the option to change the default font used to render the tabular data would be nice. For example, allowing to change the font to any monospaced instead of variable width sans would aid on rapid glance of the tabular data. At the same time restricting to one font only does not sound right if there is any easy solution or a complex solution that allows users with absolute necessity for this feature. This feature in itself is more useful to users who use calc frequently than to some one whoe needs to get job done using calc once in a while.

Existing workaround:
1. Font replacement table.
   It works to some extend but it's side-effects like making the rendering of odt and xls file with intended serif off-sized with the replaced fonts.

Solution Expected:
1. Introduce feature that allows to change default fonts used that works on imported csv/tsv.
2. Or Temporary hack pointers from someone who knows the internal or worked on that particular segment for source/configuration changes to achieve the same effect.
Comment 1 Andreas Säger 2014-09-08 05:48:50 UTC
csv data are always database data.
Best import method: Connect a Base document to your (collection of) text file(s), add optional queries and link preformatted Calc documents, optionally with charts, calculations, conditional formatting etc.