Excel files and ActiveStink issues. Please help. - General Topics

I'm just wondering if this is just my issue or if it's a common issue with WM5/WM6 and or the latest ActiveSync, 4.5. I'm having issues with syncing Excel files that used to sync just fine on WM2003. I have large spreadsheets that are about 325kb in size on the desktop. When I sync the file, it's the same size until I open it and try to make changes and save it. Then I get the following error:
"Unsupported content and formatting may be lost if you save this workbook..."
The only way I can save the spreadsheet is to rename it and create a new one with the same name. It then writes over the original file, taking up to 30 seconds to save. The file is then 969kbs in size. And every time I edit on the PC it goes back to 325kbs. Then when I edit on the PPC, it goes through this again, making the file almost a Meg.
Is there any way to just sync the file with just one format? This is really annoying. Also, sometimes my date formats are changed from month-day-year to day-year-month, or something retarded like that. Really freakin annoying to say the least. You buy MS products and they're not even compatible. I feel like I have a Palm trying to sync Apple documents or something. It's really ridiculous! I'm hoping that one of you genius' can point me to a setting that I've overlooked to fix this. Please help!
PS, I've tried to change the conversion settings in Active sync as well with no apparant effects.

Related

I have an interesting problem with WM5 Excel files

I just got an HTC P3300 with WM5. I installed Active Since 4.2 (I believe) and started to sync my files. I use a few very important Excel files. They sychronized to the phone, no problem. But when I try to edit them on the phone and save, I get the following error: "Unsupported content and formatting may be lost if you save this workbook. ..." All I have to do is change one character and I get this message. The problem is that it only gives me the option to save as a new document, cancel or discard changes. I now have 4 versions of the same document. It's a real PIA! Anyone know how to resolve this?
BTW: I'm using XP Home with Excel 2002.
Partial resolution
Well, I found out that there is a way to avoid creating another file. Simply rename the new version with the same name and it will just replace the old one. It's still a pain to have to do that every time I want to edit a document but I guess I'll have to live with it.
Strange thing is, my wife has WM5 on her Wizard (MDA) and used to sync with an old version of ActiveSync (probably 3.7 or so) and she never had this problem until she upgraded to ActiveSync 4.2. I tried to download 3.7 and use it, but it wouldn't even recognize my device. Had a bunch of sofware issues trying to download it also. So, I'll just live with the extra step to save an edited file on WM5 Excel.

WMPlayer Mobile, corrupt library everyday..help?

I've been trying to find the problem when syncing playlists and automatic-playlists through WMP11 (not thorugh ActiveSync but direct)..
I hardly get through the day and the library corrupts, having to delete the meta-data and update the library every time..then back home, syncing doesn't update the library on the device properly ..and the "Star-Ratings" get messed up, it syncs files, but doesn't update the playlists properly..it's a pain..
I even bought a new microSD because I thought it had bad-sectors, but it didn't change the behaviour..
Is this normal, or what am I doing wrong?
emugpp said:
I've been trying to find the problem when syncing playlists and automatic-playlists through WMP11 (not thorugh ActiveSync but direct)..
I hardly get through the day and the library corrupts, having to delete the meta-data and update the library every time..then back home, syncing doesn't update the library on the device properly ..and the "Star-Ratings" get messed up, it syncs files, but doesn't update the playlists properly..it's a pain..
I even bought a new microSD because I thought it had bad-sectors, but it didn't change the behaviour..
Is this normal, or what am I doing wrong?
Click to expand...
Click to collapse
If you don't need the library created by the desktop WMP but can also rely on for example CorePlayer's, Pocket Tunes' or Pocket Player's creating it from stratch, you might want to give them a try. Then, you'd only need to do an AS file-level sync (NOT from the desktop WMP), making sure you also sync the playlist files.
Also see my related bible.
I skimmed through your bible before I posted, very useful stuff, but the reason I "want" to use wmp-mobile is because you can create automatic-playlists in WMP11 with the newest podcasts, then on your device rate the files/podcasts when you've heard them, on the next sync these files get removed automatically..
it could be very comfortable and useful to listen to your podcasts this way, if the wmp-mobile library wouldn't corrupt all the time..
I've been using CRCs Stable 11.2 on my Hermes and suspect that maybe the sdcard-power-management-fixes might be causing wmp-mobile to write bad sectors in the library..from what i can think of..

Opera Mini 5 (Beta 2 WM) how to backup Bookmarks & Speeddial

