referencing text format

Copper Contributor

Hello everyone,

 

In my excelsheet I am referencing tables using VSTACK to create one master table, while keeping it easy to edit the original tables.

 

The problem that I am facing is that VSTACK does not use the text formatting of the referenced cells.

 

MvPelt_0-1715610265174.png

 These are the source tables, and this is the master table:

MvPelt_1-1715610327626.png

I could manually make the headers the correct text format, but this format does not shift when a line is added or removed from a table, making the formatting shift incorrectly:

MvPelt_2-1715610496928.png

After manually adding formatting

MvPelt_3-1715610557322.png

adding a line (14 & 15) to the source table, and the text formatting stays on line 15 and 16 instead of shifting along with the text.

 

Is there a way to reference the text's formatting so that the manual part of creating a master table can be fully automated? VSTACK does not have a parmater to keep formatting.

2 Replies

@MvPelt 

Hi, you already said it yourself in your request. VSTACK() has no option to pass the formatting. None of the other functions can do this either.

The only possibility I can see now is that you add an additional column in your original tables that contains a code for formatting. You can leave this column hidden as long as you don't need to expand it. You can then use the code in your master table and add the formats using conditional formatting.

However, this is quite time-consuming. Depending on how many different formats you use.


Maybe someone will come up with a better idea.

 

@MvPelt 

A gimmick. Just to prove that it works with conditional formatting, I made an example.

I first learnt that Excel does not offer the font and font size as conditional formatting. Other programmes can do this. Fortunately, Excel has kept my changes from LibreOffice Calc for compatibility reasons.

Have fun continuing with the various formatting options.