Issue 36652 - Screen is messedup when entering a value with a macro
Summary: Screen is messedup when entering a value with a macro
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 1.0.3
Hardware: Other Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-11-04 10:01 UTC by robby2
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Calc file with attached macro that runs automaticly (10.25 KB, application/vnd.sun.xml.calc)
2004-11-04 10:04 UTC, robby2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description robby2 2004-11-04 10:01:43 UTC
Hi there,

I have made a macro with a keyhandler that enters the value "1" in a Calc-cell
everytime I press "F1" or "ALT-z". The high of cell gets smaller every time "F1"
is pressed. The row nuber keeps unchanged (a it should be). F.i. after pressing
"F1" several times the cells on line/row 7 that should show behind row nuber 7
are behind row number 6!. When I refresh the screen. Everything oke (untill i
presses "F1" again). Same thing with the ALT-z key. I found out it has something
to do wit h the conditional formatting on the cells. The Format profiel has been
taken over by Calc from the original Excel file.

I made two control cells in the calcsheet if the value of controlcell2 = "p"
than the conditional format 2 should be applied on some other cells else if
controlcell2 = "c" than conditional format 1 should be applied. 

If I change the setting of controlcell 2 from "p" in "c" and back again. The
problem is solved. If I remove the Controlcell1 (wich has noting to do with the
conditional format). Than the problem is solved also. If I enter the value "1"
by hand (=whitout the keyhandler), there is also no problem....

Strange, but true. I whould like to ad the Calc-file so you could just press
"F1" or "ALT-z" and see... However, I don't see the option to add the file...

Comment 1 robby2 2004-11-04 10:04:01 UTC
Created attachment 18921 [details]
Calc file with attached macro that runs automaticly
Comment 2 frank 2004-11-08 10:18:57 UTC
Hi Niklas,

repaint problem if you use the macro in page break preview.

Comment 3 Marcus 2017-05-20 11:13:19 UTC
Reset assigne to the default "".