smileturbans.com

Linux server.a-j.media 5.14.0-570.44.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Sep 17 10:32:11 EDT 2025 x86_64
Apache
75.119.137.219
Cant read /etc/named.conf

File Name : CellReferenceHelper.php

<?php

namespace PhpOffice\PhpSpreadsheet;

use PhpOffice\PhpSpreadsheet\Cell\AddressRange;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;

class CellReferenceHelper
{
    /**
     * @var string
     */
    protected $beforeCellAddress;

/**
     * @var int
     */
    protected $beforeColumn;

/**
     * @var int
     */
    protected $beforeRow;

/**
     * @var int
     */
    protected $numberOfColumns;

/**
     * @var int
     */
    protected $numberOfRows;

public function __construct(string $beforeCellAddress = 'A1', int $numberOfColumns = 0, int $numberOfRows = 0)
    {
        $this->beforeCellAddress = str_replace('$', '', $beforeCellAddress);
        $this->numberOfColumns = $numberOfColumns;
        $this->numberOfRows = $numberOfRows;

// Get coordinate of $beforeCellAddress
        [$beforeColumn, $beforeRow] = Coordinate::coordinateFromString($beforeCellAddress);
        $this->beforeColumn = (int) Coordinate::columnIndexFromString($beforeColumn);
        $this->beforeRow = (int) $beforeRow;
    }

public function beforeCellAddress(): string
    {
        return $this->beforeCellAddress;
    }

public function refreshRequired(string $beforeCellAddress, int $numberOfColumns, int $numberOfRows): bool
    {
        return $this->beforeCellAddress !== $beforeCellAddress ||
            $this->numberOfColumns !== $numberOfColumns ||
            $this->numberOfRows !== $numberOfRows;
    }

public function updateCellReference(string $cellReference = 'A1', bool $includeAbsoluteReferences = false): string
    {
        if (Coordinate::coordinateIsRange($cellReference)) {
            throw new Exception('Only single cell references may be passed to this method.');
        }

// Get coordinate of $cellReference
        [$newColumn, $newRow] = Coordinate::coordinateFromString($cellReference);
        $newColumnIndex = (int) Coordinate::columnIndexFromString(str_replace('$', '', $newColumn));
        $newRowIndex = (int) str_replace('$', '', $newRow);

$absoluteColumn = $newColumn[0] === '$' ? '$' : '';
        $absoluteRow = $newRow[0] === '$' ? '$' : '';
        // Verify which parts should be updated
        if ($includeAbsoluteReferences === false) {
            $updateColumn = (($absoluteColumn !== '$') && $newColumnIndex >= $this->beforeColumn);
            $updateRow = (($absoluteRow !== '$') && $newRowIndex >= $this->beforeRow);
        } else {
            $updateColumn = ($newColumnIndex >= $this->beforeColumn);
            $updateRow = ($newRowIndex >= $this->beforeRow);
        }

// Create new column reference
        if ($updateColumn) {
            $newColumn = $this->updateColumnReference($newColumnIndex, $absoluteColumn);
        }

// Create new row reference
        if ($updateRow) {
            $newRow = $this->updateRowReference($newRowIndex, $absoluteRow);
        }

// Return new reference
        return "{$newColumn}{$newRow}";
    }

public function cellAddressInDeleteRange(string $cellAddress): bool
    {
        [$cellColumn, $cellRow] = Coordinate::coordinateFromString($cellAddress);
        $cellColumnIndex = Coordinate::columnIndexFromString($cellColumn);
        //    Is cell within the range of rows/columns if we're deleting
        if (
            $this->numberOfRows < 0 &&
            ($cellRow >= ($this->beforeRow + $this->numberOfRows)) &&
            ($cellRow < $this->beforeRow)
        ) {
            return true;
        } elseif (
            $this->numberOfColumns < 0 &&
            ($cellColumnIndex >= ($this->beforeColumn + $this->numberOfColumns)) &&
            ($cellColumnIndex < $this->beforeColumn)
        ) {
            return true;
        }

return false;
    }

protected function updateColumnReference(int $newColumnIndex, string $absoluteColumn): string
    {
        $newColumn = Coordinate::stringFromColumnIndex(min($newColumnIndex + $this->numberOfColumns, AddressRange::MAX_COLUMN_INT));

return "{$absoluteColumn}{$newColumn}";
    }

protected function updateRowReference(int $newRowIndex, string $absoluteRow): string
    {
        $newRow = $newRowIndex + $this->numberOfRows;
        $newRow = ($newRow > AddressRange::MAX_ROW) ? AddressRange::MAX_ROW : $newRow;

return "{$absoluteRow}{$newRow}";
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
..	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-07-09 04:37:04
Calculation	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Cell	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Chart	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Collection	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Document	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Helper	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Reader	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
RichText	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Shared	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Style	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Worksheet	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
Writer	dir	-	ladyturbans/ladyturbans	drwxr-xr-x	2025-09-17 09:38:24
CellReferenceHelper.php	text/x-php	4.26 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
Comment.php	text/x-php	7.35 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
DefinedName.php	text/x-php	6.41 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
Exception.php	text/x-php	83 B	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
HashTable.php	text/x-php	3.76 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
IComparable.php	text/x-php	182 B	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
IOFactory.php	text/x-php	8.81 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
NamedFormula.php	text/x-php	973 B	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
NamedRange.php	text/x-php	1.22 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
ReferenceHelper.php	text/x-php	54.04 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
Settings.php	text/x-php	6.05 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
Spreadsheet.php	text/x-php	45.3 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00
Theme.php	text/x-php	7 KB	ladyturbans/ladyturbans	-rw-r--r--	2024-12-08 06:49:00