https://bugs.freedesktop.org/show_bug.cgi?id=72770
--- Comment #2 from Alessandro Tassi <[email protected]> --- 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 <[email protected]> > *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 > <[email protected]> * > > which one you think is the correct behaviour, Windows or Linux? > > ------------------------------ > You are receiving this mail because: > > - You reported the bug. > > -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
