/usr/share/octave/packages/3.2/io-1.0.14/spsh_chkrange.m is in octave-io 1.0.14-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 | ## Copyright (C) 2010 Philip Nienhuis
##
## This program is free software; you can redistribute it and/or modify
## it under the terms of the GNU General Public License as published by
## the Free Software Foundation; either version 2 of the License, or
## (at your option) any later version.
##
## This program is distributed in the hope that it will be useful,
## but WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
## GNU General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with Octave; see the file COPYING. If not, see
## <http://www.gnu.org/licenses/>.
## -*- texinfo -*-
## @deftypefn {Function File} [ @var{topleftaddr}, @var{nrows}, @var{ncols}, @var{toprow}, @var{leftcol} ] = spsh_chkrange ( @var{range}, @var{rowsize}, @var{colsize}, @var{intf-type}, @var{filename})
## (Internal function) Get and check various cell and range address parameters for spreadsheet input.
##
## spsh_chkrange should not be invoked directly but rather through oct2xls or oct2ods.
##
## Example:
##
## @example
## [tl, nrw, ncl, trw, lcl] = spsh_chkrange (crange, nr, nc, xtype, fileptr);
## @end example
##
## @end deftypefn
## Author: Philip Nienhuis, <prnienhuis@users.sf.net>
## Created: 2010-08-02
## Updates:
## 2010-08-25 Option for supplying file pointer rather than interface_type & filename
## (but this can be wasteful if the file ptr is copied)
function [ topleft, nrows, ncols, trow, lcol ] = spsh_chkrange (crange, nr, nc, intf, filename=[])
if (nargin == 4)
# File pointer input assumed
if (isstruct (xtype))
xtype = intf.xtype;
filename = intf.filename;
else
error ("Too few or improper arguments supplied.");
endif
else
# Interface type & filename supplied
xtype = intf;
endif
# Define max row & column capacity from interface type & file suffix
switch xtype
case {'COM', 'POI'}
if (strmatch (tolower (filename(end-3:end)), '.xls'))
# BIFF5 & BIFF8
ROW_CAP = 65536; COL_CAP = 256;
else
# OOXML (COM needs Excel 2007+ for this)
ROW_CAP = 1048576; COL_CAP = 16384;
endif
case 'JXL'
# JExcelAPI can only process BIFF5 & BIFF8
ROW_CAP = 65536; COL_CAP = 256;
case {'OTK', 'JOD'}
# ODS
ROW_CAP = 65536; COL_CAP = 1024;
otherwise
error (sprintf ("Unknown interface type - %s\n", spptr.xtype));
endswitch
if (isempty (deblank (crange)))
trow = 1;
lcol = 1;
nrows = nr;
ncols = nc;
topleft= 'A1';
elseif (isempty (strfind (deblank (crange), ':')))
# Only top left cell specified
[topleft, dummy1, dummy2, trow, lcol] = parse_sp_range (crange);
nrows = nr;
ncols = nc;
else
[topleft, nrows, ncols, trow, lcol] = parse_sp_range (crange);
endif
if (trow > ROW_CAP || lcol > COL_CAP)
error ("Topleft cell (%s) beyond spreadsheet limits.");
endif
# Check spreadsheet capacity beyond requested topleft cell
nrows = min (nrows, ROW_CAP - trow + 1);
ncols = min (ncols, COL_CAP - lcol + 1);
# Check array size and requested range
nrows = min (nrows, nr);
ncols = min (ncols, nc);
endfunction
|