http://snipplr.com/tags/openoffice Recent snippets posted on Snipplr.com en-us Wed, 19 Jun 2013 08:18:39 GMT http://snipplr.com/view/69518/insert-page-breaks-in-oocalc-spreadsheet/ page break inserted when first letter of first cell in row changes

]]> Thu, 17 Jan 2013 20:56:51 GMT http://snipplr.com/view/69518/insert-page-breaks-in-oocalc-spreadsheet/ http://snipplr.com/view/30431/convert-frames-as-integer-to-correctly-formatted-video-timecode/ Takes an integer value of frames (a) and converts it to a text formatted timecode "00:00:00:00" using the supplied framerate (b). Mainly for use in OpenOffice Calc.

]]> Sun, 28 Mar 2010 18:58:03 GMT http://snipplr.com/view/30431/convert-frames-as-integer-to-correctly-formatted-video-timecode/ http://snipplr.com/view/30430/convert-video-timecode-from-text-to-frames/ Takes a video timecode (a) in text format "00:00:00:00" and converts it to frames, using the supplied framerate (b). Mainly for use in OpenOffice Calc.

]]> Sun, 28 Mar 2010 18:48:15 GMT http://snipplr.com/view/30430/convert-video-timecode-from-text-to-frames/ http://snipplr.com/view/27342/export-a-single-sheet-of-an-excel-spreadsheet-as-csv-from-the-command-line-with-open-office/ modified from branflake2267's post at oooforum.org: http://www.oooforum.org/forum/viewtopic.phtml?t=52942 usage: Paste into the Standard.Module1 macro file. Then, create xls2csv bash script containing: #!/bin/bash file="$(readlink -f "$1")" /usr/lib/openoffice/program/soffice -invisible -headless -norestore "macro:///Standard.Module1.ConvertXls2Csv(\"$file\", \"$2\")" The first argument is the xls file name, second is the name of the sheet: `xls2csv ./spreadsheet.xls "Some Sheet"`

]]> Fri, 29 Jan 2010 20:28:06 GMT http://snipplr.com/view/27342/export-a-single-sheet-of-an-excel-spreadsheet-as-csv-from-the-command-line-with-open-office/