doctorofcredit

Hi Tobias,

That’s not what’s happening because none of the rows are being sorted properly by the invisible rows. It looks like it thinks that 2 < 1,000 is this possible?

I want people to be able to sort via the credit card funding section but when they do it doesn’t work properly even with hidden rows.

Surely I’m not the only one having this problem? No solutions?

Just use the macro, there is no way for Tobias to implement the feature. Although you should donate anyway!

I also did the hidden column and got it working beautiful. For those following along the old code I shared above will not work when linking to a specific part of a page using the # function.

The below code will work fine:

Sub ConvertLinkToHTML()
Dim r As Range

For Each r In Selection
    If r.Hyperlinks.Count = 1 Then
        r.Value = "<a href=""" & r.Hyperlinks(1).Address & "#" & r.Hyperlinks(1).SubAddress & """>" & r.Hyperlinks(1).TextToDisplay & "</a>"
        r.Hyperlinks(1).Delete
    End If
Next r
End Sub

Thanks again for the help, Tobias. I’ve just rated it in directory and sending you a small donation as soon as some funds clear.

Hi Tobias,

This might help some of your plugin users. Here is what I did to turn all my excel links into HTML links:

Alt-F11 to open VBA
Right click the project on the project tree and Insert-> module if needed
Input the following code

Sub ConvertLinkToHTML()
Dim r As Range

For Each r In Selection
    If r.Hyperlinks.Count = 1 Then
        r.Value = "<a href=""" & r.Hyperlinks(1).Address & """>" & r.Hyperlinks(1).TextToDisplay & "</a>"
        r.Hyperlinks(1).Delete
    End If
Next r
End Sub

F5 with your cursor in the procedure to run it. *While the area you want to convert is highlighted on the Excel side

This worked a treat for me. Hope it helps others, now I just need to do the invisible rows and a bit of tidying up and I’m set.

I’ll need to create the invisible row for a lot of the columns though, it’s not a massive issue just a minor inconvenience. I’ll play around with getting the html in there, that will be the biggest time sink.

Donation and review coming your way once I get it looking beautiful! Thanks again for the help.

1. Ah, that’s disappointing. Any plans on adding that functionality? I’d be happy to make a decent sized donation to see it happen.

2. The pre tag must be automatically be inserted for some reason then as I definitely removed it. I guess I’ll create those invisible columns then, a lot more work than I was hoping for!

1. At the moment a lot of the fields are linked text, can this automatically converted that or is it not possible? (e.g under our post “review” this should be linked to a post on our site) My shortcode includes the extra code needed: “[table id=1 automatic_url_conversion=true /]”

2. I changed the bonus amount field to be “currency” instead of text, but that doesn’t seem to fix the issue. I’d like to avoid hidden column if at all possible. I also removed the
<pre> stuff.

I also deactivated the sticky social bar for not to avoid any issues.