I've done a search in both the Leo forums as well as xda in general and can't see a solution for my problem:
I am unable to scroll within excel mobile. Whenever I drag my finger across the screen it selects cells rather than scrolling. This isn't a problem if I wish to move up and down as the vertical scroll bar is visible and can be used. However, the horizontal scroll bar doesn't display even though it is selected in the menu.
Can anyone suggest what I can do to fix this? Thanks in advance.
bump
can anyone help?
When you open Excel, click on the right side of the screen (= scroll bar) and the scroll-button will appear. Use that to scroll up and down. The same goes for the horizontal scroll bar (well, it's on the bottom of the Excel screen and you scroll from left to right ;-)). Should be there, otherwise I wouldn't know.
Thanks for the reply but unfortunately the horizontal scroll bar isn't visible on the screen, even though when I go into view -> show the horizontal scroll bar checkbox is ticked.
The vertical scroll bar also works like a "normal" scroll bar in that the scrolling part is always the same size; it doesn't increase in size when the scroll bar is tapped on. However, I seem to remember that's how it used to work when I first got the phone, so perhaps in all the various tweaks and things I've done since I've unwittingly edited something that is affecting it?!
Oh well.
You're not in full screen mode are you?
And have you tried opening a new document?
No not in full screen mode, and I have opened various different (existing) spreadsheets, and tried creating a new one and the same thing happens in all of them.
I've solved the problem. A little look into HD2Tweak and I spotted an option for horizontal scroll bar which was set to none. I changed it to normal and a quick soft reset later and I was able to see the horizontal scroll bar again; not just in Excel but other apps too.
I don't remember switching it to none, but am just glad it's working again now!
Related
Hi,
I have an application which has been running nicely on Harrier and iMate devices, well any PPC devices really because of their rectangular screen shape.
My client has gone and bought some Palm Treo 700wx devices, and they have a smaller square screen.
In the resource of my project the screens are designed to fit PPC. When it runs on the Treo the Treo automatically pops up a scroll bar to allow the whole view to be seen.
The issue is when I first go into the app I can't see the top of the screen, about 20 odd pixels heigh aren't displayed. The scroll bar still displays and I can scroll down to the bottom of the view, and when I scroll up again the top of the screen is still out of sight.
If I exit the app just by tapping on the x in the top right corner (so the app is still running, not exiting properly via my Exit button which shuts down the app), I exit the app and then when I go back into the app the screens are displayed correctly, there is no missing space at the top of the screen.
If I exit the app via my exit button and then start the app again, the top of the view is missing again.
Does anyone know why the screen isn't displayed correctly when I first enter the app, or why it should come right when reloading the view again? Has anyone else had problems with screen layout when putting PPC apps on the square Treo 700wx?
Thanks
It sounds like you have a 'refresh' problem. I haven't encountered this my self and it is really hard to diagnose when you don't even tell us what language your app is written in, but basically here is what I think happens:
When your app is launched, part of its window doesn't get properly painted (not sure why exactly).
When you click the X the app isn't closed, but minimized.
When you return to it the window is maximized and repainted. Second repaint goes correctly.
The quick solution to this would be to force a window refresh just after the app is fully started.
Sorry I forgot to add the language.. it's written in eVC++ 3.0
I'll give the refresh a go, thanks
Further Questions..
I thought that minimising and then maximising the screen fixed the problem, but only partially..
Because the screen in resource is designed for regular PPC it is bigger than the Treo 700 screen size, so the OS automatically shows a scroll bar.
The new issue I'm seeing is to do with the scroll bar. The steps I take to reproduce the issue are:
1. Go to View1, and I scroll down the view (I'm using CView not CDialog)
2. Go to View2
3. Go back to View1. When I go back to the first view the scrollbar is scrolled down in the position I left it.
4. Scroll up to top of view and some of the controls in the wrong place. Some controls I dynamically create in OnInitialUpdate, and as part of the Create() I pass in CRect to tell it where to create the control.
If I set CRect.top to say 10, it's created 10 down from the top of the visible screen. The problem is that because I've scrolled the view previously the view draws it 10 down on the visible portion of the view.
I had thought that the easiest solution would be to always reset the scroll bar to the top of the view before creating my controls, but I'm not sure how to force the OS scroll bar to the top of the view. I've tried SetScrollPos(0,0) or ScrollWindow(0, y). ScrollWindow moves the actual view up or down, but the OS scrollbar is still in the same position.
Any ideas on how to set my view window to the top and to reset the scrollbar?
Thanks again
How to refresh a view?
I have sorted the issue mentioned just above, by finding the scroll position and factoring in that when I set the value of CRect area of the controls I need to dynamically draw.
I'm now just left with the first issue, of when I first start up the app the top part of the window and scrollbar are covered by the Title/Taskbar at the top of the screen.
If I close the app via the x button and restart the app, the issue resolves itself. Or if I open up any dlg like the About screen or even display an AfxMessageBox, when I close the dialog the original screen is redrawn correctly, in the correct position and scroll bar fully shown.
I have tried calling RecalcLayout(), RefreshWindow(), UpdateWindow(), Sending WM_SIZE messages and a whole range of things, but I can't seem to get the screen refreshing correctly apart from when I open any dialog and close that dialog.
When you close a dialog what messages get sent to the previous view that force it to redraw? Does anyone have any suggestions how I can force a refresh myself?
Thanks again
Did you try InvalidateRect?
I am getting a bit rusty with MFC, since I now try to do things the hard way and use pure win 32, but this should work.
If you can't use it as a class member, call the API directly using you view GetSafeHwnd() function for window handle). Use NULL for lpRect to redraw the whole window and FALSE for bErase to prevent flickering.
Note that UpdateWindow() only triggers repaint if part of the window becomes invalid (the contents needs redrawing).
No I hadn't thought of using InvalidateRect(), so I should give it a go.
In the end I just wanted the issue fixed so opted for a quick 'n dirty solution of displaying a temp CDialog as soon as the app starts and calling EndDialog() immediately in the OnInitDialog() so the dialog disappears before you see it.
It worked and the original screen gets updated to correct size, layout and scroll bar.
Cheers.
any way to reduce the size of menu bars top and bottom in landscape, or get rid of them in the way they disappear in opera?
matthew
Well, after much searching I found something called VJtoggletoday, but it doesn't appear to work with wm6.1. Also something called neunobar, but that just gets rid of the bottom menu bar altogether I think. Neither of these quite fits the bill. Any other ideas?
Hi guys,
I'm having a problem with setting contact icons on Windows Mobile 6.5. I'm actually running Dutty's Holy Grail R1, but I'm not sure that that's part of the problem.
To add an icon to a contact I navigate to the Photos and Videos tab. From there I select the picture and press Set as Contact Icon in the menu.
If I keep my phone upward all the time everything works: I get the crop selection, afterwards the Add to new/existing menu and I select a contact and everything works out.
However, then the contact icon is turned sideways. This makes sense, since the picture was also in landscape mode when cropping (i.e. the bottom was at the left side of the phone).
I think the solution by design for this is to turn your phone sideways when viewing the picture and selecting the Set as Contact icon menu item. This works up to the point when selecting Done after cropping. The next menu appears partially, or not at all, and I'm not able to set add the icon to a contact.
I've disabled Sense 2.5 in the UI, and that gives a bit more insight in what's going on. With Sense disabled and holding the phone in landscape mode, I do get the Add to new/existing menu briefly, but the start top bar also appears on the left side of the screen.
I think the phone is trying to rotate the UI to show the menu, but fails with the menu partially visible.
Are any of you having the same problem?
A solution might be to temporarily disable the G-sensor and rotate the screen manually. Or I could set the contact icon from the Contact card, but then I'm not able to crop. I'm actually using active sync, so I could also set my contact icons in Outlook, but the quality was really crappy when trying this.
Regards, Stijn
the HD2 has done something strange with programs that use dropdown menus - it has replaced them with a bar.
this is fine for some apps where you can use the slider at the side of the screen in order to scroll, but where there is a small box which just drops down a short list of data for you to choose from, the bar replaces the box, stops the list dropping down and thereby disables you from using the dropdown menu.
is there any way to stop it behaving in this way and reverting to the old form of dropdown menus?
thanks
rjstep3
I think I know what you mean. Can you give an example of where this happens?
"a picture paints a thousand words" but unfortunately I don't have a camara with me so can't take a picture to upload (at the moment).
An example is a program which give a list of dates in a dropdown menu - on my HD, that is fine, tap the box, the list of dates drops down, and I can select one. On the HD2, however, no dates drop down, but a bar appears inside the box, it's the sort of bar that appears at the side of screen when you use your finger to grab the side-bar and slide down a long window quickly.
That's the best description I can give in words. I was talking to someone who couldn't use the HD2 as it prevented him from using one particular app which used dropdowns extensively to enable selection of items from dropdown lists.
Hope that helps - can't find anything on it in the tips and tweaks, and searching generally reveals nothing at all.
Can't believe I am the only person with this problem/issue.
rjstep3
Again, I think I know what you mean.
Did you know you can scroll by moving the items in the dropdown up and down? You don't have to use the scrollbar. Obviously, if the dropdown is too narrow that won't work as you'll open the scollbar when you try to grab an item.
The alternative is to try a different theme. That might sound daft, but there was a thread a while back discussing how to get the popout scrollbar working and it turned out that it doesn't work on most of the themes. (I believe it only works on the HTC Black one).
Maybe that would help?
I think you do know what I mean!
As you rightly say, when I tap the scrollbar that has appeared inside the dropdown box, that opens up the entire list in a different screen, and so for this program at least, that is the workaround. Whether that works for all other programs that use dropdowns is another question of course.
I am using HTC Black - which I prefer as a theme, I try some others when work subsides and see if that helps.
thanks for quick posting.
rjstep3
rjstep3 said:
I think you do know what I mean!
As you rightly say, when I tap the scrollbar that has appeared inside the dropdown box, that opens up the entire list in a different screen, and so for this program at least, that is the workaround. Whether that works for all other programs that use dropdowns is another question of course.
I am using HTC Black - which I prefer as a theme, I try some others when work subsides and see if that helps.
thanks for quick posting.
rjstep3
Click to expand...
Click to collapse
No worries mate - good luck!
Using AT&T 950. Some of the apps go blank on some screens. Others are blocked out at the bottom of the screen by the navigation bar.
For example:
Ebay app - when I click on the search icon, the screen goes blank, but I still see the keyboard and top info bar. It will allow me to type and when I click enter, the search does come up. I can't see what s being typed, but do see the results.
Navigon - When I go to the map manager, the screen goes black again. (except for the top and bottom menu bars). If I rotate the phone to landscape and then back to portrait, it then shows up.
Podcasts - when on the Collection screen, the Download text is half covered up at the bottom with the bottom menu bar.
There's more but I think this gives a good representation. I was running the latest standard release. I did update using Windows Preview for Developers didn't fix it. Thanks in advance.
Will