Hyperlinks pasted from .xlsx to Publisher Table issue and fonts not exporting correctly.

[pfrantzis]

2 issues one file... 😒

Pasted data to Publisher from an .xlsx file and the Hyperlinks don't work, even though the format is maintained. Hyperlinks on the .xlsx file are formula created and I suppose this is the fault.

is there a way to bypass it?

is there a way to import the Hyperlinks all at once?

Finally exported Pdf file has wrong font size.

Any feedback appreciated. Thanks in advance.

ISSF 2023 Calendar 5-1-2023.xlsx ISSF Calendar 2023.pdf

[MikeTO]

Hmm, it seems like Publisher wouldn't be able to deal with formulas like this.

There's probably an easier way to do it but if it were me I'd just write a quick macro to link the original values directly rather than using the hyperlink function. I don't have Excel installed at the moment or otherwise I'd do it for you.

[pfrantzis]

24 minutes ago, MikeTO said:

Hmm, it seems like Publisher wouldn't be able to deal with formulas like this.

There's probably an easier way to do it but if it were me I'd just write a quick macro to link the original values directly rather than using the hyperlink function. I don't have Excel installed at the moment or otherwise I'd do it for you.

I will try another solution with .xls

can't find a solution for the fonts though...

Thank you!

[laurent32]

I'm with Numbers on Mac and when I look into your xlsx I see too 2 sheets (2 tabs)…

One with the "links" that aren't links in column 3, on "sheet1 (2)"…

And another with "real links" that work in column 6, on "sheet1"…

Which column (sheet) did you use ?

[pfrantzis]

7 minutes ago, laurent32 said:

I'm with Numbers on Mac and when I look into your xlsx I see too 2 sheets (2 tabs)…

One with the "links" that aren't links in column 3, on "sheet1 (2)"…

And another with "real links" that work in column 6, on "sheet1"…

Which column (sheet) did you use ?

I am using Sheet1 (2)  Column C, they are the same sheets just rearranged columns. Data in this column is produced with Hyperlink Function (E column is the description and F column is the Link) and I guess this is the problem with Publisher.

[laurent32]

Why don't you just use column F without using "hyperlink function" ?

I'm far from being an expert on Excel…

[pfrantzis]

16 minutes ago, laurent32 said:

Why don't you just use column F without using "hyperlink function" ?

I'm far from being an expert on Excel…

Column F don't have the description I want...😒

[laurent32]

I opened your xslx file in numbers, corrected 2 cells that were links and not text (2 first cells of column E), and saved back in xslx format, keeping the construction of column C.

That way you can see how it goes with the construction of column C using :

in macOS numbers.

Does it work better via Numbers ?

ISSF 2023 Calendar 5-1-2023 v2.xlsx

[pfrantzis]

1 hour ago, laurent32 said:

I opened your xslx file in numbers, corrected 2 cells that were links and not text (2 first cells of column E), and saved back in xslx format, keeping the construction of column C.

That way you can see how it goes with the construction of column C using :

in macOS numbers.

Does it work better via Numbers ?

ISSF 2023 Calendar 5-1-2023 v2.xlsx 70.14 kB · 0 downloads

Unfortunately it does not work..thank you for your effort👍🏼

The cell were links because I had follow the same approach with you to paste them as links via Excel, which did not work.

I manually entered all hyperlinks in each cell on the Publisher table, wish there is a solution for this. I think it is a very useful option and Affinity should implement it.

 

[laurent32]

Maybe a last try, with my numbers file ?

I also think we need it to work…

Hope Affinity will get at it…

ISSF 2023 Calendar 5-1-2023 v2.numbers

[pfrantzis]

2 hours ago, laurent32 said:

Maybe a last try, with my numbers file ?

I also think we need it to work…

Hope Affinity will get at it…

ISSF 2023 Calendar 5-1-2023 v2.numbers 770.37 kB · 0 downloads

Of course I tried your Numbers file ....I answered it before..... "Unfortunately it does not work..thank you for your effort👍🏼"

Definitely a solution is needed. 

 

[MikeTO]

3 hours ago, pfrantzis said:

Definitely a solution is needed. 

It can't be solved in Publisher though - Publisher can't resolve spreadsheet formulas or if would need all the computational functionality of a spreadsheet. This is something you'll have to change in Excel.

[Old Bruce]

20 hours ago, pfrantzis said:

Column F don't have the description I want...😒

 

3 hours ago, pfrantzis said:

Definitely a solution is needed. 

I am pretty sure that what you will have to do involves a fair amount of work. You need to use the first three columns to generate a Publisher Document and then use Publisher to manually add the links with Publisher's Hyperlink Panel to the appropriate "description".

