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

JOpenDocument: problems with blank rows and cells

I have a problem when I parse .ods file with JOpenDocument . There are three rows and four columns in my file, but when I parse this file I get 1024 columns and too many rows. There are many blank cells. I opened this .ods file like xml and it…
Mexoff
  • 103
  • 3
0
votes
2 answers

Libreoffice export each row to csv

I want to know if it is possible to export each row from ODS file to .csv files. For example : column1 column2 row1 name info for the row1 row2 name info for the row2 ... and so on. I want the exported filename to…
Ionita Cristian-Valentin
  • 85
  • 1
  • 7
0
votes
1 answer

Ods output delete SAS System title

I have used an ODS output to PDf of a freq table inspite of using the noptitle it still prints SAS System on the top. the code is options nodate center nonumber ; ods noptitle ; ods pdf file="Z:\temp.pdf" ; ods proclabel="The totals"; proc freq…
user3658367
  • 641
  • 1
  • 14
  • 30
0
votes
1 answer

Simple ODS, OutOfMemoryError: Java heap space on save file

I get this error "OutOfMemoryError: Java heap space", when save a file with 1500 rows or more. I try solve this split the list data I tried to solve this split data list into smaller parts and save and load the ods file. I use de function…
oscar
  • 1,636
  • 6
  • 31
  • 59
0
votes
1 answer

Why do I get a warning when using ods select and proc mixed?

Within an ODS POWERPOINT statement I intend to produce some output from a PROC MIXED. I do not want all the tables to be shown. Using ODS TRACE ON passes the following results to the log: Output Added: Name: ModelInfo Label: Model…
Andreas Jensen
  • 21
  • 1
  • 6
0
votes
1 answer

SAS Proc Report Title Error

I have an issue where by the do loop creates my reports however the title page where the macro is listed doesn't reflect the correct naming convention each time. It works for each of the bookmarks in PDF as well as the proc report itself. However…
Tinkinc
  • 449
  • 2
  • 8
  • 21
0
votes
1 answer

ODS import into MySQL : offset data

I ran into a problem importing ODS files into a MySQL Database. Every row and column is creating fine, and the data inside is correct for the most part. But for some reason, I have a few rows who have the correct data, but not in the correct…
Ichi Sumeragi
  • 1
  • 1
0
votes
0 answers

Data reading from .ods format file,Code is not working

I have written this code, but not getting any output: require_once 'SpreadsheetReaderFactory.php'; $spreadsheetsFilePath = 'data.ods'; $reader = SpreadsheetReaderFactory::reader($spreadsheetsFilePath); $sheets =…
Bhulawat Ajay
  • 287
  • 2
  • 3
  • 16
0
votes
0 answers

ODS library for octave OSX

I have to read an ODS data file in octave. After some search I knew that I should use the ods library for octave but I don't know how to install it. So how to install ods library for octave using brew on OSX?
mkmostafa
  • 3,071
  • 2
  • 18
  • 47
0
votes
1 answer

The filetype you are attempting to upload is not allowed ods file in codeigniter

i want to upload an ods file ,but its showing an error: The filetype you are attempting to upload is not allowed $config['upload_path'] = './uploads/'; $config['allowed_types'] = 'ods|csv|xls'; // $config['max_size'] = ''; …
anju
  • 101
  • 1
  • 10
0
votes
3 answers

SAS- Defining Page Breaks inside Macro

I am wondering if there is a way of defining when and where page breaks occur when using a macro to output data. I know within the various ODS tagests the "Startpage=NOW" can be used but that does not seem to work if a macro is used inside that…
Brad
  • 85
  • 12
0
votes
1 answer

jOpenDocument: problems trying to generate PDF from ODS in

I have an .ods file and want to export it as PDF using jOpenDocument (Java). I use following code: // load the ODS file final OpenDocument filledCertificate = new OpenDocument(); …
user4942391
0
votes
1 answer

jopendocument create spreadsheet programatically and show it

I'm trying to create/save/preview an spreadsheet with JOpenDocument. I have read lots of examples but none one has created a spreadsheet on the fly. All off examples start loading one existent ODS. Finally, the create process work but I could not…
Marcelo D. Ré
  • 181
  • 2
  • 10
0
votes
2 answers

Programmatically deleting a worksheet in an ODS file (preferably in Python)

How do I programmatically delete a worksheet in an open document spreadsheet, preferably in Python? I have looked at https://pypi.python.org/pypi/pyexcel-ods/0.0.3 but I don't see any documentation on how to do this. And if I run…
zadrozny
  • 1,631
  • 3
  • 22
  • 27
0
votes
1 answer

Google Apps Script: Save Spreadsheet as ODS for Local Backup

I could use a hand. My company uses Google Sheets extensively, and we need a way to access files when we lose our Internet connection. I could not get any of the examples found on this site to work for creating xls or ods from Google Sheets via…
GASy
  • 41
  • 1
  • 5
1 2 3
…
12
13