Does anyone know how to save/backup/access the bookmarks and "speeddial" files?
I performed a device-wide search and discovered 40+ references to Opera, and a multitude of vaguely named files, but nothing that stood out clearly as a bookmark file or a speed-dial file, as in Opera for the desktop.
So, does anyone have any idea of how to access these files so I can back them up?
P.S. I refuse to use the "Opera Link" option because it always ruins my bookmarks on both my desktop and phone since it tries to sync them. I simply want to backup the ones that are on the phone (TP2) and that's it.
Bump.
Can't believe no one has an answer for this, bearing in mind the conditions outlined in the above post.
Well, it's not that hard to figure out-you've had plenty of time, lol.
Been a while since I used mini, but check the sub-folder in the mini folder. It has all the user info stored there, I believe in .db files. Just back them up and restore them. It's pretty easy to use mini, make a few changes to your speed dials, then just see which file(s) changed.

Transferring files from phone to PC without changing modified-date?

I have a problem, and it may seem minor and pedantic to care about but that's me.
So, I take all these pictures with my phone and I want them backed up on my computer, naturally. I want to transfer them comfortably, without a USB-cable. Thing is, the created and modified date always get changed with all the methods I've tried. It's very annoying. I have a whole bunch of pics saved up from previous phones etc and I want to be able to sort them in chronological order. I don't want 50 pictures that all have the same date attached.
So far I've tried:
Wifi File Explorer --> Changes date
SwiFTP --> Changes date
Upload to Dropbox --> Changes date
Zip pics and upload archive to dropbox --> Changes date
Please, what other methods could I try?
The only thing that works is plugging in the USB-cable transferring the files from the Removable disk. This is way too inconvenient for my taste.
scp will keep timestamp
or zipping the files, the archive will keep the timestamp as well.
hope could help
dbk3r said:
scp will keep timestamp
or zipping the files, the archive will keep the timestamp as well.
hope could help
Click to expand...
Click to collapse
Doesnt SCP require usb-cable connected? And I already tried zipping, it didn't work Which is weird cause it does on computers.
Worked with SSHDroid, yay!
Awesome advice, I had never thought about the time stamp thing.
great learning process continues with xda

Polaris Office corrupting .doc files

