Re: Re: A compatible problem

Hello Cor:
    Thank you very much for your help, I think the
information that you have given to me is valuable. But now,
I want to know whether this phenomenon is a bug? Does it
need to be fixed? I hope you can give me some suggestion,
thank you!

Best Regards

Gao Zemin




gaozm
2007-07-24



发件人： Cor Nouws
发送时间： 2007-07-23 18:23:22
收件人： devsc.openoffice.org
抄送： 
主题： Re: [sc-dev] A compatible problem

Hi Gao,

gaozm wrote:

> Hello Cor: I think it could be related to the distance
to the printed
> rows, beacause when open the Excel document who has
only one page(47
> rows) with Calc, and change the height of all the rows
of the Calc to
> 0.52cm, execute "Page Preview", there will be
only one page(47rows)
> showed. I'm looking forward to your suggestion, thank
you!

I'm not working in the core OOo-code, so can't take a look
there.
I've just done a little test and I think it is a rounding
problem in OOo.

The test:
Creating a sheet in Excel alows me to print 55 rows of 12,75
pts on a page.
Printing the same from Calc, gives 54 rows on a page. The
rows in Calc
are 0,45 cm height.
The margins on both pages are the same.

Then I tried the following in Calc:
I can't set the height to 0,445 cm. That is changed to 0,45
cm
I can't set the height to 12,70 pts. That is changed to 0,45
cm

I can set the height to 0,44 cm.
I can set the height to 12,61 pts. This displays as 0,44 cm
as well.
I can't set the height to 12,62 pts. That is changed to 0,45
cm again.

I hope this helps to find the problem.

> 
> 发件人： Cor Nouws 发送时间： 2007-07-23 16:39:52
收件人： devsc.openoffice.org 抄
> 送： 主题： Re: [sc-dev] A compatible problem
> 
> Hello Gao,
> 
> gaozm wrote:
> 
> 
> > Thank you for your help. I'm sorry because I found
that it was not 
> > related to the default row height of Calc. I have
changed the
> > default row height in ScGlobal::InitTextHeight,
but when open the
> > Excel document who has only one page(47 rows) with
Calc,the Calc
> > still showed two pages(46 rows and 1 row). Could
you give me some
> > help?
> 
> 
> Could it be related to a header or footer and the
distance to the 
> printed rows?
> 
> Kindest regards, Cor


-- 

Cor Nouws
Arnhem - Netherlands
nl.OpenOffice.org - marketing contact

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

Hello Gao,

gaozm wrote:
> Hello Cor: Thank you very much for your help, I think
the information
> that you have given to me is valuable. 

Glad I could given some help.

> But now, I want to know whether this phenomenon is a
bug? 

I can't judge the code, but I would call it a
compatibility-bug (at least).

> Does it need to be fixed? I hope
> you can give me some suggestion, thank you!

When such a phenomena occurs in a text document, fixing
would have
height priority, in my opinion.
But I think in a spreadsheet, printing is not done so often,
and less
page-oriented. Anyway, that is my view.
Fixing it would always be OK, but I'm not in a position to
judge about
priority.

Probably others on this list have ideas about cause and
priority?

Kindest regards,
Cor

> 
> 发件人： Cor Nouws 发送时间： 2007-07-23 18:23:22
收件人： devsc.openoffice.org 抄
> 送： 主题： Re: [sc-dev] A compatible problem
> 
> Hi Gao,
> 
> gaozm wrote:
> 
> 
>> Hello Cor: I think it could be related to the
distance to the
>> printed rows, beacause when open the Excel document
who has only
>> one page(47 rows) with Calc, and change the height
of all the rows
>> of the Calc to 0.52cm, execute "Page
Preview", there will be only
>> one page(47rows) showed. I'm looking forward to
your suggestion,
>> thank you!
> 
> 
> I'm not working in the core OOo-code, so can't take a
look there. 
> I've just done a little test and I think it is a
rounding problem in
> OOo.
> 
> The test: Creating a sheet in Excel alows me to print
55 rows of
> 12,75 pts on a page. Printing the same from Calc, gives
54 rows on a
> page. The rows in Calc are 0,45 cm height. The margins
on both pages
> are the same.
> 
> Then I tried the following in Calc: I can't set the
height to 0,445
> cm. That is changed to 0,45 cm I can't set the height
to 12,70 pts.
> That is changed to 0,45 cm
> 
> I can set the height to 0,44 cm. I can set the height
to 12,61 pts.
> This displays as 0,44 cm as well. I can't set the
height to 12,62
> pts. That is changed to 0,45 cm again.
> 
> I hope this helps to find the problem.
> 
> 
>> 发件人： Cor Nouws 发送时间： 2007-07-23 16:39:52
收件人： devsc.openoffice.org
>> 抄 送： 主题： Re: [sc-dev] A compatible problem
>> 
>> Hello Gao,
>> 
>> gaozm wrote:
>> 
>> 
>> 
>>> Thank you for your help. I'm sorry because I
found that it was
>>> not related to the default row height of Calc.
I have changed the
>>>  default row height in
ScGlobal::InitTextHeight, but when open
>>> the Excel document who has only one page(47
rows) with Calc,the
>>> Calc still showed two pages(46 rows and 1 row).
Could you give me
>>> some help?
>> 
>> 
>> Could it be related to a header or footer and the
distance to the 
>> printed rows?
>> 
>> Kindest regards, Cor
> 


-- 

Cor Nouws
Arnhem - Netherlands
nl.OpenOffice.org - marketing contact

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org