Notices

ActiveSync Why has it taken so long for this category?

Reply
 
LinkBack Thread Tools
Old 10-17-07, 01:03 PM   #1 (permalink)
Aximsite Prospect
 
Join Date: Oct 2007
Location: Lewis County, KY
Posts: 2
Device: Nokia
Carrier: Net10
Thanked 0 Times in 0 Posts
Excel file conversion

When I compose an Excel file on my PDA and back it up on my PC everything is ok. However, when I make changes to the file, while on the PC, and then copy and convert it to the PDA, this is wherein my questions lies. The file size on my PC is, for example, 259K. I can view the file as normal, but if I make any changes (while on PDA) when I exit I get a dialog box popup which states the following: Unsupported content and formatting may be lost if you save this workbook. Tap Save As to create a copy or replace file. Tap discard to close workbook without saving changes. It adds a (1) to the end of the file name and now the file size is 1.27M. Both files look and respond the same. Why is the latter nearly 5 times the size? Am I doing something wrong?
frogman52 is offline   Reply With Quote
Sponsor Ads
Old 10-17-07, 01:36 PM   #2 (permalink)
Aximsite Hall of Fame
 
Jogga's Avatar
 
Join Date: Feb 2006
Location: United Kingdom of Great Britain & Northern Ireland
Posts: 6,246
Device: htc Touch 3G
Carrier: Orange
Thanked 2 Times in 1 Post

Awards Showcase
Aximsite Bronze Contributors Aximsite Active Silver Member Top Notch MyPDA Aximsite Silver Contributors Aximsite Contest Winner Bronze Poster 
Total Awards: 6

Welcome to Aximsite frogman52

Are you creating the original workbook on your pc? If so, does it have any cell or font formats that aren't compatible with the pda? You will notice that the .xls format is changed to the pocket Excel file type when you copy to your device, non-supported formats will be discarded and this often gets Pocket Excel a bit bothered.

You might try an alternative spreadsheet program that doesn't require converstion - SpreadCE is free and is far superior to the bundled application. It reads .xls without conversion, so it will probably be a better option.
Jogga is offline   Reply With Quote
Old 10-17-07, 04:33 PM   #3 (permalink)
Aximsite Elite
 
Julie's Avatar
 
Join Date: Dec 2005
Location: USA
Posts: 3,113
Device: windows mobile phone
Carrier: AT&T
Thanked 3 Times in 3 Posts

Awards Showcase
Aximsite Active Silver Member Top Notch MyPDA Aximsite Active Bronze Member Member of the Month Moderator Medal 
Total Awards: 5

Excel files have quite a lot of overhead in them. Full version Excel files are fully compatible with pocket pcs, but if space is an issue, then you'll save or convert them to pocket excel and the file size will be much smaller, as you have reported.

The more advanced features of Excel are not supported in the version of Excel that runs on a pocket pc. I would not be real concerned about that message when you save files, unless you are using these more advanced features and functions.
__________________
Julie | Microsoft MVP Mobile Devices | Mobility Site Moderator | Judge, Smartphone & Pocket PC Best Software Awards 2007 & 2008 | visit my blog:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Julie is offline   Reply With Quote
Old 10-19-07, 04:55 AM   #4 (permalink)
Aximsite Prospect
 
Join Date: Oct 2007
Location: Lewis County, KY
Posts: 2
Device: Nokia
Carrier: Net10
Thanked 0 Times in 0 Posts
Thanks

Thank you very much for your replies!
frogman52 is offline   Reply With Quote
Old 10-19-07, 10:14 AM   #5 (permalink)
hstn
Guest
 
Posts: n/a
PlanMaker for ppc's by SoftMaker is another option if you're looking for a full-featured program on the handheld.
  Reply With Quote
Old 10-19-07, 11:30 PM   #6 (permalink)
Aximsite Major League
 
srvctec's Avatar
Senior Member
 
Join Date: Nov 2006
Location: Central Kansas, USA
Posts: 451
Device: Samsung Hue SCH-R500
Carrier: Alltel
Thanked 14 Times in 13 Posts

Awards Showcase
Aximsite Contest Winner 
Total Awards: 1

Originally Posted by Jogga View Post
You might try an alternative spreadsheet program that doesn't require converstion - SpreadCE is free and is far superior to the bundled application. It reads .xls without conversion, so it will probably be a better option.

I have an interest in this thread as I'm looking for a better Excel program for my PDA as well. But, according to the PDA software websites, it is not freeware but shareware for $20. I couldn't find a free version anywhere- free to try, but not free forever.
__________________
Kurt B
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
srvctec is offline   Reply With Quote
Old 10-20-07, 05:13 AM   #7 (permalink)
Aximsite Hall of Fame
 
Jogga's Avatar
 