[pfrantzis]

1 hour ago, MikeTO said:

It can't be solved in Publisher though - Publisher can't resolve spreadsheet formulas or if would need all the computational functionality of a spreadsheet. This is something you'll have to change in Excel.

I agree with the first part, that would need the computational functionality of a spreadsheet and it was my initial thought. It is awkward though, that it does not accept to paste a functional hyperlink, and this in my opinion has to be solved.

 A cell has to be pasted with all its attributes when they exist in first place.

[MikeTO]

5 minutes ago, pfrantzis said:

I agree with the first part, that would need the computational functionality of a spreadsheet and it was my initial thought. It is awkward though, that it does not accept to paste a functional hyperlink, and this in my opinion has to be solved.

 A cell has to be pasted with all its attributes when they exist in first place.

The value of the cell to Publisher is simply =HYPERLINK(F2,E2). It is not a hyperlink, it's a formula that generates a hyperlink and Publisher can't resolve formulas.

This isn't a problem that can be solved inside of Publisher for you.

[pfrantzis]

1 hour ago, Old Bruce said:

 

I am pretty sure that what you will have to do involves a fair amount of work. You need to use the first three columns to generate a Publisher Document and then use Publisher to manually add the links with Publisher's Hyperlink Panel to the appropriate "description".

This was the only way I managed to do it....I entered manually every hyperlink in each one cell.

Funny though, I think another bug is hidden, in the process of copy-paste the hyperlinks in each cell, when I finished and checked the 42 cells one by one I found 8-9 cells not functioning, I opened the hyperlink path and most of them had a number (most of them the number 2 and a couple the number 3) at the end of the path after a space e.g. 

https://www.issf-sports.org/competitions/venue.ashx?cshipid=3158 2 

it was late but command C - V doesn't involve numbers 😔

 

[pfrantzis]

9 minutes ago, MikeTO said:

The value of the cell to Publisher is simply =HYPERLINK(F2,E2). It is not a hyperlink, it's a formula that generates a hyperlink and Publisher can't resolve formulas.

This isn't a problem that can be solved inside of Publisher for you.

Please read carefully what I wrote earlier ....

Even pasting a straightforward link like this one :

  it still does not work, it gets the text only. This is definitely Publisher's job.

[MikeTO]

Oh, I would have expected that to work.

I was going to suggest copying the spreadsheet into Word and then importing the Word file but I just tried importing a Word file with hyperlinks both in the body and in an inline table and none of the hyperlinks imported. I thought you could import hyperlinks in Word files.

 

[pfrantzis]

2 minutes ago, MikeTO said:

Oh, I would have expected that to work.

I was going to suggest copying the spreadsheet into Word and then importing the Word file but I just tried importing a Word file with hyperlinks both in the body and in an inline table and none of the hyperlinks imported. I thought you could import hyperlinks in Word files.

 

Thank you! 

Definitely needs a fix ....😉🙂

 

[laurent32]

9 hours ago, laurent32 said:

I opened your xslx file in numbers, corrected 2 cells that were links and not text (2 first cells of column E), and saved back in xslx format, keeping the construction of column C.

That way you can see how it goes with the construction of column C using :

in macOS numbers.

Does it work better via Numbers ?

ISSF 2023 Calendar 5-1-2023 v2.xlsx 70.14 kB · 1 download

Here I propose to import a numbers file converted to ".XSLX"

[laurent32]

8 hours ago, laurent32 said:

Maybe a last try, with my numbers file ?

I also think we need it to work…

Hope Affinity will get at it…

ISSF 2023 Calendar 5-1-2023 v2.numbers 770.37 kB · 0 downloads

Here I proposed to import directly a ".NUMBERS" file, it was different suggestion…

BUT can we import .pages or .numbers files as we import word or excel files ?

[laurent32]

If right at the beginning you save your XSLX file to PDF, then I guess the links work ?

And if you imported that PDF… ?????

[pfrantzis]

14 minutes ago, laurent32 said:

Here I proposed to import directly a ".NUMBERS" file, it was different suggestion…

BUT can we import .pages or .numbers files as we import word or excel files ?

I tried all options ... none worked

[walt.farrell]

46 minutes ago, pfrantzis said:

Please read carefully what I wrote earlier ....

Even pasting a straightforward link like this one :

  it still does not work, it gets the text only. This is definitely Publisher's job.

That sounds similar to how Opening a PDF works. The text is handled, but hyperlinks associated with the text aren't.

[laurent32]

2 minutes ago, walt.farrell said:

That sounds similar to how Opening a PDF works. The text is handled, but hyperlinks associated with the text aren't.

That sound to be the answer to my last question…

Guess we tried it all like @pfrantzis says…