Document

Operation	:	Linux server.tradinguniversity.rs 3.10.0-1160.119.1.vz7.224.4 #1 SMP Mon Sep 30 15:36:27 MSK 2024 x86_64
Software	:	Apache
Server IP	:	68.66.251.59 \| Your IP: 216.73.216.158
Domains	:	4 Domain
Permission	:	[ drwxr-xr-x ]

/ home / tradinguniversit / public_html / vendor / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Writer / Ods /

Web File Manager

主页上传上传 V2 命令行

AutoFilters.php

<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Ods;

use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class AutoFilters
{
    /**
     * @var XMLWriter
     */
    private $objWriter;

/**
     * @var Spreadsheet
     */
    private $spreadsheet;

public function __construct(XMLWriter $objWriter, Spreadsheet $spreadsheet)
    {
        $this->objWriter = $objWriter;
        $this->spreadsheet = $spreadsheet;
    }

/** @var mixed */
    private static $scrutinizerFalse = false;

public function write(): void
    {
        $wrapperWritten = self::$scrutinizerFalse;
        $sheetCount = $this->spreadsheet->getSheetCount();
        for ($i = 0; $i < $sheetCount; ++$i) {
            $worksheet = $this->spreadsheet->getSheet($i);
            $autofilter = $worksheet->getAutoFilter();
            if ($autofilter !== null && !empty($autofilter->getRange())) {
                if ($wrapperWritten === false) {
                    $this->objWriter->startElement('table:database-ranges');
                    $wrapperWritten = true;
                }
                $this->objWriter->startElement('table:database-range');
                $this->objWriter->writeAttribute('table:orientation', 'column');
                $this->objWriter->writeAttribute('table:display-filter-buttons', 'true');
                $this->objWriter->writeAttribute(
                    'table:target-range-address',
                    $this->formatRange($worksheet, $autofilter)
                );
                $this->objWriter->endElement();
            }
        }

if ($wrapperWritten === true) {
            $this->objWriter->endElement();
        }
    }

protected function formatRange(Worksheet $worksheet, Autofilter $autofilter): string
    {
        $title = $worksheet->getTitle();
        $range = $autofilter->getRange();

return "'{$title}'.{$range}";
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	tradinguniversit/tradinguniversit	drwxr-xr-x	2025-02-08 02:56:14
..	dir	-	tradinguniversit/tradinguniversit	drwxr-xr-x	2025-02-08 02:56:14
Cell	dir	-	tradinguniversit/tradinguniversit	drwxr-xr-x	2025-02-08 02:56:14
AutoFilters.php	text/x-php	1.99 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Content.php	text/x-php	15.27 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Formula.php	text/x-php	3.87 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Meta.php	text/x-php	5.24 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
MetaInf.php	text/x-php	2.44 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Mimetype.php	text/x-php	306 B	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
NamedExpressions.php	text/x-php	4.58 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Settings.php	text/x-php	6.5 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Styles.php	text/x-php	3.6 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Thumbnails.php	text/x-php	271 B	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
WriterPart.php	text/x-php	561 B	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14