openoffice-calc
OpenOffice Basic Select All
Does anyone know how to select all the used cells in an OpenOffice Basic Macro? I found this other question telling how to do it with pyUno:开发者_如何学Python[详细]
2023-03-14 18:33 分类:问答Error with Roo . Any gems to parse .ods files
I am trying to use the roo gem to parse an Openoffice spreadsheet. However I am getting the following error while beginning my localhost[详细]
2023-03-14 14:48 分类:问答How can I get a random cell in OpenOffice Calc?
I\'ve perused the Stack Exchange list of sit开发者_高级运维es, and I can only think that SO is the right place to ask this (I saw a few excel questions, at least).[详细]
2023-03-10 07:49 分类:问答OpenOffice Calc can not read a simple CSV file. Why?
I have a Web site (PHP) that generates a CSV file (text/csv) with the following content: ID;E-Mail_User;Name;Applikation;Rolle;Auftragsdatum;Administrator[详细]
2023-03-06 23:40 分类:问答OpenOffice/LibreOffice calc hyperlink
I\'m using OpenOffice calc (or rather the Libreoffice verion in Ubuntu 11.04). I used the hyperlink function to add links to a column using the function: =hyperlink(\"http://www.ncbi.nlm.nih.gov/pubme[详细]
2023-03-04 15:58 分类:问答Open/Libre Office drag and drop MIME types
Does OpenOffice or LibreOffice support any mime types which allow direct pasting/drag\'n\'drop of tabular data? I have implemented CSV drag and drop, but since my source data is already tabular, I\'d[详细]
2023-03-03 12:27 分类:问答How do I create a histogram where the bar heights cover a range of values (preferably in Open Office Calc )?
I have a spreadsheet that contains data that ranges from 0.0 to 1.0, e.g开发者_运维问答. a, 0.1[详细]
2023-03-02 09:17 分类:问答comparing three cells in openoffice calc. (i'd be happy with 2)
I need to do a simple function that is driving me nuts. I have 3 columns with cells filled as follows.[详细]
2023-02-25 09:26 分类:问答OpenOffice.org Calc SUMIF statement
I\'m trying to sum all cells in C2:C2000 if the corresponding cell in column A is in (10; 20], but I\'m having prob开发者_如何学编程lems with the condition.[详细]
2023-02-24 03:48 分类:问答Custom Array Functions in Open Office Calc
Could someone please tell me how to write a custom function in Open Office Basic to be used in Open Office Calc and that returns an array of values. An example of one such built-in function is MINVERS[详细]
2023-02-22 23:53 分类:问答