1. Are you ready for the Galaxy S20? Here is everything we know so far!

HELP! ~Tearing my hair out!!

Discussion in 'Android Devices' started by frogjourney, Aug 10, 2012.

  1. frogjourney

    frogjourney Newbie
    Thread Starter

    ~Tearing My Hair Out~ ideas??
    Hello there all, New to the forum but have looked through all the pages of posts (no I didn't read every post...but I spent some time luriking)

    I got my nexus a week or so ago and am having trouble figuring out how to do one thing I really want/ need to do.

    At the moment I have about 100 MB of files I want to be able to access offline on the nexus. I have them on my PC and in google docs. Having to toggle each one to make available offline is kind of a deal breaker so I am coping these files over manually.

    One of these files is a spreadsheet in which I link some of the cells to .pdf files in the same directory. On my PC when I click in the cell with the link, it opens the pdf it was linked to.

    FOR SOME REASON these links will not work on NEXUS 7, and I can't for the life of me figure out how to make this work

    . I have tried Office Suite Pro, Quick Office Pro and Kingsoft office. At least one of them allows a hyperlink, however it expects an internet connection to resolve the link. I don't have the choice to link to a document, and I try changing the webpage link to //sdcard/documents/rest-of-the-path.tomyfile but it does not work.

    SO I figured I'd code it in html...easy right? The local offline html file does not read in Mozilla, Dolphin, or the android html viewer.

    SO I read that in Quick office the pdf links will work so I made the spreadsheet a .pdf and the links did not work there either.

    I thought about making the docs into an ebook format, but it seems like a lot of trouble and I will need to add new pages with new links every couple of weeks.
    Help!! Anyone???

    1. Download the Forums for Android™ app!


  2. Jarred1

    Jarred1 Newbie

    Get Google drive or drop box from the app store. I know you can put drop box on a desktop PC and drop files in the folder and they will show up on you mobile device.
  3. Unforgiven

    Unforgiven ...eschew obfuscation...

    Google drive will sync your Google docs for you. I would give that a shot.
  4. frogjourney

    frogjourney Newbie
    Thread Starter

    They Syncing isn't the problem, I can do that manually. In Google drive, would need to tag each file to be available offline...it's easier for me to update the "sync" by copying the files in this case.

    The problem is the links in Excel aren't working as links. I tried everything...maybe I didn't explain myself well? :/ ....or maybe you only read the first part of the explanation of my problem?

    Anyway...still need an answer ~~bump~~

    (edited for spelling errors; omission of letters)
  5. Unforgiven

    Unforgiven ...eschew obfuscation...

    Sorry, I did read your whole post, I think I kinda got my brain tied in a knot.:rolleyes: Let me try out linking when I get home and see if I can get that figured for you.
  6. HotRoderX

    HotRoderX Android Enthusiast

    don't you have to shift click links in a Excel, Word, PDF file to allow the link to launch? I wonder if this could be part of the issue?
  7. frogjourney

    frogjourney Newbie
    Thread Starter

    @ Unforgiven!!! _much appreciated thank you!!!

    @HotRoderX - any idea how to do this on the nexus? I can't get the links to "select" at all in .pdf, I can't get the keyboard to pop up in excel unless it thinks I am going to edit, and I can't get the html doc to read on nexus at all.

    ((remember this is offline linking to local files)) I thought for sure I'd get somewhere trying that path method where Kingsoft asks for the http:// but I am striking out all over!!!
  8. JanComputerman

    JanComputerman Android Enthusiast

    Did you enter you link this way ? Google docs help

    =hyperlink("www.google.com";"search the web")

    This makes "search the web" appear in the cell but runs the url
  9. frogjourney

    frogjourney Newbie
    Thread Starter

    I'm not sure I am understanding Jan, I don't want to go to the web, I want to go to a local file, specifically a .pdf
  10. JanComputerman

    JanComputerman Android Enthusiast

    I tried using the example Google docs had in help

    =hyperlink("file://storage/sdcard0/test02.txt";"edit local")

    With the changes made from web to a local reference but apparently they preceed the link in quotes with HTTP:// so that any chance of doing a local reference is prevented. If you could reference a web location for the file you would be all set.
  11. frogjourney

    frogjourney Newbie
    Thread Starter

    Ahhh yes but the problem is I need access to this stuff offine. Of course...that's why I'm posting here I have tried every which way to make this work and am getting nowhere!
  12. I use Download All Files: https://play.google.com/store/apps/details?id=com.hwkrbbt.downloadall&feature=nav_result#?t=W251bGwsMSwyLDNd

    If I'm in one of my Google Drive Folders - I long press on the filename, then 'Open with' & Complete action using 'Download All Files'. Just follow the app instructions to save to any folder you want...
  13. JanComputerman

    JanComputerman Android Enthusiast

    this may be the only way you can make it work, by bringing into the browser cache you can make files that normally are on line available when you are offline and google docs maybe be able to see them or any other app referencing them as a web file.
  14. frogjourney

    frogjourney Newbie
    Thread Starter

    Hey guys! I appreciate the help and I ended up calling Google. First the tech told me I already greatly surpassed his knowledge base. Then he told me I'm really creative and should hook up with a dev and develop some apps, that what I wanted to do is just not possible on the Nexus.
    So I spent the day figuring out how to make a kindle e book. Links work inside the Kindle book reader. Well now I can make an ebook in Word formatted for the Kindle. Go me!!! :viking:<--that would be me pounding Nexus into submission. Now actually I can delete most of those files and the kindle book format takes up LOADS less space! I think in book form it's about 20-25% of the size of the directory of .pdfs.
    ...and the e book I can send to the tablet via the kindle wifi.

    :D anyone know Android Devs that may want to work with me? ~LOL~
  15. JanComputerman

    JanComputerman Android Enthusiast

    Nice! Yeah kindle Formatting can be fun and there are a lot of ways of converting. I have done a bunch of small documents and one very long book ... about 900 pages with linked TOC and hours of formating corrections.
  16. frogjourney

    frogjourney Newbie
    Thread Starter

    WOW! Sounds cool Jan! I might do other e books (just for myself of course because I want them to be accessible and have links to pages within the doc)
    What sort of book did you write if you don't mind me asking? Also (again) If You don't mind me asking how did you do the TOC and linking?
    I ended up doing all the links in word.
    Then when I built the book in mobi creator, there was some option to do a TOC but I had already set up the structure and made the links. I'm guessing since I will need to add more to the doc and TOC (index) each month, Word will be the way to go and that in mobi I would have to redo everything each time.
  17. JanComputerman

    JanComputerman Android Enthusiast

    It was for a client, sort of a historic steamy romance novel, and she double spaced the entire book, sometimes using blank lines or extra returns instead of the word formating command. Quote marks were also miss matched and there are 3 different types that were mixed. Everything was done in microsoft word but with minimum formatting so that the conversion to kindle format would be correct. Depending upon which conversion program you use, the toc can be generated in the conversion program or in word. If you use word you have more control but I think if you use the conversion program commands it is generated automatically with hypertext links and additions to it are simple. I would have to look at my notes from earlier in the year to see exactly the fine points which I figured out during the project.
    frogjourney likes this.
  18. frogjourney

    frogjourney Newbie
    Thread Starter

    It's not an urgent look up but I'd be interested. :D
  19. JanComputerman

    JanComputerman Android Enthusiast

    I think you just use a Style with a certain wording which the conversion program recognizes and it automatically creates a table of contents entry and a hypertext link to the page. There was also settings for the cover page of the book with the photo. When it is done properly it looks like every other professionally published ebook.
  20. JanComputerman

    JanComputerman Android Enthusiast

    Ha found my notes on my KF
    I used Caliber for the conversion, you save the document as html filtered with msword and then convert with the program, photos work then including on the cover, which come out in zoomable form hirez.
    frogjourney likes this.
  21. frogjourney

    frogjourney Newbie
    Thread Starter

    I just added your notes for Caliber to my notes for formatting in Word and using mobipocket Creator! Thank you very much! I might try Caliber next time around!! :D
  22. vette

    vette Newbie

    Calibre is awesome. I use it to manage my ebook collection (27k books) and convert them into usable formats.
  23. JanComputerman

    JanComputerman Android Enthusiast

    Yeah it did about the best conversion of all I read about and tried, the big thing is to have a really clean formatted document or else weird things can happen to the output file. Justification can really go crazy for one thing!
  24. frogjourney

    frogjourney Newbie
    Thread Starter

    yeah now that I made a book I pretty much can't show to anyone I am thinking about writing another for personal use that I might even be able to publish.

Share This Page