[Solved] Can't set a custom paper size correctly

[Eatmeat]

I'm trying to set a custom paper size, width 21 cm and height 14.85 cm, but instead it is set as 37.05 cm and 26.2 cm. What's interesting if I set paper size of A4 (21000 and 29700) it gets recognized as A4 and set correctly. What do I miss?
OpenOffice 3.4.1

Code: Select all

Sub Main
	Dim Doc As Object
	Dim Sheet As Object
	Doc = ThisComponent
	Dim PaperSize as New com.sun.star.awt.Size
	Dim printerOptions(1) As New com.sun.star.beans.PropertyValue		
	printerOptions(0).Name = "PaperFormat" 
	printerOptions(0).Value = com.sun.star.view.PaperFormat.USER	
	PaperSize.Width = 21000
	PaperSize.Height = 14850
	printerOptions(1).Name = "PaperSize"
	printerOptions(1).Value = PaperSize
	Doc.Printer = printerOptions()
End Sub

Thank you.

[Eatmeat]

It's like it's multiplied by a factor of 1.764. Although documentation says "20000 corresponds to 20 cm" and my windows settings are metric.

[RoryOF]

Without knowing anything about your code, I remark that the dimensions you give are for A5 in landscape orientation. Perhaps, as a workaround, you could set the specific paper size by name and orientation rather than by dimensions.

[MikeytheMagnificent]

Would printing 2 pages on each sheet of A4 as RoryOF hinted printing a Brochure, as its called in OOo, which isn't the same as a Microsoft brochure, do the business without macros. But a word of warning when I tried to do this sort of thing (with 4, 6 or lots records per sheet) when trying to print some labels, it printed on alternate facets, leaving alternate ones blank

[RoryOF]

I wasn't thinking about printing two up, which, as Mikey suggests, is a possibility, simply recognising that A5 is a defined paper size within current AOO 3.4.1 (also A6, very useful for trial pagenumbering setups!).

[Eatmeat]

Sorry for not answering for so long.
I guess my wrong paper size problem is only solved by dividing by the magic number 1.764.

Would printing 2 pages on each sheet of A4 as RoryOF hinted printing a Brochure, as its called in OOo, which isn't the same as a Microsoft brochure, do the business without macros.

What I'm actually trying to do is always print on no more than a HALF of an A4 portrait, but no matter what paper size, orientation and scale mode I choose, it rotates the image (making it landscape) so as to fit it into a WHOLE A4 list.

[B Marcelly]

For your information, the paper size is measured in twips.
A twip is 1/20 th of a point; a point is 1/72 of an inch. That is, 1 twip = 1.76 x 1/100 mm

Back in 1994, I issued Bug 35660 to request the update of the documentation (which was easier than changing the code and compatible with existing user programs). But nothing was done.