Jump to content

Recommended Posts

Hi,

I successfuly "Pasted special..." Excel table into Publisher. The table retained its text formating, color and other attributes. Text is also fully editable. BUT... it would br really great if "Paste Special" can convert it into Publisher table where we can continue to work on it.


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites

What happens if you paste the Excel table data into a Publisher table ?

Most formatting, colours etc are retained for me, what extra formatting do you get doing a paste special?


Due to the ongoing Brexit negotiations, punctuation, spelling and grammar will be used sparingly until further notice.

Share this post


Link to post
Share on other sites

1.png


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites

I also forgot to ask for linking Excel tables when they are pasted into Publisher, so that every change in the Excel table would reflect to the linked one into Publisher.


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites
6 minutes ago, Petar Petrenko said:

1.png

Can you upload the Excel file you copied that from?


Due to the ongoing Brexit negotiations, punctuation, spelling and grammar will be used sparingly until further notice.

Share this post


Link to post
Share on other sites

Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites

This is what I get when I paste your Excel data into an APub Table

Note the first line (header row) does not initially show up as it is white text on a white background.  Pasting Excel data does not paste the Cell Fill Colour of the original Excel file.  (Hopefully Serif are working on this for a future release).  In the above table I had to manually change the top 4 cells' fill colour to black.

 Other than that it appears to do a pretty good job with only a few minor adjustments needed to match the original  (e.g. Centring the text in rows B-E)

 

excel.jpg


Due to the ongoing Brexit negotiations, punctuation, spelling and grammar will be used sparingly until further notice.

Share this post


Link to post
Share on other sites

Why is this difference???


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites
5 minutes ago, carl123 said:

This is what I get when I paste your Excel data into an APub Table

Note the first line (header row) does not initially show up as it is white text on a white background.  Pasting Excel data does not paste the Cell Fill Colour of the original Excel file.  (Hopefully Serif are working on this for a future release).  In the above table I had to manually change the top 4 cells' fill colour to black.

 Other than that it appears to do a pretty good job with only a few minor adjustments needed to match the original  (e.g. Centring the text in rows B-E)

 

excel.jpg

What do you get with the second option?


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites

Attached is the second one, with the black fill added to the top row and columns B+D just needing to be Right Aligned.

 

 

excel2.jpg


Due to the ongoing Brexit negotiations, punctuation, spelling and grammar will be used sparingly until further notice.

Share this post


Link to post
Share on other sites

No, you didn't understand me. I meant the second option "Paste Special > Windows Enhanced Metafile" with the first table.


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites
13 minutes ago, Petar Petrenko said:

No, you didn't understand me. I meant the second option "Paste Special > Windows Enhanced Metafile" with the first table.

I get the same results that you posted but it's not a table, so all the current benefits of tables are lost.

Like selecting an entire column/row and changing the fill colour/font etc


Due to the ongoing Brexit negotiations, punctuation, spelling and grammar will be used sparingly until further notice.

Share this post


Link to post
Share on other sites
50 minutes ago, carl123 said:

I get the same results that you posted but it's not a table, so all the current benefits of tables are lost.

Like selecting an entire column/row and changing the fill colour/font etc

Yes, I know it is not a table as you can see from my request above. :)


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites
7 minutes ago, Petar Petrenko said:

Yes, I know it is not a table as you can see from my request above. :)

But why not simply make a table first, as Carl suggested, and paste into it?


-- Walt

Windows 10 Home, version 1903 (18362.145), 16GB memory, Intel Core i7-6700K @ 4.00Gz, GeForce GTX 970
Affinity Photo 1.7.0.367 and 1.7.1.390 Beta   / Affinity Designer 1.7.0.367 and 1.7.1.390 Beta  / Affinity Publisher 1.7.0.384 Beta

Share this post


Link to post
Share on other sites
14 minutes ago, walt.farrell said:

But why not simply make a table first, as Carl suggested, and paste into it?

What to do with the existing Excel tables? retyping them? :)

And it is much easier and faster to make a table in Excel. And you can do calculations in Excel, as you know. With additional linking of the Excel tables it will be really great to combine these two softwares.


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites
43 minutes ago, Petar Petrenko said:

What to do with the existing Excel tables? retyping them? :)

You can make a table in Publisher, then copy your Excel table and paste it into the Publisher table. No need to retype anything.

You may need to ensure that you have at least two cells of the Publisher table selected before you do the paste 


-- Walt

Windows 10 Home, version 1903 (18362.145), 16GB memory, Intel Core i7-6700K @ 4.00Gz, GeForce GTX 970
Affinity Photo 1.7.0.367 and 1.7.1.390 Beta   / Affinity Designer 1.7.0.367 and 1.7.1.390 Beta  / Affinity Publisher 1.7.0.384 Beta

Share this post


Link to post
Share on other sites
1 minute ago, walt.farrell said:

You can make a table in Publisher, then copy your Excel table and paste it into the Publisher table. No need to retype anything.

You may need to ensure that you have at least two cells of the Publisher table selected before you do the paste 

Will Publisher's table cells adopt to the excel table (width, height, color...)?


Best regards,

Petar Petrenko
Typesetter, Graphic Designer, Photographer
Skopje, Makedonija

Windows 10 x64 Pro
Dell Inspiron 7559 i7
Intel Core i7-6700HQ (3.50 GHz, 6M )
16GB Dual Channel DDR3L 1600MHz (8GBx2)
1TB HDD + 128 GB SSD Hard drive
UHD (3840 x 2160) Truelife LED- Backlit Touch Display
NVIDIA GeForce GTX 960M 4GB GDDR5

Share this post


Link to post
Share on other sites
Just now, Petar Petrenko said:

Will Publisher's table cells adopt to the excel table (width, height, color...)?

Why not try it and see?


-- Walt

Windows 10 Home, version 1903 (18362.145), 16GB memory, Intel Core i7-6700K @ 4.00Gz, GeForce GTX 970
Affinity Photo 1.7.0.367 and 1.7.1.390 Beta   / Affinity Designer 1.7.0.367 and 1.7.1.390 Beta  / Affinity Publisher 1.7.0.384 Beta

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×