Stack Overflow
Stack Overflow

Questions tagged [ods]

ODS, OpenDocument Spreadsheet, is an extension of spreadsheet files in Open Document Format for Office Applications (ODF).

195 questions
0
votes
1 answer

SAS: prevent proc report from applying comma format to display header title

I'm generating tables with rolling weeks of data, so my columns have to be named in the yyyymmdd format like 20161107. I need to apply a comma format to these columns to display counts, but the format is also being applied to the column name so…
kstats9pt3
  • 799
  • 2
  • 8
  • 28
0
votes
1 answer

Read .ods file and open the link in the browser

I have a .ods file in which it has 150 links.I need to check whether all the links are working or not.How can I achieve this using code.I dont want to do it manually.
user7144720
  • 101
  • 1
  • 2
  • 8
0
votes
1 answer

Open very old firebird file

I have what seems to be very old firebird files available and was asked to get data out of them. I have run various versions of firebird 32/64bits 2.5/3.0/embeded on Windows 10x64. Each time, using ISQL/FlameRobin/DBeaver, I get the error Not a…
jhfelectric
  • 572
  • 2
  • 6
  • 24
0
votes
1 answer

formula for difference between start & end time includes milliseconds in Excel

I want to find the time difference between start & end time using Excel my Data : A1 = 16:00:03:38 B2 = 16:14:13:58 which is in pattern of "h:mm:ss:ms" h=hours,mm=minutes,ss=seconds,ms=milliseconds. am using like this =B2-A1 but it not …
Srikanth Togara
  • 49
  • 2
  • 11
0
votes
1 answer

ODS Type 3 Proc Surveyselect

I am trying to write ods output while using the following macro: %let class1=X1 X2 %let &new_var=X3 X4 options mprint mlogic symbolgen; %macro LogitBoot(data = , dv = , iv = ,class=, n = ); proc sql noprint; create table logit_result (iv…
user6016731
  • 382
  • 5
  • 18
0
votes
0 answers

Get cell style with phpExcel from ods file

I'm using the PHPExcel lib to read spread sheets. With xlsx and xls files it works fine, but not with ods and ots. I'm trying to get the background color of the cell but with ods files I always get FFFFF instead of the actual cell color. Here is the…
Luis San Martín Saavedra
  • 1
  • 1
0
votes
1 answer

Importing ODS to phpmyadmin error 1117: too many columns

so I am currently testing one web application, and for that I need to import an excel file to phpmyadmin. I need to import the file as an *.ods. To do that, I know I need to rename the file so that it matches the table name, and set values in first…
O.Čorič
  • 61
  • 1
  • 7
0
votes
1 answer

ods parser in node.js not working

I am looking for ODS parser in node.js. Currently I am using excel-parser for parsing xls and xlsx but it cant parse ODS files. I looked for other npm modules but no one is supporting ODS files. I tried this one but its giving me error "unsupported…
Bhuvnesh Gupta
  • 35
  • 9
0
votes
1 answer

How to read an ods document (e.g. LibreOffice calc) and convert it in a Julia dataframe?

How to import data from a ODS spreadsheet (used by OpenOffice, LibreOffice,...) in a Julia DataFrame ? (this is a community wiki Q&A)
Antonello
  • 6,092
  • 3
  • 31
  • 56
0
votes
1 answer

How to create opendocument ods files with optimal row height

Application creates OpenDocument spreadsheets (ods file) in code. Some rows contains caption with bigger font sized. They are only partially visible if opened in LibreOffice. All rows have same style ro1 which has…
Andrus
  • 26,339
  • 60
  • 204
  • 378
0
votes
0 answers

in sas9.1 ,when i use "ods rtf" procedure with "proc report" procedure

In sas 9.1 , I use "ods rtf" procedure with "proc report" procedure. When I use title statement, the title is always retractive. What I should do to solve the problem. options nodate nonumber missing=" "; ods escapechar="#"; ods rtf …
bluehaiku
  • 11
  • 1
  • 4
0
votes
1 answer

[C++]: Writing a numerical data to an ODS file, ODS does not treat them as numbers

When I export my calculations via ofstream in C++ to an ODS (Apache OpenOffice) file, the numbers are correctly shown there, however I cannot make any calculations in that specific ODS file. For example, when I try to add, say 0.9191 on A1, and…
Bora Atalay
  • 5
  • 5
0
votes
1 answer

SAS: Plotting overlayed graphs without time series

I think the plotting engine in SAS is not really straight forward. I hope someone can help me on that: I want to plot the volumes of 4 different stocks´ orderbooks. But it just draws weird dots. I have the following sample dataset: Stock AskVolume1…
MaBo88
  • 97
  • 1
  • 1
  • 9
0
votes
1 answer

ods output in proc logistic

I am running a proc logistic with selection =score , to get the best model based on chi-square value. Here is the code options symbolgen; %let input_var=ABC_DEF_CkkkkkedHojjjjjerRen101 dept_gert home_value child_household ; ods output…
Pruthvi
  • 31
  • 1
0
votes
1 answer

Performing conditional change in .ods file in bash

How can I do a conditional change in an .ods document? I have two columns. One of them stores a string and the second a value. I want to search the document with a particular string that I have, say "xyz". If this matches any of the strings that are…
Sid
  • 266
  • 5
  • 13
1 2 3
…
12 13