Question: I have an interesting dilema and was wondering if someone might know if this is possible. I'm creating a .csv file using java and for one of the comma separated entries for each row is a url. 

**Example:**

item1,item2,item3,<http://myurl.com>

Originally when I loaded the .csv file in Excel, it loaded just the text for the url and wasn't making it clickable. I was able to solve this by just surrounding the entry with this string while creating the file:

**=HYPERLINK("<http://myurl.com>")**

When Excel loads, the link is clickable and the mouse pointer changes to the hand icon. The only problem is that when you are just looking at it and not hovering the cell, it just looks like black text on a white background. Usually when you see a link, it is blue with an underline signifying that it is clickable. I would like to have this visual queue, but I am not sure if there is a way of doing it just by modifying my function above with some sort of cell formatting function or something.

And Yes, I know what conditional formatting is and how to apply it to a cell in Excel. However, this will not work for me, because I just need it to work when the file is loaded. The file is always created new when a user downloads it, because the contents are always changing. Any ideas would be greatly appreciated.

Answer: 
Short answer is that you cannot have a ListView inside a ScrollView. Here is a [related SO thread](https://stackoverflow.com/questions/3495890/how-can-i-put-a-listview-into-a-scrollview-without-it-collapsing).

Looking at your layout you could redesign it to a RelativeLayout:

```
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <fragment
            android:id="@+id/myfragment"
            android:name="com.myapply.MyListFragment"
            android:layout_width="match_parent"
            android:layout_height="match_parent"
            android:layout_gravity="clip_vertical"
            android:layout_above="@+id/bottomTextView" />

        <TextView
            android:id="@+id/bottomTextView"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="TEST TEST TEST"
            android:textColor="#FFFFFF"
            android:layout_alignParentBottom="true"
            android:textSize="25dp" />

</RelativeLayout>

```
I did something similar to this, and I used the view ids as 'hooks' for the Fragments.

From my understanding of Fragments, they need to be hooked to a particular View ID, otherwise they don't get displayed. I simply created a View container that had twenty empty child views, all with id's numbered 0-19. I loaded this with the Activity, then attached the fragments to the views however I wanted.

Looked like:

```
<LinearLayout android:orientation="vertical"
    android:layout_width="match_parent"
    android:layout_height="wrap_content">

    <FrameLayout
        android:id="@+id/fragment_0"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">
    ....
    <FrameLayout
        android:id="@+id/fragment_19"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">
</LinearLayout>

```

I wasn't as good at creating and attaching child views dynamically as I am today. These days, I think I'd just have an empty LinearLayout or ScrollView, then attach views dynamically and generate IDs for them as I needed them. One of the problems that I ran into with this, was the inability to detach and re-attach Fragments to anything but their own ViewID; once attached to a ViewID, it must be reattached to that same ViewID. Small slowdown, but not if you keep this ID, you may be able to recreate a new FrameLayout and set the ID to what it was before (don't know for sure). 

Using this approach:
1) create an Activity with LinearLayout or ScrollView (no child views yet).
2) For each fragment you wish to attach, create a new FrameLayout (or whatever)
3) Set the ViewID for the FrameLayout (or whatever) to either a new generated view id or the previous id if the fragment was previously attached.
4) Add the FrameLayout (or whatever) to the LinearLayout/ScrollView.
5) Use the FragmentManager to attach the fragment to the view that you just added.

Hope this helps.