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
I am trying to use the roo gem to parse an Openoffice spreadsheet. However I am getting the following error while beginning my localhost
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).
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
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
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
I have a spreadsheet that contains data that ranges from 0.0 to 1.0, e.g开发者_运维问答. a, 0.1
I need to do a simple function that is driving me nuts. I have 3 columns with cells filled as follows.
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.
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
加载中,请稍侯......