Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
0
votes
0 answers

Conditionally clear content of cells subject to Data>Validity

In CALC I have a column which I set up to be filled with values from a specified cell range (using Data > Validity menu). This column represent a "Forecast date" in a spreadsheet used as a TODO list. Now another column in this sheet represent the…
remi
  • 3,914
  • 1
  • 19
  • 37
0
votes
1 answer

Libre Office Calc time Function

I want to make a Excel File (Using Libre Office Calc) that calcuates the working time per day, but I'm struggling to get it right as I'd like to have it. Example: A1 = type in your Start time. eg: 0800 (!!Note: no colon use at typing ) B1 = type in…
Barret
  • 7
  • 1
  • 4
0
votes
1 answer

Cross-hair display on chart

I am using two stock charts (one is candlestick and second is stochastics - line chart) one below the another. It would be great if a cross-hair can be displayed so that I can correlate the two charts. Is that possible?
Vineet
  • 624
  • 1
  • 11
  • 26
0
votes
2 answers

merging column in libreoffice calc does not work when drag down

I'm merging columns in Libre Office using the CONCATENATE function. I'm merging all text using: CONCATENATE(A1," ",B1," ",C1," ",D1," ",E1," ",F1," ",G1) According to this suggestion, I should be able to apply the function over the whole column by…
oczdref
  • 534
  • 1
  • 6
  • 15
0
votes
1 answer

Automatic insertion of a new row

I am looking for a solution in Libre/OpenOffice Calc, to automatically insert a new row if all the fields of the current row are filled with data. A bit more detailed: There is a spreadsheet in which the monthly expenses are stored, and at the end…
swizzly
  • 46
  • 6
0
votes
2 answers

How can I remove manually added page breaks?

I added a page-break to my spreadsheet but now I want some more lines at the top of page 2. I want to remove the page break as part of doing this. How do I remove the existing page break (that I had added before)? I've gone through all the menus and…
Michael Durrant
  • 93,410
  • 97
  • 333
  • 497
0
votes
1 answer

OpenOffice.org/LibreOffice Calc macro: is a cell's content currently overflowing?

I have a bunch of cells whose font size I'd like to tweak if their content is overflowing, until it all fits. I'd like to write a macro to do this, unless there's a conditional formatting or other formulaic way of doing it. Is there a property…
Kev
  • 15,899
  • 15
  • 79
  • 112
-1
votes
0 answers

How to store data in table to be able to sort posts without merging cells?

I want to sort the rows alphabetically. But in such a way that the rows from column B remain in line with row A. That is, blue1 and blue2 should always be opposite the blue row, exactly in this order. example_of_data_structure I tried merge cells in…
Tamila Ambeon
  • 7
  • 3
-1
votes
1 answer

Organize Binary Search LibreOffice Calc?

Does anybody know of a way to organize a binary search in LibreOffice Calc? To take a simple example, say I have column A with the numbers 1-16 listed, sorted in ascending order: (1,2,3,...); and column B which lists names of widgets; and I want to…
Mychal Simonian
  • 1
  • 1
-1
votes
1 answer

Libreoffice Calc sum/merge rows by timestamp?

I have a spreadsheet similar to this, consisting of crypto transactions, with 5k+ entries. However the exchange has chopped each transaction into 3 separate entries (Rec,Sent,Fee). Sometimes the transaction is also split before the chop, resulting…
user15427282
-1
votes
1 answer

What is the code to create a new sheet in LibreOffice? Additionally, how do I rename that sheet?

I am well-versed in Excel vba that I use for work, but I chose to use LibreOffice for this personal project because I don't have a personal MS Office license. Below is the code I currently have written. Sub Setup Dim oSheets Dim oBoardSheet …
Matthew Effinger
  • 13
  • 3
-1
votes
1 answer

calc/excel: retreive last value of a row after finding value in column

I have a calc spreedsheet, which is mostly similar to excel regarding formulas. In one sheet I have the details of some boughts I've done (comprasDet) and in another the items I can buy (productos). The first entry in comprasDet looks like this: I…
Gerardo
  • 81
  • 7
-1
votes
1 answer

VBA UDF for LO Calc that takes several arrays as arguments or produces array

I have trouble finding easy examples how to write simple UDF's (user defined functions) for LO Calc, that uses arrays as arguments or gives arrays as output e.g. array functions. I need simple example UDF that takes array and gives single number as…
Alex Alex
  • 235
  • 2
  • 14
-1
votes
1 answer

Detect software used to open an XLSX file with Macro or VBA

I search a way to know if an XLSX file is currently opened in Excel, libreoffice-calc or another sheet software. The goal is to display a warning in a cell only if the file is NOT open with excel. Is there an official Macro that would allow that? Or…
Julien Lafont
  • 7,869
  • 2
  • 32
  • 52
-1
votes
1 answer

Sorting date as 2nd criteria gives wrong order

The date is in the correct format ie YYYY-MM-DD. If I sort just on date it sorts to correct order however if i sort on another field first with date the second criteria it is sorted correctly on first criteria but the date is sorted by DD first MM…
Vic
  • 101
  • 1
1 2 3
…
57 58