Problem : I have been sent an encrypted .docx file as it contains confidential information, but I am on linux. […]
Tag: openoffice
Referncing a cell, based on a cell’s value in Spreadsheet
QUESTION : I understand how referencing a cell works, example being =Sheet1.A1 However, if I’m in Sheet2 and cell B1 […]
Excel / open/libre office formulae: number of full months left until date
QUESTION : I need a formula which equates to an integer value for the number months left until a set […]
Convert ZIP code to state in OpenOffice
QUESTION : I’m trying to move data from two of our old systems into a new system. Problem is, somewhere […]
Repeat rows at top of printed page
QUESTION : In Excel, under Page Setup, there is an option for “Print Titles”, where you can specify a number […]
Database access through odbc driver and excel
QUESTION : Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then […]
Ubuntu to Windows openoffice save issues?
Problem : I just finished working on my teacher’s paper, which is due to her an hour ago… For 2 […]
Assign number values to certain letters in Excel or OpenOffice
QUESTION : I’d like like to know how to assign to some letters a number value for a monthly Hospital […]
Binary spreadsheets with bitwise operators [closed]
Problem : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
OpenOffice: Replace text with new-line
QUESTION : In my OpenOffice spreadsheet, there are cells containing “n” text. Each “n” occurrence needs to be replaced with […]