I've found that if i import an ms .doc file into polaris, edit it and then transfer it back to my pc, i'm unable to open the file - i get an error "unexpected error occured while reading". I get the same result whether i open it in word, wordpad, open office etc.
tried this with a few docs, even tried an factory reset, but the problem still occurs. maybe it's just a bad install on my transformer but at the moment it makes polaris pretty much unusable - if i can't sync up my documents, or send them to other people to open on their computers, then it's pointless.
has anyone else noticed this?
alan77ss said:
I've found that if i import an ms .doc file into polaris, edit it and then transfer it back to my pc, i'm unable to open the file - i get an error "unexpected error occured while reading". I get the same result whether i open it in word, wordpad, open office etc.
tried this with a few docs, even tried an factory reset, but the problem still occurs. maybe it's just a bad install on my transformer but at the moment it makes polaris pretty much unusable - if i can't sync up my documents, or send them to other people to open on their computers, then it's pointless.
has anyone else noticed this?
Click to expand...
Click to collapse
My PC is down right now, so I can't test, but I had edited a doc file that was emailed to me and sent it back without problems. Does this only happen when you edit an existing file or also with newly created docs?
Sent from my Transformer TF101 using Tapatalk
alan77ss said:
I've found that if i import an ms .doc file into polaris, edit it and then transfer it back to my pc, i'm unable to open the file - i get an error "unexpected error occured while reading". I get the same result whether i open it in word, wordpad, open office etc.
tried this with a few docs, even tried an factory reset, but the problem still occurs. maybe it's just a bad install on my transformer but at the moment it makes polaris pretty much unusable - if i can't sync up my documents, or send them to other people to open on their computers, then it's pointless.
has anyone else noticed this?
Click to expand...
Click to collapse
I couldn't get my PC to read a document I created and then transfered from the Transformer either. I could read it when I emailed it to myself and picked it back off of my email on the PC. Could be in the transfering?
DilloDroid said:
I couldn't get my PC to read a document I created and then transfered from the Transformer either. I could read it when I emailed it to myself and picked it back off of my email on the PC. Could be in the transfering?
Click to expand...
Click to collapse
tested with one excel and one doc document, didn't have any problems viewing them on PC.
Thanks for the response.
Seems to be an issue just on edited files. So it might be that the files on the PC are somehow corrupted. But then i don't have a problem editing and sending docs on my PC - it's only once edited through polaris that there's a problem.
i noticed that when i open up a doc polaris prompts me to 'remove protection' - no idea what that's about as i don't protect the files. maybe it's something to do with that.
Pretty sure it's not the transfer methods, i've tried bluetooth,ftp, drag 'n drop etc...same results.
In my line of work I have come across some interesting information about older office files (doc,xls,ppt). There was an update for office that basically broke them, if you opened an older format file and saved it corrupted them. This same problem may have gone across to Polaris.
Does Polaris allow use of the newer format files(docx,xlsx,pptx)? If so this might be a way around the problem.
Well i tried creating a new document on my PC, edited it in polaris then transferred it back and had the same problem. can't really try other file formats (odt, rtf) as polaris doesn't appear to support them. i might try a quickinstall/refund of one of the other office apps and see if the problem is replicated.
incidentally i can open the editd documents on the docs2go viewer app and i can upload to google docs. so it might be that i have an ancient version of word, but then surely open office should be able to open it ?
I had edited a file for work last week using Polaris (document file with images, headers, etc... ), so I tried opening it on my office PC using Office Word 2007 and it opens and renders perfectly.
Sent from my Transformer TF101 using Tapatalk
Ok well the problem does seem to lie with polaris. i did a quick install/refund of quick office and was able to edit docs and view them on my pc with no problems.
i've got a feeling it's to do with the 'remove protection' prompt i get in polaris, didn't get that with quick office.
maybe it's just a bad install on my device as no one else seems to have the problem. I guess i'm gonna have to call up ASUS as polaris doesn't seem to offer any support on its site.
Same probs here. Gdocs let's me view but not edit. Kword crashes, libre office can't open.
alan77ss said:
Ok well the problem does seem to lie with polaris. i did a quick install/refund of quick office and was able to edit docs and view them on my pc with no problems.
i've got a feeling it's to do with the 'remove protection' prompt i get in polaris, didn't get that with quick office.
maybe it's just a bad install on my device as no one else seems to have the problem. I guess i'm gonna have to call up ASUS as polaris doesn't seem to offer any support on its site.
Click to expand...
Click to collapse
I got that same message on the file I edited, but what I did was save a copy and worked off the copy. Not sure what the protection was, but that's what I did and it worked with opening the file on a PC.
Sent from my Transformer TF101 using Tapatalk
EP2008 said:
I got that same message on the file I edited, but what I did was save a copy and worked off the copy. Not sure what the protection was, but that's what I did and it worked with opening the file on a PC.
Sent from my Transformer TF101 using Tapatalk
Click to expand...
Click to collapse
Just tried your method and it worked with one file but that didn't prompt me for copy protection, but the other file with protection still wouldn't open. also tried creating a couple of docs in polaris from scratch but they wouldn't open either. it's just far too unreliable,i can't risk using this for work.
kind of thinking, to hell with it, i'm gonna buy quick office, it may be a tener but at least it works and you can actually paste stuff into it from other apps, which polaris doesn't do.
Had exactly the same issue, could write things / edit but once i saved it.... nothing would open it. Compounded by the known issue that you can't copy n paste from polaris (why!?).
The work around I use (while considering what office app to buy) is to send to google docs.
In view mode (not edit mode) click the menu and send to google docs (you'll need to have the google docs app installed first obv. - it then imports it and you can save from google docs, or email a link to the doc.
Hope this helps.
(long time reader first time poster)
With further testing I've found older versions of MS Word and Open Office won't open files edited on Polaris - Newer versions of MS Word will.
Can anyone else test and confirm this?
I tried a trial version of the newer word and was able to open up documents edited in Polaris - but it flagged up a security warning teling me it might be unsafe to do so.
But these were older documents writtten in an older version of word so maybe that has something to do with it. It might be that Polaris isn't handling older word documents properly.
I've been using Polaris Office for school work. Any file created in or edited with Polaris Office is seen by LibreOffice as outright corrupt. Can't open it at all. I tried opening the file on the school's computers with Word (probably the latest version) and it prompted me to open the file in "Protected mode" informing me that the file could possibly damage my computer (I assume they mean it could contain malicious code or something). Seems ASUS needs to get some bug reports about this.
Yep, exactly same issue... Lucky I got a backup of the files cause, only Polaris can read them!... sucks
Hello. I am using the Endnote X5 for my thesis and it makes some automatic arrangements on doc file. When I transfer the file to my Asus, polaris reads it. But back to my PC, not! So I realized that the doc files that contain plain text doesn't make any problem with polaris.
Possible Solution
I have had the same problem.
I could still open the document on my Android smartphone but not on my computer. I am using an old version of Office 2000. My android had 2 office suites that would read the office document. Polaris Office and OfficeSuite. Polaris would not seem to save it in any other format but Office Suite let me re save it in docx format. I then synced with my desktop and was able to open the docx file with Office 2000- though you need to install Microsoft's free file converter to do that.
I use MyPhone Explorer to sync between Android and desktop. I think the issue is associated with Polaris rather than MyPhoneExplorer as I have no other problems with that. I did wonder if Polaris had changed the format to docx without changing the postscript but just changing it to filename.docx did not make any difference so the full conversion seems to be the solution.

Categories

Resources