/usr/share/octave/packages/io-2.4.5/private/__JOD_oct2spsh__.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 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 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 | ## Copyright (C) 2009-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/>.
## __JOD_oct2spsh__ - write data from octave to an ODS spreadsheet using the
## jOpenDocument interface.
##
## Author: Philip Nienhuis <pr.nienhuis at users.sf.net>
## Created: 2009-12-13
function [ ods, rstatus ] = __JOD_oct2spsh__ (c_arr, ods, wsh, crange)
rstatus = 0;
sh = [];
changed = 0;
## Get worksheet. Use first one if none given
if (isempty (wsh))
wsh = 1;
endif
sh_cnt = ods.workbook.getSheetCount ();
if (isnumeric (wsh))
if (wsh > 1024)
error ("Sheet number out of range of ODS specification (>1024)");
elseif (wsh > sh_cnt)
error ("Sheet number (%d) larger than number of sheets in file (%d)\n",...
wsh, sh_cnt);
else
wsh = wsh - 1;
sh = ods.workbook.getSheet (wsh);
if (isempty (sh))
## Sheet number wsh didn't exist yet
wsh = sprintf ("Sheet%d", wsh+1);
elseif (ods.changed > 2)
sh.setName ("Sheet1");
changed = 1;
endif
endif
endif
## wsh is now either a 0-based sheet no. or a string. In latter case:
if (isempty (sh) && ischar (wsh))
sh = ods.workbook.getSheet (wsh);
if (isempty (sh))
## Still doesn't exist. Create sheet
if (ods.odfvsn >= 3)
if (ods.changed > 2)
## 1st "new" -unnamed- sheet has already been made when creating the spreadsheet
sh = ods.workbook.getSheet (0);
sh.setName (wsh);
changed = 1;
else
## For existing spreadsheets
## printf ("Adding sheet '%s'\n", wsh);
sh = ods.workbook.addSheet (sh_cnt, wsh);
changed = 1;
endif
## jOpenDocument bug: JOD seems to add "A" to A1 and "B" to B1
try
if (! isempty (sh.getCellAt (0, 0).getValue))
sh.getCellAt (0, 0).clearValue();
sh.getCellAt (1, 0).clearValue();
endif
catch
end_try_catch
else
error (["jOpenDocument v. 1.2b2 does not support adding sheets" ...
" - upgrade to v. 1.3\n"]);
endif
endif
endif
[nr, nc] = size (c_arr);
if (isempty (crange))
trow = 0;
lcol = 0;
nrows = nr;
ncols = nc;
elseif (isempty (strfind (deblank (crange), ":")))
[~, ~, ~, trow, lcol] = parse_sp_range (crange);
nrows = nr;
ncols = nc;
## Row/col = 0 based in jOpenDocument
trow = trow - 1;
lcol = lcol - 1;
else
[~, nrows, ncols, trow, lcol] = parse_sp_range (crange);
## Row/col = 0 based in jOpenDocument
trow = trow - 1;
lcol = lcol - 1;
endif
if (trow > 65535 || lcol > 1023)
error ("Topleft cell beyond spreadsheet limits (AMJ65536).");
endif
## Check spreadsheet capacity beyond requested topleft cell
nrows = min (nrows, 65536 - trow); ## Remember, lcol & trow are zero-based
ncols = min (ncols, 1024 - lcol);
## Check array size and requested range
nrows = min (nrows, nr);
ncols = min (ncols, nc);
if (nrows < nr || ncols < nc)
warning ("Array truncated to fit in range\n");
endif
if (isnumeric (c_arr))
c_arr = num2cell (c_arr);
endif
## Ensure sheet capacity is large enough to contain new data
try ## try-catch needed to work around bug in jOpenDocument v 1.2b3 and earlier
sh.ensureColumnCount (lcol + ncols); ## Remember, lcol & trow are zero-based
catch ## catch is needed for new empty sheets (first ensureColCnt() hits null ptr)
sh.ensureColumnCount (lcol + ncols);
## Kludge needed because upper row is defective (NPE jOpenDocument bug). ?Fixed in 1.2b4?
if (trow == 0)
## Shift rows one down to avoid defective upper row
++trow;
printf ("Info: empy upper row above data added to avoid JOD bug.\n");
endif
end_try_catch
sh.ensureRowCount (trow + nrows);
## Write data to worksheet
for ii = 1 : nrows
for jj = 1 : ncols
val = c_arr {ii, jj};
if ((isnumeric (val) && ! isnan (val)) || ischar (val) || islogical (val))
## jOpenDocument < 1.3 doesn't really support writing booleans (doesn't set OffValAttr)
if ((ods.odfvsn <= 3) && islogical (val))
val = double (val);
endif
try
sh.getCellAt (jj + lcol - 1, ii + trow - 1).clearValue();
jcell = sh.getCellAt (jj + lcol - 1, ii + trow - 1).setValue (val);
changed = 1;
catch
## No panic, probably a merged cell
## printf (sprintf ("Cell skipped at (%d, %d)\n", ii+lcol-1, jj+trow-1));
end_try_catch
endif
endfor
endfor
if (changed)
ods.changed = max (min (ods.changed, 2), changed); # Preserve 2 (new file), 1 (existing)
rstatus = 1;
endif
endfunction
|