I really like the Polaris office suite (I think it comes from the SGSII), but was having some issues with the spreadsheet. And there's no users manual on the web, although many people have searched for one.
I was trying to create a new sheet to convert prices from pesos to dollars, but I couldn't get the equations to work. Every time I put in "=b2/18", the answer would come up as "#value", meaning there was some error. It took a few hours to figure out that the price I was putting into column B was being interpreted as text.
To input as a number, using the swype keyboard, you need to select a blank cell (if it was already input as text, I haven't figured out how to tell it to think of the cell as a number). Menu...Edit mode. Press the cell entry box on top. Press the "SYM" key to get the number pad - but this is "text" numbers, as far as I've been able to tell. To get a real "number" number pad, you need to press and hold the 123 ABC key, until the number pad comes up. Now you can input equations and numbers as numbers, and not text. And all calculations now work.
Anyway, it's a really, really nice program. Press the function key next to the input box in edit mode, and see all the options. Wow.
This should be in Themes and Apps.
Thread moved to proper forum.
Related
when i place a phone call my normal procedure is:
1: press the green phone button
2: slide the keyboard out
3: begin typing a few letters of the name
4: use the arrow key on the keyboard to scroll down to the persons name <--- this is very important
5: hit return and talk
i am finding that i am unable to use the arrow keys to scroll down to select a contact on the Tilt as opposed to the HTC 6800. remember, i'm already have the kb open at this point and would prefer to just continue using it.
this then requires me to pull out the stylus or try and nail tap the contacts name from the list that appears.
it seems to only way to scroll through is to select Contacts first, start typing a few letters then scroll down and click the name then scroll some damn more and tell the phone to call. this strikes me as gratuitious.
has anyone else experience this annoyance and if so, has anyone found a solution?
i tried replacing the dialer with the touch dialer but it seems to simply skin the same lame functionality.
please advise.
I understand you want to use the kb at this point, but how hard is it to just raise your left thumb up 1.5" and use the D-pad?
I can duplicate the problem, but I've got a similar "OK... But..." comment.
Why use the keyboard? When the phone pops up, start tapping the numbers associated with the letters in the name and it'll intelligently start filtering the list. Then use a finger or the D-pad to select the one you want.
PerfAlbion said:
I can duplicate the problem, but I've got a similar "OK... But..." comment.
Why use the keyboard? When the phone pops up, start tapping the numbers associated with the letters in the name and it'll intelligently start filtering the list. Then use a finger or the D-pad to select the one you want.
Click to expand...
Click to collapse
ok - i had never really done that. im just so comfortable typing on the qwerty kb that that has always been the method i have used which worked up until this phone.
only irritant i can find with the dialpad method is there is no space key for first letter first name first letter last name.
i can live with it i guess but its not nearly as bling when yer tapping on the dial pad like every other phone out there instead of using your kick ass slide out keyboard.
the habit may have transfered from my days with a treo where you simply type the name and dial.
very convenient.
ADDRESS BOOK & OTHER PROBS FACED SINCE GETTING KAISER!-1st TIME HTC USER, NEED HELP!
Hey Everyone..
Have major probs with the following:
1) You can't have more than one mobile number per person. Some people have more than one number
2) Being able to create lists for purpose of emailing or texting a list. I mean you can create categories but you cant use the categories for anything apart from filtering your address book!???
3) Also being able to insert a number from your phonebook within a message (without sending a vcard)
4) When you slide out the keyboards, my appointments cant be seen on the screen (if held vertically you normally can, but when keyboard out you cant, well you can see the top of the text for this only) and you cant scroll down to see it neway but you should be able to see this only on the one page.
5) Speaker phone microphone doesnt work properly. People complain they cant hear me!
Anything out there to solve these?
Really appreicate your help.
1) You can't have more than one mobile number per person. Some people have more than one number
There more than 1 spot for phone #'s. work tel, mobile tel, home tel, car tel, company tel, work2 tel, home 2 tel. If someone you know has more than 7 phone #'s, and you didnt get them on the first 7 phones, they're probably dead in a gutter anyway.
2) Being able to create lists for purpose of emailing or texting a list. I mean you can create categories but you cant use the categories for anything apart from filtering your address book!???
Create lists for emailing or texting? Not sure what you mean here. But when sending email or texts, click on the "To:" and it will bring up your address book and you can add to your list of people getting it.
3) Also being able to insert a number from your phonebook within a message (without sending a vcard)
Pull up contacts. Select|copy| paste. It's just like windows XP.
4) When you slide out the keyboards, my appointments cant be seen on the screen (if held vertically you normally can, but when keyboard out you cant, well you can see the top of the text for this only) and you cant scroll down to see it neway but you should be able to see this only on the one page.
5) Speaker phone microphone doesnt work properly. People complain they cant hear me!
The speaker phone sucks on these phones and has since the first generation. Learn to not use it.
Hey Cheers for your reply,
in regards to your answers
1) Yep, I know you can put more than one number within that section, but lets say they have 2 mobile numbers (which many do these days to save money). Then if you put it within the home field you cant text it...?? Again anything that can be uploaded to improve this?
2) In terms of lists. On virtually every other fone..nokias, sony ericssons PDA phones, samsungs etc. You have the capability of making a list. i.e. if you are messaging the same group of people on a regular basis...e.g. for work you deal with a group of 10 contacts for a certain issue..you can select that list and it will come up with contacts in the "to" bit without selecting the contacts individually all the time..this is usually basic functionality in most phones to do this for texting and emailing..but surprised the Windows mobile doesnt have this. Its a function I have used a lot...so wondering if there is any program or something which can be uploaded to improve this?
3) With the copy and paste function tried it..and didnt work..even if it did.. it is really impractical..imagine you are writing a text to someone..Hi.blah blah blah..btw the number of ... is...and then as most phones again have..which is really basic..there should be an insert number from phonebook..but instead you have to come out of the whole text..go to the phonebook (which i have done btw)..copy the number..but guess what..as soon as I go back to the text..it doesnt allow me to paste it! Basic functionality problem there
4) Any body got a response to my number 4 above?
5) Yep thats what im trying to do
Thanks for your help..and appreciate if anybody has more suggestions for the above
1) Yep, I know you can put more than one number within that section, but lets say they have 2 mobile numbers (which many do these days to save money). Then if you put it within the home field you cant text it...?? Again anything that can be uploaded to improve this?
You can definately text the second, third, or whatever number in your phone book. Create your message and rather than starting to type the name of your contact into the 'To' field, click in the empty 'To' field to bring up the address book. if you select a contact with more than one phone number, a box will pop up asking you which number you want to use.
2) In terms of lists. On virtually every other fone..nokias, sony ericssons PDA phones, samsungs etc. You have the capability of making a list. i.e. if you are messaging the same group of people on a regular basis...e.g. for work you deal with a group of 10 contacts for a certain issue..you can select that list and it will come up with contacts in the "to" bit without selecting the contacts individually all the time..this is usually basic functionality in most phones to do this for texting and emailing..but surprised the Windows mobile doesnt have this. Its a function I have used a lot...so wondering if there is any program or something which can be uploaded to improve this?
You're right - it's a pretty common fuction and WM6 should have it. There may some commercial app available but I'm not aware of anything.
3) With the copy and paste function tried it..and didnt work..even if it did.. it is really impractical..imagine you are writing a text to someone..Hi.blah blah blah..btw the number of ... is...and then as most phones again have..which is really basic..there should be an insert number from phonebook..but instead you have to come out of the whole text..go to the phonebook (which i have done btw)..copy the number..but guess what..as soon as I go back to the text..it doesnt allow me to paste it! Basic functionality problem there
I normally try to get the phone number before starting the text! it's then so much easier to insert when you're writing your text. Again, it's a pity this fuctionality isn't built in.
4) When you slide out the keyboards, my appointments cant be seen on the screen (if held vertically you normally can, but when keyboard out you cant, well you can see the top of the text for this only) and you cant scroll down to see it neway but you should be able to see this only on the one page.
You mean the HTC home plugin takes up to much room? Yep, it does! But then you don't need to use it. Experiment with different home screen plugins from SPB software, such as SPB diary, SPB shell etc. You should be able to find something to suit you.
5) Speaker phone microphone doesnt work properly. People complain they cant hear me!
The speaker phone sucks on these phones and has since the first generation. Learn to not use it
5) Yep thats what im trying to do
The speakerphone sucks? Does it? I don't use it, but will have to test it now!
HTC
FrankyG
3) With the copy and paste function tried it..and didnt work..even if it did.. it is really impractical..imagine you are writing a text to someone..Hi.blah blah blah..btw the number of ... is...and then as most phones again have..which is really basic..there should be an insert number from phonebook..but instead you have to come out of the whole text..go to the phonebook (which i have done btw)..copy the number..but guess what..as soon as I go back to the text..it doesnt allow me to paste it! Basic functionality problem there
I agree its a little inconvenient, but if your a fast user you can easily tap the windows key then contacts then quickly locate the contact, copy the number and then paste it into the msg (by hitting start then messages or the message button on the phone itself).
# 4 You need some software like SPB Mobile Shell (search for the thread called post a picture of your today screen). Because there is no current way to decrease the size of the clock. You can disable the HTC Home plug in (clock and sms/phone/email notification icons) then the whole screen will be the bottom part, but you forego the cool weather/launcher/profiles/today plugin of HTC.
# 5 speaker phone like camera plain SUCKS!!!
I came from an iPhone about a month ago, and have a few questions:
1 - Is there a 'copy and paste' function like on the iPhone, so where I could copy and paste text say from a web page.
2 - Is there a way to 'zoom in' when entering text? So when I type a line on the iPhone and want to go back and correct something, I can press and hold to zoom in and find an exact place to put the cursor in. With the Captivate I can't zoom in and it's hard to get the cursor in the right place.
3 - This phone has flash support, yet there are still multiple websites I go to (try Taco Bueno) use flash and the flash icon is still displayed. Do I not have the latest version, is there a way to get it outside of just waiting for Froyo.
Thanks for all your help!
#1 - For copy and paste from a website, you need to press the MENU button, then MORE, then SELECT TEXT. Then on the website, highlight the test with your finger and it will copy and paste it to the clipboard.
#2 - This is a little more convoluted. If you're using the Samsung keyboard, long press on the ?123 key and it will bring up some cursor buttons. You can use them to move the cursor to where you want it. Or you can just press the line of text where you want the cursor and it may take a couple of tries, but it places it fairly well for me.
#3 - Not 100% sure about this one. I think the flash support is limited and not complete.
Hope this helps!
AsSiMiLaTeD_77 said:
I came from an iPhone about a month ago, and have a few questions:
1 - Is there a 'copy and paste' function like on the iPhone, so where I could copy and paste text say from a web page.
Yes, depending on the exact program you are using, pressing the menu button or long pressing on the screen will allow you to do this.
2 - Is there a way to 'zoom in' when entering text? So when I type a line on the iPhone and want to go back and correct something, I can press and hold to zoom in and find an exact place to put the cursor in. With the Captivate I can't zoom in and it's hard to get the cursor in the right place.
if you use the Swype keyboard, swyping from the swype logo to the SYM button will bring up a hidden menu where you can maneuver and highlight around the input you currently have focus on. It's very handy for changing misspellings and such.
3 - This phone has flash support, yet there are still multiple websites I go to (try Taco Bueno) use flash and the flash icon is still displayed. Do I not have the latest version, is there a way to get it outside of just waiting for Froyo.
Not currently. Any website that requires Flash 10.1 is only available with a Froyo ROM. There is a rumor flying around somewhere that someone managed to port Flash 10.1 to Eclair, but it's highly unstable.
Thanks for all your help!
Click to expand...
Click to collapse
My text in bold.
Let's say someone sends me a tracking number in an email, how do I copy that and paste it into a search box in the browser?
I don't care for the spelling correction thing on the swype keyboard, and the samsung keyboard doesn't have it at all, is there another keyboard that I can download?
I was using Swype for the past year and really liked it. I find the new android kb even better. Once you uncheck the "dynamic floating preview" (which I think is distracting) it looks and works great! One thing I didn't like about Swype is it wouldn't suggest any email address that started with a number. Since I have a few that I use a lot, it was a pain. Now you can enter anything into your personal dictionary and assign a nickname, then type the nickname and your word will show up. You can even add a sentence to the dictionary, assign "fav" as a nickname, and that sentence will pop up when you type fav.
Do wish it had numbers on the main screen. Hopefully a theme will become available with more long press options on the main keys, and maybe even color options.
Basically ever since I got my N5. The bigger screen kinda messes me up when I text or use the keyboard at all. Sometimes I use the swipe method to write on my phone, but other times I just do old fashioned button presses. When I text normally and I go to hit the space bar I will usually hit the period by accident. I'm pretty fast and don't usually look over my texts before I send them so my friends usually get text messages from me that look sometime like this;
"Hey.what are.you.doing today after work? You.wanna.go.grab.lunch at subway.or something?"
I never did it on my slide out phone obviously, or my gnex. This screen is just wide enough to make it happen for me. I'm still not used to having to reach so far right when trying to put in a period. Also I disable double tap space to enter punctuation. I find it annoying.
Not really a complaint or trying to vent at all. Just curious if I was the only one who did this as I have been called out on several occasions by multiple people as to why I replace my spaces with periods.
FYI I put this in general and not Q+A because it's not a serious issue that I need support for and I believe Q+A should be reserved for those kinds of posts.
I'm a big proponent of just using voice recognition for entering texts...sure, you can't always do it for discretionary purposes, not to mention sometimes it makes you look like a weirdo...
But now that the voice recognition is built into the phone it works so well.
Thanks for the reply. I only ever use that driving.
I leave it mounted on Google Now. That way I can say text so and so or navigate to, etc. When I'm not driving I usually just text normally or swipe.
I agree that voice to text works very well on this phone as well. Back on my Droid X it would never pick up my sentences correctly. I guess my bad luck with it previously helps account to why I don't use it much.
I also literally just noticed something about the keyboard I never realized. It's probably been around forever, though. When you want to input a number, you can long press the top row of keys to get that number or you can just press the symbols key and open the keypad with the numbers. That I knew. I just figured out you can press the symbols key and without picking up your finger, swipe somewhere on the keyboard and it switches to the symbols page. Release your finger on the desired key and bam. Number or symbol inputted and your back on the alphabet keys. This method is faster than the other two. Awesome.... And sorry for being so far behind.
I like the voice to text as well it works really good especially if you speak clearly. Sometime though, you don't have that option. That's where a different keyboard comes into play. There are soooo many in the play store. Have you tried one? Some are so customizable it's insane. Some to try out: perfect keyboard, smart keyboard, SwiftKey, swype, touchpal, thumb keyboard, and about 50 more
Nexus5
I.did.this.all.the.time.on.sub.5.inch.devices.
The screen on this device actually makes typing a fabulous experience. I rarely ever hit the "." unintentionally, and I rather enjoy typing again.
My last device had a 4.3 inch screen, and I would make this mistake all the time.
Sent from my Nexus 5 using XDA Premium 4 mobile app
I have to say, it got easier for me. On my n4 I had the exact same problem. But the n5 has the perfect screen size for writing in my opinion.
It only rarely happens that there is a "b" or "n" instead of space.
But I really had to get used to in the beginning.
RoyJ said:
Basically ever since I got my N5. The bigger screen kinda messes me up when I text or use the keyboard at all. Sometimes I use the swipe method to write on my phone, but other times I just do old fashioned button presses. When I text normally and I go to hit the space bar I will usually hit the period by accident. I'm pretty fast and don't usually look over my texts before I send them so my friends usually get text messages from me that look sometime like this;
"Hey.what are.you.doing today after work? You.wanna.go.grab.lunch at subway.or something?"
I never did it on my slide out phone obviously, or my gnex. This screen is just wide enough to make it happen for me. I'm still not used to having to reach so far right when trying to put in a period. Also I disable double tap space to enter punctuation. I find it annoying.
Not really a complaint or trying to vent at all. Just curious if I was the only one who did this as I have been called out on several occasions by multiple people as to why I replace my spaces with periods.
FYI I put this in general and not Q+A because it's not a serious issue that I need support for and I believe Q+A should be reserved for those kinds of posts.
Click to expand...
Click to collapse
attached is an image of SwiftKey's 'compact mode'. it can be pushed to either side of the device and makes it easier to type with one hand on the bigger devices
This happens to me as well. It never happened on my nexus 4.
Sent from my Nexus 5 using Tapatalk
This is probably not the input you're looking for but it is a good habit to review what you typed before you send it. The recipients, and you, will appreciate it.
You should think about taking off some extra buttons (in Advanced settings) -- if you remove both the Voice Input button and the language toggle, the space bar is much bigger (making it an easier target).
This happens to me all the time on my old S2! However I've taken special care to stretch my thumb further, so I don't get that as much.
I use Smart Keyboard Pro and removed the comma button to lengthen the keyboard.
Maybe a solution for you is to use Smart Keyboard Pro, remove the fullstop button and add in the comma button (it's on the left) so your right thumb will hit the space button for sure. Only issue then is getting used to holding down the comma button for a fullstop