/usr/share/octave/packages/io-2.4.5/private/__UNO_getnmranges__.m is in octave-io 2.4.5-1.
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 | ## Copyright (C) 2016 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 3 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 this program. If not, see <http://www.gnu.org/licenses/>.
## -*- texinfo -*-
## @deftypefn {Function File} {@var{retval} =} __UNO_getnmranges__ (@var{input1}, @var{input2})
##
## @seealso{}
## @end deftypefn
## Author: Philip Nienhuis <prnienhuis@users.sf.net>
## Created: 2015-09-20
function [nmr] = __UNO_getnmranges__ (xls)
nmr = cell (0, 3);
## Entire workbook
unotmp = javaObject ("com.sun.star.uno.Type", "com.sun.star.beans.XPropertySet");
docProps = xls.workbook.queryInterface (unotmp);
urng = docProps.getPropertyValue ("NamedRanges");
rnms = urng.getObject.getElementNames ();
## FIXME get ranges
for ii = 1:numel (rnms)
rng = urng.getObject.getByName (rnms(ii));
nm = strrep (rng.getObject ().getContent (), "$", ""); ## -> $3rdSheet.$D$2:$I$4
nmr{end+1, 1} = rnms(ii);
nmr{end, 2} = nm(1:index(nm, ".")-1);
nmr{end, 3} = nm(index(nm, ".")+1:end);
endfor
## Per sheet. First some preparations
sheets = xls.workbook.getSheets ();
sh_names = sheets.getElementNames ();
if (! iscell (sh_names))
## Java array (LibreOffice 3.4.+), convert to cellstr
sh_names = char (sh_names);
else
sh_names = {sh_names};
endif
## For each sheet get named ranges
for jj = 1:numel (sh_names)
unotmp = javaObject ("com.sun.star.uno.Type", "com.sun.star.sheet.XSpreadsheet");
sh = sheets.getByName(sh_names{jj}).getObject.queryInterface (unotmp);
unotmp = javaObject ("com.sun.star.uno.Type", "com.sun.star.beans.XPropertySet");
shProps = sh.queryInterface (unotmp);
urng = shProps.getPropertyValue ("NamedRanges");
rnms = urng.getObject.getElementNames ();
for ii=1:numel (rnms)
rng = urng.getObject.getByName (rnms(ii));
nm = strrep (rng.getObject ().getContent (), "$", ""); ## -> $3rdSheet.$D$2:$I$4
nmr{end+1, 1} = rnms(ii);
nmr{end, 2} = nm(1:index(nm, ".")-1);
nmr{end, 3} = nm(index(nm, ".")+1:end);
endfor
endfor
endfunction
|