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
2
votes
1 answer

How to compare open office .ods files in SVN

I am unable to compare the local ods file with the remote ods file in SVN. Is their any way to do this?
user1787641
  • 331
  • 2
  • 8
  • 25
1
vote
2 answers

What is this SAS note saying? ODS PDF printed no output

I work on SAS Studio, and I try to make a pdf with ods. For an old job I managed to create the pdf without worries, but here it puts me that there is no output. Here it's my code, just to try to create the pdf. ODS PDF file=…
mat47
  • 59
  • 5
1
vote
1 answer

Quickest way to convert a spreadsheet to web form

There is often a situation where some business logic starts from the spreadsheet (Google, ODS, XLSX). You can enter data to some cells and upon that data, some other cells are calculated. Later often it is required to convert that into a web form.…
Kaspar L. Palgi
  • 1,332
  • 10
  • 22
1
vote
1 answer

ODS PDF with sgplot: How to make one TOC bookmark per page (with two graphs per page)

I am creating PDFs using ODS with two graphs per page. Both graphs have the same value for a type variable, 'month' below. I want to create a TOC bookmark for each page, which refers to the value of the highest-level variable ('year' below). There…
catquas
  • 712
  • 1
  • 5
  • 7
1
vote
1 answer

While parsing .ods file with pandas using read_excel() (and odf), how to drop comments in cells?

I'm trying to parse .ods files with pandas, using pd.read_excel() function, which uses odf under the hood. The problem I face is simple: some cells have comments, and pandas treat them as if they were some regular content. Here is a basic example ;…
Clej
  • 416
  • 3
  • 13
1
vote
1 answer

Column entries appear as NaN when converting an ODS file to EXCEL/CSV in Python

I am trying to convert an ODS file to XLSX/CSV using Python. The code snippet is shown below: import odf import pandas as pd pd.read_excel("filename.ods") The file gets converted to a Pandas data frame, however, all the column entries are NaN. …
Nanda
  • 361
  • 1
  • 5
  • 14
1
vote
0 answers

open .ods file inside python package

I am testing a python package that contains a .ods file where you can enter some information and then the rest of the python package pull the information out manipulates it and provides an output. On my local computer the follow code works fine.…
Stackaccount1
  • 139
  • 1
  • 12
1
vote
0 answers

Remove gridlines in ODS format with JasperReports

Using JasperReports we can use the property net.sf.jasperreports.export.xls.show.gridlines in order to remove the gridlines in the exported excel file. I'm looking for the same result in exported ODS files but can't find any corresponding property.…
Paco Abato
  • 3,920
  • 4
  • 31
  • 54
1
vote
2 answers

SAS ODS PDF title page 2

I am somehow failing to get a title to display on the second page of a SAS PDF output. My code (as far as the title statements are concerned) is nearly identical to a previous program I wrote that works perfectly. Page 1 works exactly as intended…
Michael Ancel
  • 95
  • 7
1
vote
1 answer

Excel Having issues with an ODS file created with SODS

I'm creating an ODS spreadsheet using SODS (https://github.com/miachm/SODS). This is a single-sheet, non formatted file. LibreOffice is happy with it, as is Google Spreadsheets. Excel, on the other hand, claims it contains errors, and when it…
Michael Bar-Sinai
  • 2,729
  • 20
  • 27
1
vote
0 answers

Phpspreadsheet ods problem with merge cells

Using phpSpreadsheet 1.16 to generate xls and ods files. Xls files runs correct but ods stuck on merge cells - no error simply forever loading. What can i do to solve…
Дмитрий
  • 131
  • 7
1
vote
0 answers

How to split a big ODS file without causing memory leaks?

I'm working with a MYSQL database, and have two types of files to import: First one is a CSV file that I can use LOAD DATA INFILE 'path-to-csv_file' The second type of file is ODS (OpenDocument Spreadsheet) that MYSQL doesn't support for LOAD DATA…
retr0
  • 55
  • 4
1
vote
1 answer

How to get time values as strings, during read_excel execution?

i have to parse ODF-format turnstile's data file. In the file are employees entry/out time values in HH:MM:SS (like a 141:59:30). link to sample file on GoogleDrive My attempts to open the file with df = pd.read_excel(filename, engine="odf", ...)…
Gerasim Gerasimov
  • 41
  • 6
1
vote
1 answer

Sending automated email from SAS with attachments that changes name

I have files that should be send out every week. These files changes names e.g. "filename_1" next week it will be "filename_2". But it only takes the filename that I manually wrote which is filename_1. Is there a way to say that it should take the…
hansgans
  • 11
  • 2
1
vote
1 answer

Convert ods to Google sheets

I am trying to convert an ods file to google sheets file format. However if the file is a little big (~ 2mb to 3mb) it starts to present the following problem several times GoogleJsonResponseException: API call to drive.files.insert failed with…
Diego Resende
  • 73
  • 7
1 2
3
…
12 13