Suggestion - support right-to-left sheets

[doronsolomon]

Hi,
Thanks for your great library.
I would love to see support in sheets to be right to left for languages that are right to left.
Thanlks

[vol4ikman]

Hello. Do you planning to support RTL sheets?

Thanks

[shuchkin]

Hello. Do you planning to support RTL sheets?

Thanks

RTL mode added in 1.3.13

$data = [
    [ 1, 2, 3],
    [ 4, 5, 6]
];
SimpleXLSXGen::fromArray($data)
    ->rightToLeft()
    ->saveAs('test_rtl.xlsx');

[xaviermdq]

Hi Sergey:
I think there is a logic problem in _sheetToXML method. Initializing $SHEETVIEWS and $AC before the IF block its Ok, if we terminate the $SHEETVIEWS string after the IF block. I think it should be:

        # code
        $SHEETVIEWS = '<sheetViews><sheetView tabSelected="1" workbookViewId="0"' . ($this->rtl ? ' rightToLeft="1"' : '') . '>';
        $AC = 'A1'; // Active Cell
        if (count($this->sheets[$idx]['rows'])) {
            # code
        } else {
            $ROWS[] = '<row r="1"><c r="A1" t="s"><v>0</v></c></row>';
            $REF = 'A1:A1';
        }
        $SHEETVIEWS .= '<selection activeCell="' . $AC . '" sqref="' . $AC . '"/>';
        $SHEETVIEWS .= '</sheetView></sheetViews>';
        # code

What do you think?