"exceljs": "^3.9.0"
In order to create a spreadsheet with cells containing two different values, each aligned differently (one left and one right), I am looking for a solution similar to the image shown in this screenshot: https://i.sstatic.net/ySdiO.png
Currently, my output looks like this: https://i.sstatic.net/oQE0u.png
Below is the richText for the cells without the "/" character:
[
{
"font": {
"size": 8,
"name": "Arial"
},
"alignment": {
"vertical": "middle",
"horizontal": "distributed"
},
"text": "392.3 "
},
{
"font": {
"color": {
"argb": "00c90a00"
},
"size": 8,
"name": "Arial"
},
"alignment": {
"vertical": "middle",
"horizontal": "distributed"
},
"text": " -10%"
}
]
And here is the richText for the cell with the "/" character:
[
{
"font": {
"size": 8,
"name": "Arial"
},
"alignment": {
"vertical": "middle",
"horizontal": "distributed"
},
"text": "392.3 "
},
{
"font": {
"size": 8,
"name": "Arial"
},
"alignment": {
"vertical": "middle",
"horizontal": "distributed"
},
"text": " / "
},
{
"font": {
"color": {
"argb": "00c90a00"
},
"size": 8,
"name": "Arial"
},
"alignment": {
"vertical": "middle",
"horizontal": "distributed"
},
"text": " -10%"
}
]
I am wondering if it is possible to achieve the layout seen in the first screenshot.