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.
which one you think is the correct behaviour, Windows or Linux?
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. > >
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
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.