Table Formatting

[Redhill_qik]

The table formatting options need to be improved as it is really difficult to create a table that looks good. Specifically, there is no way to be able to select multiple cells and change the formatting such as to right align the contents. In order to do this, I need to select every cell individually and make the change. I thought that I had copy-and-pasted one table and it was formatted like the original excel table, but I haven't been able to replicate it again.

 

[Redhill_qik]

No replies, but I here are some experiments with different types and alignments with a copy-and-paste from excel

Alpha Std	Alpha Left	Alpha Center	Alpha Right
abc	abc	abc	abc
def	def	def	def
ghi	ghi	ghi	ghi
jkl	jkl	jkl	jkl

Num Std	Num Left	Num Center	Num Right
123.45​	123.45	123.45	123.45
67.89​	67.89	67.89	67.89
123.45​	123.45	123.45	123.45
67.89​	67.89	67.89	67.89

Money std	Money Left	Money Center	Money Right
$123.45​	123.45	$123.45	$123.45​
$67.89​	67.89	$67.89	$67.89​
$123.45​	123.45	$123.45	$123.45​
$67.89​	67.89	$67.89	$67.89​

Date Std	Date Left	Date Center	Date Right
1/1/2022​	1/1/2022	1/1/2022	1/1/2022
2/2/2022​	2/2/2022	2/2/2022	2/2/2022
3/3/2022​	3/3/2022	3/3/2022	3/3/2022
4/4/2022​	4/4/2022	4/4/2022	4/4/2022

 

[Redhill_qik]

While the above worked briefly, it no longer does as shown below. The attached zip has an excel file with this same data.

Text Default	Text Left	Text Center	Text Right
abc	abc	abc	abc
def	def	def	def
ghi	ghi	ghi	ghi
jkl	jkl	jkl	jkl
Num Default	Num Left	Num Center	Num Right
123.45	123.45	123.45	123.45
67.89	67.89	67.89	67.89
123.45	123.45	123.45	123.45
67.89	67.89	67.89	67.89
Money Default	Money Left	Money Center	Money Right
$123.45	$123.45	$123.45	$123.45
$67.89	$67.89	$67.89	$67.89
$123.45	$123.45	$123.45	$123.45
$67.89	$67.89	$67.89	$67.89
Date Default	Date Left	Date Center	Date Right
1/1/2022	1/1/2022	1/1/2022	1/1/2022
2/2/2022	2/2/2022	2/2/2022	2/2/2022
3/3/2022	3/3/2022	3/3/2022	3/3/2022
4/4/2022	4/4/2022	4/4/2022	4/4/2022

and from Google Sheets

Text Default	Text Left	Text Center	Text Right
abc	abc	abc	abc
def	def	def	def
ghi	ghi	ghi	ghi
jkl	jkl	jkl	jkl
Num Default	Num Left	Num Center	Num Right
123.45	123.45	123.45	123.45
67.89	67.89	67.89	67.89
123.45	123.45	123.45	123.45
67.89	67.89	67.89	67.89
Money Default	Money Left	Money Center	Money Right
$123.45	$123.45	$123.45	$123.45
$67.89	$67.89	$67.89	$67.89
$123.45	$123.45	$123.45	$123.45
$67.89	$67.89	$67.89	$67.89
Date Default	Date Left	Date Center	Date Right
1/1/2022	1/1/2022	1/1/2022	1/1/2022
2/2/2022	2/2/2022	2/2/2022	2/2/2022
3/3/2022	3/3/2022	3/3/2022	3/3/2022
4/4/2022	4/4/2022	4/4/2022	4/4/2022

 

[Redhill_qik]

If copy-and-paste can't be made to work, then it should be possible to select multiple cells (either within a row, within a column or within a row/column block and apply the same format options (font, colors, and alignment) to the selection as a group instead of cell by cell.

 

[doug]

Sorry, there isn't currently a great solution for this. The BBcode for tables is a bit limited.
A while back I had a solution for embedding Google sheets, but I honestly haven't checked is that still works after various changes from Google's end.