Bug 72770 - SOLVED - Calc - automatic row height - difference between Windows and Linux version
Summary: SOLVED - Calc - automatic row height - difference between Windows and Linux v...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.1.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: low trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-16 23:37 UTC by Alessandro Tassi
Modified: 2017-01-13 20:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
The same model of calc used on linux and windows. Try copy and past cells under the used area. (25.37 KB, application/vnd.oasis.opendocument.spreadsheet-template)
2013-12-16 23:37 UTC, Alessandro Tassi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alessandro Tassi 2013-12-16 23:37:51 UTC
Created attachment 90848 [details]
The same model of calc used on linux and windows. Try copy and past cells under the used area.

Good night,
using the same model file on linux and windows computers, when pasting cells on the bottom of the used area, calc uses different row heights: the right size on linux (43pt) as the upper rows to copy and 45pt on windows.
Using universal characters like Arial.
It may be a problem on automatic generated files (i.e. by basic macros) to print on multiple pages.

Yhanks.
Comment 1 tommy27 2013-12-31 11:39:57 UTC
which one you think is the correct behaviour, Windows or Linux?
Comment 2 Alessandro Tassi 2013-12-31 17:29:39 UTC
Hallo,
I think Linux is right because the first rows are 0,43 cm and there is no
reason why it must become 0,45 on automatic pasting by basic macros (as it
happens on Winz).
I have solved using the *IsStartOfNewPage* method that inserts a page break
on Calc (after a very hard research during 2 days...) and renouncing on
some rows.
Maybe it's caused by the difference between character size on Windows and
Linux, in fact on Windows it occupies more space (although I've used an
universal character like ARIAL).
However it would be strange as the first rows height already flled remain
on 0,43 cm.

Thanks a lot have an Happy New Year

Alessandro Tassi

.............

 DocEC = StarDesktop.loadComponentFromURL(FileModelloEC, "_blank", 0,
Dummy())
 FogEC = DocEC.Sheets(0)
 *FogEC.Rows(yNuovaPag * F).IsStartOfNewPage = True*
 copiarighe(FogEC, "A1:H" & yNuovaPag, FogEC, "A" & yNuovaPag * F + 1)


.....


sub copiarighe (Fog1 As Object, RangeName As String, Fog2 As Object,
Optional RangeDest As String)    'es: "A3:E3" dest: "A67"
 Dim CellAddress As Object
 c = Fog2.createCursor
 c.gotoEndOfUsedArea(false)
 Range = Fog1.getCellRangeByName(RangeName).getRangeAddress() ' range da
copiare
 'If Not RangeDest Then
 ' LastRow = c.RangeAddress.EndRow + 2
 ' CellAddress = Fog2.getCellRangeByName("A" & Lastrow).CellAddress '
destination cell - inserire puntino nell'ultima riga della pagina se deve
farne un'altra
 'Else
  CellAddress = Fog2.getCellRangeByName(RangeDest).CellAddress
 'endif
 Fog1.copyRange(CellAddress, Range)
End Sub


2013/12/31 <bugzilla-daemon@freedesktop.org>

>   *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=72770#c1> on
> bug 72770 <https://bugs.freedesktop.org/show_bug.cgi?id=72770> from tommy27
> <barta@quipo.it> *
>
> which one you think is the correct behaviour, Windows or Linux?
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 3 Buovjaga 2014-11-17 13:19:17 UTC
Right-clicked on the row numbers of 64 and 65, selected Row height, checked they are 0,43 cm.
Left-clicked 64, copied, pasted to 65.
Row 65 changed to 0,45 cm on Linux and Windows.

Win 7 64-bit Version: 4.4.0.0.alpha2+
Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-12_01:10:08

Ubuntu 14.10 64-bit Version: 4.4.0.0.alpha2+
Build ID: 3cf226622a3d8c09d655034dbcc81695f1662b87
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-15_23:24:22
Comment 4 QA Administrators 2015-12-20 16:10:49 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2017-01-03 19:47:33 UTC Comment hidden (obsolete)
Comment 6 Alessandro Tassi 2017-01-13 19:54:57 UTC
Ok it seems working on new versions.
Comment 7 Buovjaga 2017-01-13 20:08:35 UTC
Thanks for testing. Correcting status.