Join Date: Feb 2006
Location: United Kingdom of Great Britain & Northern Ireland
Posts: 6,246
Device: htc Touch 3G
Carrier: Orange
Thanked 2 Times in 1 Post

Awards Showcase
Aximsite Bronze Contributors Aximsite Active Silver Member Top Notch MyPDA Aximsite Silver Contributors Aximsite Contest Winner Bronze Poster 
Total Awards: 6

Originally Posted by srvctec View Post
I have an interest in this thread as I'm looking for a better Excel program for my PDA as well. But, according to the PDA software websites, it is not freeware but shareware for $20. I couldn't find a free version anywhere- free to try, but not free forever.
It's a while since I downloaded it however, it used to be free to download and use but came with an annoying splash screen at start up: the registered version (I recall paying $10!) gets shot of the credits.

BTW, even at $20 I would not blink at purchasing this spreadsheet application, that's how good I think it is (see View MyPDA): for the last four weeks, my Axim and this application have been used to collate product location data for six hours a day without a hitch. :approve:

If it's still available to try before you buy, I would give it a go.
Jogga is offline   Reply With Quote
Old 10-22-07, 07:40 PM   #8 (permalink)
Aximsite Major League
 
srvctec's Avatar
Senior Member
 
Join Date: Nov 2006
Location: Central Kansas, USA
Posts: 451
Device: Samsung Hue SCH-R500
Carrier: Alltel
Thanked 14 Times in 13 Posts

Awards Showcase
Aximsite Contest Winner 
Total Awards: 1

I tried SpreadCE this morning and it IS a fantastic Pocket Excel replacement. I may just have to buy yet another program for my x51v. :) The only thing it is lacking compared to Pocket Excel is the option to sort, at least I couldn't find it. So I created a file with SpreadCE and used Pocket Excel to sort it. Other than that, it's perfect!

Thanks for the heads up on this!!
__________________
Kurt B
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
srvctec is offline   Reply With Quote
Old 10-23-07, 01:32 PM   #9 (permalink)
Aximsite Hall of Fame
 
Jogga's Avatar
 
Join Date: Feb 2006
Location: United Kingdom of Great Britain & Northern Ireland
Posts: 6,246
Device: htc Touch 3G
Carrier: Orange
Thanked 2 Times in 1 Post

Awards Showcase
Aximsite Bronze Contributors Aximsite Active Silver Member Top Notch MyPDA Aximsite Silver Contributors Aximsite Contest Winner Bronze Poster 
Total Awards: 6

Originally Posted by srvctec View Post
I tried SpreadCE this morning and it IS a fantastic Pocket Excel replacement. I may just have to buy yet another program for my x51v. :) The only thing it is lacking compared to Pocket Excel is the option to sort, at least I couldn't find it. So I created a file with SpreadCE and used Pocket Excel to sort it. Other than that, it's perfect!

Thanks for the heads up on this!!
Glad to help :)

You'll also be pleased to learn that you can sort your spreadsheets with SpreadCE: Select the cells or data to sort > tap Format > tap Data > select the Sort... option.
Jogga is offline   Reply With Quote
Old 10-23-07, 11:43 PM   #10 (permalink)
Aximsite Major League
 
srvctec's Avatar
Senior Member
 
Join Date: Nov 2006
Location: Central Kansas, USA
Posts: 451
Device: Samsung Hue SCH-R500
Carrier: Alltel
Thanked 14 Times in 13 Posts

Awards Showcase
Aximsite Contest Winner 
Total Awards: 1

Originally Posted by Jogga View Post
Glad to help :)

You'll also be pleased to learn that you can sort your spreadsheets with SpreadCE: Select the cells or data to sort > tap Format > tap Data > select the Sort... option.
I couldn't find that for the life of me (I must be blind!)!! Now it IS a perfect replacement for Pocket Excel (actually it's 10 times better than Pocket Excel). I'm going to purchase it right now.

Thanks one more time!!
__________________
Kurt B
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
srvctec is offline   Reply With Quote
Old 11-20-07, 06:04 PM   #11 (permalink)
Aximsite Prospect
 
Join Date: Nov 2007
Posts: 4
Thanked 0 Times in 0 Posts
1) There wasn't room to reproduce all of the menus of the desktop version of Microsoft Excel (File Edit View Insert Format Tools Data Window) separately in the limited width of a Pockt PC screen, so I had to compress them somewhat. All of the supported Data menu options, such as Sort, are hung off the Format menu in SpreadCE. The other menus I have tried to keep similar to the arrangement in Microsoft Excel.

2) The program is more "nagware" than shareware. You are free to use the shareware version as long as you like. The only difference between the Shareware and Registered versions is that the Shareware version displays a message each time one of the File menu options is used.
stephenbye is offline   Reply With Quote
Reply

Tags
conversion, excel, file

Sponsor Ads

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 01:47 AM.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2003-09 LeckMedia, LLC