Bug 98235 - Formatting changes following upgrade from 4.4.7.2
Summary: Formatting changes following upgrade from 4.4.7.2
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-27 16:49 UTC by Colin
Modified: 2016-03-20 17:42 UTC (History)
2 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 Colin 2016-02-27 16:49:21 UTC
Following installation, the existing Liberation Sans 6pt font utilised in a sheet was changed to Liberation Serif.
It appears the spacing or column width has also been affected as it was necessary to re-adjust some column widths where text overflow occurred.
My simple sheet only had 200+ lines and 25 columns with a few charts so the impact was not critical. I imagine (not tested in any way) a more complex sheet with multiple styles and possible embedding would require significant effort to repair.
Comment 1 MM 2016-02-27 18:30:16 UTC
Looks a bit like bug 98190
Comment 2 m_a_riosv 2016-02-28 03:01:16 UTC
Maybe default template was modified, for me a new spreadsheet with 5.0.5.2 has Liberation Sans for default style. Or a modification in Menu/Tools/Options/LibreOffice/Fonts - Replacement table.
Comment 3 Buovjaga 2016-03-17 11:19:52 UTC
Colin: what do you think about comment 2?

Set to NEEDINFO.
Change back to UNCONFIRMED after you have replied.
Comment 4 Colin 2016-03-17 12:23:23 UTC
I can confirm that my Libre Calc default font is Liberation Sans 10pt.
The current sheet font size has been manually changed to 6pt.
As a consequence of the irregularities I also changed the font in that sheet to Arial which then gave me a more consistent representation with which I could modify column widths etc to obviate all the inconsistencies.
When the change is implemented I simply select the entire sheet and make it 6pt.
I use the present tense because every week I import a line of data from a web site and again select and set the entire sheet to ARIAL 6pt.
The line of data being copied contains a link to further on-site analysis and that link remains active within my sheet.
I provide herewith the URL I use for the line of data.
https://www.euro-jackpot.net/archive
My procedure is simply to highlight the latest line of data and copy/paste it to my sheet.
This gives me the direct link to the target date field (ctrl + left click) and the seven numbers in a text field. I then set the font and size preferences and process the extracted data further.
I have briefly examined prior sheets of a similar nature and they now appear to load into the system correctly. It is possible that the initial error was a one-time update glitch.
Comment 5 Buovjaga 2016-03-20 17:42:32 UTC
Ok, sounds like this can be closed.

Colin: in the future, you could modify the default style of your document (sidebar - styles). Also, always paste as unformatted text. Then the formatting will go according to your style definition.