Re: [libreoffice-users] calc

Be sure to include the *$* symbol in the Array. Remember: the Index, *2*, represents the (second) column, which is referenced to the leftmost column within the (locked) Array, *$A$2:$B$4*. NOTE: The data in column *A *need not be only a numeric value; the data may be text also. Op 7

Re: [libreoffice-users] calc

=VLOOKUP(A4;$A$1:$B$3;2;0) The last argument (0) makes VLOOKUP find an exact match to whatever is in A4. This means that if A4 is empty, or contains a value that does not exist in the range it will respond with N/A > Op 7 jun. 2024, om 19:11 heeft Ekerette Ekpo het > volgende geschreven: >

Re: [libreoffice-users] calc

How did you do it with vlookup? I tried it out and ended up with a #N/A in cell B4. On Thu, 6 Jun 2024, 22:33 James, wrote: > Thanks, got vlookup to do what I want. :-) > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? >

Re: [libreoffice-users] calc

Thanks, got vlookup to do what I want. :-) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive:

Re: [libreoffice-users] calc

I believe what OP wants is "Give me the contents of the cell at Column B, Row the-number-that-appears-in-cell-A4" I think it can be done with CONCAT but I wouldn't bet money on it. --hymie! On Thu, Jun 06, 2024 at 12:43:17PM +0200, Rob Jasper wrote: > If I understand you correctly

Re: [libreoffice-users] calc

Ignore me, I think I misunderstodd your "vlookup" command which now looks right to me. Sorry. --hymie! On Thu, Jun 06, 2024 at 08:10:42AM -0400, hymie! wrote: > I believe what OP wants is "Give me the contents of the cell at Column B, > Row the-number-that-appears-in-cell-A4" > > I think it

Re: [libreoffice-users] calc

If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what you want > Op 6 jun. 2024, om 05:33 heeft James het volgende > geschreven: > > Say I have column A with the numbers 1, 2, 3: > A1 (1) > A2 (2) > A3 (3) > and column B with the numbers 11, 22, 33: > B1 (11) > B2 (22)

Re: [libreoffice-users] calc

At 23:33 05/06/2024 -0400, James Lockie wrote: Say I have column A with the numbers 1, 2, 3: A1 (1) A2 (2) A3 (3) and column B with the numbers 11, 22, 33: B1 (11) B2 (22) B3 (33) Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch which row is referenced so I can see the

Re: [libreoffice-users] calc: all links broken in existing spreadsheet

Hi Tom, I just upgraded to: Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.7-0ubuntu0.23.10.1~bpo22.04.1 Calc: threaded From which

[libreoffice-users] calc

Say I have column A with the numbers 1, 2, 3: A1 (1) A2 (2) A3 (3) and column B with the numbers 11, 22, 33: B1 (11) B2 (22) B3 (33) Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch which row is referenced so I can see the effects of different choices). Is there a calc

[libreoffice-users] calc: all links broken in existing spreadsheet

I just upgraded to: Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.7-0ubuntu0.23.10.1~bpo22.04.1 Calc: threaded All links in my major daily

[libreoffice-users] Calc auto complete from a list of cells

I was asked how to make an auto complete from a list of cells in another sheet in the same file. I thought the validation would work, but it only supports a scroll bar. That is fine for short lists, but not for hundreds of lines. Any suggestions on how to do this? I have seen it in some apps. I

[libreoffice-users] Calc scrolling in slow motion

Good afternoon I do have a problem. Recently I upgraded to 24.2.3.2, because I wanted to enjoy the highlighting of rows and columns in Calc. Which to me, however, looks horrible and I am not using it now. Problem: Since I upgraded, I noticed that when I try scrolling through big Calc sheets,

[libreoffice-users] Calc Print Preview shows only first page of Print Range

LO 7.4.2.3 (x64) Print Range is defined ($A$1:$H$236), with Rows to Repeat ($1:$7), but only the first page ($A$1:$H$58) shows in Print Preview. (I don't recall having this problem before.) Can someone point me aright? John -- To unsubscribe e-mail to:

Re: [libreoffice-users] Calc basic printing and alignment issues - bug or me?

Hi Budge, the print ranges may be set incorrectly. Page and printer setup in Calc: https://wiki.documentfoundation.org/Videos/Page_and_printer_setup_in_Calc Regards Harald Am 10.11.2023 um 10:49 schrieb Budge: I am working on an openSUSE Leap 15.5 system with LibreOffice Version: 7.5.4.1

[libreoffice-users] Calc basic printing and alignment issues - my fault (probably) or bug?

I am working on an openSUSE Leap 15.5 system with LibreOffice Version: 7.5.4.1 (X86_64) / LibreOffice Community Build ID: 50(Build:1) (SystemPU threads: 24; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-GB (en_GB.UTF-8); UI: en-GB, Calc: threaded.) I have a very simple

[libreoffice-users] Calc basic printing and alignment issues - bug or me?

I am working on an openSUSE Leap 15.5 system with LibreOffice Version: 7.5.4.1 (X86_64) / LibreOffice Community Build ID: 50(Build:1) (SystemPU threads: 24; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-GB (en_GB.UTF-8); UI: en-GB, Calc: threaded.) I have a very simple

Re: [libreoffice-users] Calc: how to auto-increment sheet names in a cell formula?

Hi, You could name the location of the data on each sheet with a name created in a way that makes it easy to figure out the name from the row number. You can then use the INDIRECT() function to retrieve the information you want. For example, on the second sheet, the name of the range could be

Re: [libreoffice-users] Calc - how to auto-increment sheet references in a formula?

Den ons 20 sep. 2023 kl 07:58 skrev Tom Cloyd MS MA : > I have trying to solve this problem all evening, with no hint of success: > > Let's say I have 11 sheets in a Calc spreadsheet. Sheets 2 to 11 contain > data summarized in cells A1:E1 of each sheet. > > I want to capture these summary data

Re: [libreoffice-users] Calc: how to auto-increment sheet names in a cell formula?

On 19 Sep 2023 at 23:06, Tom Cloyd MS MA wrote: Date sent: Tue, 19 Sep 2023 23:06:41 -0700 To: LibreOffice User's Help Forum From: Tom Cloyd MS MA Subject:[libreoffice-users] Calc: how to auto-increment sheet names in a cell

[libreoffice-users] Calc: how to auto-increment sheet names in a cell formula?

I have trying to solve this problem all evening, with no hint of success: Let's say I have 11 sheets in a Calc spreadsheet. Sheets 2 to 11 contain data summarized in cells A1:E1 of each sheet. I want to capture these summary data in sheet 1, starting with cell A1:E1. But I then want to copy

[libreoffice-users] Calc - how to auto-increment sheet references in a formula?

I have trying to solve this problem all evening, with no hint of success: Let's say I have 11 sheets in a Calc spreadsheet. Sheets 2 to 11 contain data summarized in cells A1:E1 of each sheet. I want to capture these summary data in sheet 1, starting with cell A1:E1. But I then want to copy

Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

On Sun, 2 Jul 2023 at 09:47, David Carter wrote: > I have previously selected a column and clicked the "background > highlight" icon with color of yellow selected - that would turn the > entire column yellow - it no longer works! No answer, but doing this is a Very Bad Idea. Spreadsheets to

Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

Jul. 2, 2023 11:33:27 lo.harald.ber...@t-online.de: Formatting with toolbars is also called direct formatting, and is not well suited for larger documents. To format cells (or columns/rows), cell styles should be used. How to do that you can find here:

Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

On 7/2/23 07:42, David Carter wrote: Been using Open Office and then LibreOffice since 1993.  Used to use Bugzilla occasionally in the past. . . . This is my first post to this mailing list, to seek support from the community. I have a spreadsheet I've been using for 3 years.  I modify it

Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

alls" dialog click the "Background" tab. 5. Click the "Color" button and choose the required color. Obviously click OK. Hope that helps. Regards Dave Original Message From: David Carter [mailto:dcarter204...@gmail.com] Sent: Sunday, July 2, 2023, 14:42 UTC

Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

Dear David, a new installation will not touch personal settings. All settings you have made will be stored in the so-called user profile. https://wiki.documentfoundation.org/UserProfile This user profile is not touched during installations. So if you want to turn a toolbar on or off, choose

[libreoffice-users] Calc - Can't highlight a column and set background shading

Been using Open Office and then LibreOffice since 1993.  Used to use Bugzilla occasionally in the past. . . . This is my first post to this mailing list, to seek support from the community. I have a spreadsheet I've been using for 3 years.  I modify it occasionally. I have previously selected

Re: [libreoffice-users] Calc default font size

Office has some setting deeper within its structure that specifies 10pt.  I would like to understand where that setting is and I'm hoping someone can point me to it. Philip On 5/22/23 03:08, users+h...@global.libreoffice.org wrote: Subject: [libreoffice-users] Calc default font size From: Phili

Re: [libreoffice-users] Calc default font size

Go to Tools > Options > LibreOffice > Fonts and change it there. Does that work? On 5/22/23 03:08, users+h...@global.libreoffice.org wrote: Subject: [libreoffice-users] Calc default font size From: Philip Jackson Date: 5/21/23, 12:53 To: LibreOffice Using LO 7.3.7.2 in Ubu

[libreoffice-users] Calc default font size

Using LO 7.3.7.2 in UbuntuStudio 22.04 These days, I need a minimum of  12pt font size in Calc. Creation of a new file via File > New > Spreadsheet opens always with settings at 10pt.  I have edited a Default template in the .config/libreoffice/ directory with 12pt font size and creating a new

Fwd: [libreoffice-users] Calc- combine columns data

=concat(a1," ",a2) So A1 = Mark, A2 = Smith, A3 will be Mark Smith If A1 is Mike and A2 is empty, A3 will be Mike -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Dec 2, 2022 at 7:07 AM . wrote: > > I want to be able to combine the contents of,

Re: [libreoffice-users] Calc - adding up score numbers

I have Excel 365 which operates differently but it finally worked with Paste Special. Thank you for your help. Charles. On Fri, Oct 21, 2022 at 3:31 PM Hastham S wrote: > Hi > > Which version of MS XL are you using ? > Which operating system - MAC or Windows ? > > *Did you check the help URL

Re: [libreoffice-users] Calc - adding up score numbers

Hi Which version of MS XL are you using ?Which operating system - MAC or Windows ? Did you check the help URL that I had posted for example in EXCEL 2003, this is what you do - - Select the cell(s) whose values should be copied. - From the Edit menu, select Copy. ... -

Re: [libreoffice-users] Calc - adding up score numbers

Hi, Thanks for the well wishes. I highlighted the last column with all the total numbers of that judge's scoring for that judge. I then drag the highlighted numbers in each cell in each frew for that column down from the first to the last story. I right clicked and chose Copy. I then opened a

Re: [libreoffice-users] Calc - adding up score numbers

Hi Charles Great to know you are safe. Regarding the copy paste, I think you are just doing normal Control + C and Control + V which will copy the formulae Please try paste special - paste values, when you paste on to the summary sheet Paste values In MS Excel : Copy and paste specific cell

[libreoffice-users] Calc - adding up score numbers

Hi All, So grateful to have survived Hurricane Ian and to be able to help others in the community. It seems Excel isn’t as straight forward as I’d like. Perhaps this is easier to do in Calc? I opened a blank worksheet and thought I’d create the first column of rows with each cell

[libreoffice-users] Calc - selected cell indicator color

When the cursor is placed on a cell in calc, it is outline in light blue (in the default theme). I find this miserably hard to see much of the time. Is there any way to change that color, or better yet to make it always contrast with the color of the cell itself? This would be so helpful to

Re: [libreoffice-users] calc formula are displayed as ###

I see the same effect when the column is too narrow to display the formula. Display is If the column width is increased so the entire formula can be displayed, then the formula will be displayed. The fact that the formula does not display over adjacent empty cells, like text does, I would

[libreoffice-users] calc formula are displayed as ###

Hi Using LO 7.2, in scalc I selected Tools-->Options-->Scalc-->View--Display_Formulas Which I activated However then the formula in that colum are displayed as ### (before turning this option on, the result was displayed) Is this a BUG or a feature. If it is a feature I fail to see its

Re: [libreoffice-users] Calc function COUNTA

That is no surprise to me. ISBLANK=0 is non-sensical and returns "#NAME?".  COUNTA counts that as a non-empty value.  All is good. Mike On 6/25/22 15:05, users+h...@global.libreoffice.org wrote: Subject: [libreoffice-users] Calc function COUNTA From: Harvey Nimmo Date: 6/25

Re: [libreoffice-users] Calc function COUNTA

Thanks for all the inputs! Great stuff. As I said, I wanted to count the number of non-blank cells in a column, but as =COUNTA(A$2:A$1, ISBLANK=0) is above an otherwise empty column returns the value 1, I am obviously not using the function correctly. =COUNTA(A$2:A$1) does the trick.

Re: [libreoffice-users] Calc function COUNTA

ut the counts the isblank=0 as an item? On 25 Jun 2022 at 21:41, Harvey Nimmo wrote: Subject:[libreoffice-users] Calc function COUNTA From: Harvey Nimmo To: libreoffice-users Date sent: Sat, 25 Jun 2022 21:41:23 +0200 I wanted t

Re: [libreoffice-users] Calc function COUNTA

nts the isblank=0 as an item? On 25 Jun 2022 at 21:41, Harvey Nimmo wrote: Subject:[libreoffice-users] Calc function COUNTA From: Harvey Nimmo To: libreoffice-users Date sent: Sat, 25 Jun 2022 21:41:23 +0200 > I wanted to count

[libreoffice-users] Calc function COUNTA

I wanted to count the number of non-blank items in a list of items using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an otherwise empty column. It returns the value 1! Is that supposed to mean something? Has anyone notice this? It's obviously not a big problem,

[libreoffice-users] Calc with Form Control not WYSIWYG in Print Preview

Hello, Form controls don't look right in print preview in Calc, didn't try in Writer. Here are the screenshots: OS: Mint Linux Libreoffice: 7.3.3.2 1. Create some controls [image: image.png] 2. In print preview a. Zoom : 76% (font size is wrong, label is clipped) [image: image.png] b.

Re: [libreoffice-users] Calc insists on capitalizing m^2 ...

Brian and Johnny, On 2022-05-01 08:50, Brian Barker wrote, and On 2022-05-01 10:52, Johnny Rosenberg wrote: Den sön 1 maj 2022 kl 14:46 skrev John Kaufmann: ... or any other quantity raised to any other power. Of course this is silly in a spreadsheet, where one wants to identify a

Re: [libreoffice-users] Calc insists on capitalizing m^2 ...

Den sön 1 maj 2022 kl 14:46 skrev John Kaufmann : > ... or any other quantity raised to any other power. Of course this is > silly in a spreadsheet, where one wants to identify a measurement. > > "m" is OK, but "m^2" gets auto-'corrected' to "M^2". Likewise "Cm^2", > "In^2", "Ft^2", "Inch^2",

[libreoffice-users] Calc insists on capitalizing m^2 ...

... or any other quantity raised to any other power. Of course this is silly in a spreadsheet, where one wants to identify a measurement. "m" is OK, but "m^2" gets auto-'corrected' to "M^2". Likewise "Cm^2", "In^2", "Ft^2", "Inch^2", and so forth. It's embarrassing that I don't see how to

Re: [libreoffice-users] Calc airithmetic snafu

Or perhaps leave the actual number in the first column and just use a cell format for the "km". i.e. 1) Leave 2.4 in the cell 2) ctrl+1 (cmd+1 mac) to open format cell 3) then in the Format Code type " km" behind the number format. And now your 2.4 will show "2.4 km" in the cell. And you can

Re: [libreoffice-users] Calc airithmetic snafu

Re: Units out of the data. 1. The formula =Value(Left(C1,Find(" ",C1))) will be insensitive to longer--129.4 km-- or less specific--7 km-- distances. 2. When I remove units from a list, usually I'm working a large amount of data and find that the whole spreadsheet works better when source data

Re: [libreoffice-users] Calc airithmetic snafu

HI ANDREW, On 2021/11/26 16:38, Andrew Pitonyak wrote: Left will return a string so convert to a number using value... Something like this =Value(left()) THANK YOU Works as expected,now on to the next formula Challenge Get BlueMail for Android On Nov 26, 2021,

Re: [libreoffice-users] Calc airithmetic snafu

Left will return a string so convert to a number using value... Something like this =Value(left()) ⁣Get BlueMail for Android ​ On Nov 26, 2021, 9:12 AM, at 9:12 AM, "Hylton Conacher (ZR1HPC)" wrote: >Hi, > >Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). > >I have a data column that ends

[libreoffice-users] Calc airithmetic snafu

Hi, Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). I have a data column that ends in alphabetic letters i.e.   C      |  D 2| 2.4 km|    2.4 3| 4.8 km|    4.8 As the ' km' can't be added in column C, I used the LEFT formula to only extract the first 3 digits, namely =LEFT(C2,3). This works

Re: [libreoffice-users] calc charting issue

On Sun, 01 Aug 2021 00:02:50 +0100 Brian Barker wrote: > I trust this helps. > > Brian Barker yes it did, I've double checked and now get the results I want. Thanks very much! d -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] calc charting issue

At 15:18 31/07/2021 -0700, Dave Stevens wrote: I have a small spreadsheet 5x12 elements and the numeric content data is missing for some cells. Their contents are given as ND for No Data. I want to chart these 5 rows and at first thought I'd just set them to zero. The range on y-axis values is

[libreoffice-users] calc charting issue

I have a small spreadsheet 5x12 elements and the numeric content data is missing for some cells. Their contents are given as ND for No Data. I want to chart these 5 rows and at first thought I'd just set them to zero. The range on y-axis values is about from 5 to 15. But with zeros the chart line

Re: [libreoffice-users] Calc: Adapting row height is slow

The other way is to open the ODF archive Zip and directly (e.g. with 7-zip) and edit the 'content.xml' file (gvim works well when set as the Editor for 7-zip). Find and change the 'use-optimal-row-height="true"' to "false"; there should only be a couple of these style settings. Save the changed

Re: [libreoffice-users] Calc: Adapting row height is slow

That is issue of tdf#124098 and caused by tdf#62268 see comments at end of bug 62268. Simple workaround is to get the sheet open and then remove the optimal row height by

[libreoffice-users] Calc: Adapting row height is slow

I have a large (10 by 100) but simple spreadsheet. When loading and, sometimes, editing it appears to take longer "Adapting row height" than the rest of the processing put together. I am happy with the existing row height and do not want it adapted. Is there anything I can do to

[libreoffice-users] Calc file "invalid parameter"

Good evening Again some strange question. Recently LibreOffice, maybe the computer?, has started to act strange on some occasions. Checking the net, I found only ONE related item. https://forum.openoffice.org/en/forum/viewtopic.php?f=11=96478 This is not really a "problem", but I would

Re: [libreoffice-users] Calc how to display Autofilter values?

Ahh.  Now I understand.  I can see how that might be useful. Sorry, but I don't know a way to do that right now. Seems like that might be a relatively easy thing to do, but I don't know how. Mike On 6/9/21 8:24 PM, Alan B wrote: Not at all what I'm trying to do. Distinct values have their

Re: [libreoffice-users] Calc how to display Autofilter values?

Not at all what I'm trying to do. Distinct values have their uses. But I already knew how to do that. I'm trying to display the AutoFilter values being applied to a table so they can be read without opening up each filter at the top of each column to see what the settings are. For example, three

Re: [libreoffice-users] Calc how to display Autofilter values?

See this: https://bytefreaks.net/applications/libreoffice-calc-get-the-distinct-unique-values-in-a-column-or-a-list-of-elements You can use Ctrl-z to undo the command, but don't use Ctrl-Shift-y to redo it on another column.  You must go through the command again on another column and then do

[libreoffice-users] Calc how to display Autofilter values? Not answered, maybe insight from Excel elicits answer

Many moons ago I was using some Calc sheets with AutoFilter routinely. The filter value would be changed, the sheet closed and sometime later opened again. To understand the displayed rows the filter values needed to be known. And that involved opening each filter and checking the value. So I

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Den sön 30 maj 2021 kl 18:05 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > On 2021/05/29 23:36, Johnny Rosenberg wrote: > > Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < > > hyl...@conacher.co.za>: > > > >> Hi Johnny, > >> > >> On 2021/05/28 23:44, Johnny Rosenberg

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Bravo Remy, On 2021/05/29 20:29, Remy Gauthier wrote: Hello, I created something that ressembles what Johnny created, and I understand your data is formatted like so: Data1 Data2 blank Data3 Data4 blank Data5 Data6 You want Data6 to be the maximum of Data2 and Data4 (and possibly more

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

On 2021/05/29 23:36, Johnny Rosenberg wrote: Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi Johnny, On 2021/05/28 23:44, Johnny Rosenberg wrote: Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi, I have LO

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Hello, I created something that ressembles what Johnny created, and I understand your data is formatted like so: Data1 Data2 blank Data3 Data4 blank Data5 Data6 You want Data6 to be the maximum of Data2 and Data4 (and possibly more columns as well), and you want to have Data5 equal to the date on

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > Hi Johnny, > > On 2021/05/28 23:44, Johnny Rosenberg wrote: > > Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < > > hyl...@conacher.co.za>: > > > >> Hi, > >> > >> I have LO 7.0.6.2 and am

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Hi Johnny, On 2021/05/28 23:44, Johnny Rosenberg wrote: Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi, I have LO 7.0.6.2 and am battling with understanding which formula to use as well as the syntax for that formula. I am aware of the availability

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > Hi, > > I have LO 7.0.6.2 and am battling with understanding which formula to > use as well as the syntax for that formula. > > I am aware of the availability of vlookup, hlookup, Index/Match formula > and

[libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Hi, I have LO 7.0.6.2 and am battling with understanding which formula to use as well as the syntax for that formula. I am aware of the availability of vlookup, hlookup, Index/Match formula and have settled I think on the right one i.e. Index/Match Below is a portion of my spreadsheet that

Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

On 11 May 2021 at 13:24, Philip Jackson wrote: Subject:Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits To: users@global.libreoffice.org From: Philip Jackson Date sent: Tue, 11 May

Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

On 11/05/2021 03:22, Joel Roth wrote: Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the number format to "#,##0\." (without the quotes, of course) works for me. ("#,##0.." also works, but that's too bizarre.;-) On my version (6.1.5) both of these formats display the cell

Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

On Mon, May 10, 2021 at 05:18:46PM -0700, Chuck Spalding wrote: > Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the > number format to "#,##0\." (without the quotes, of course) works for me. > ("#,##0.." also works, but that's too bizarre. ;-) On my version (6.1.5) both of

Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

Using LibreOffice 7.0.5.2 on macOS High Sierra (10.13.6), setting the number format to "#,##0\." (without the quotes, of course) works for me. ("#,##0.." also works, but that's too bizarre. ;-) Chuck On Mon, May 10, 2021 at 12:37 PM Joel Roth wrote: > On Mon, May 10, 2021 at 12:05:04AM -0600,

Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

On Mon, May 10, 2021 at 12:05:04AM -0600, Joe Conner wrote: > In calc, you could format the cell as currency. Thanks, I tried this, but wasn't able to display a terminal decimal point. > On 5/9/21 3:36 PM, Joel Roth wrote: > > Hi list, > > > > I'd like to input 123.45 and format it with a

[libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

Type locale in a terminal.  What locale are you? I am 'en_US'. This works for me: Type 123.45 in a cell Highlight the cell Format - Cells - 'Numbers' tab - Make 'Decimal places:' under Options zero (0). Mike On 5/10/21 1:04 AM, users+h...@global.libreoffice.org wrote: Hi list, I'd like

Re: [libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

In calc, you could format the cell as currency. On 5/9/21 3:36 PM, Joel Roth wrote: Hi list, I'd like to input 123.45 and format it with a decimal point but no decimal digits, in this example "123." . Previously I used the formatting code #,##0"." but now it causes an input of 123.45 to be

[libreoffice-users] Calc: Formatting cell with decimal point but no decimal digits

Hi list, I'd like to input 123.45 and format it with a decimal point but no decimal digits, in this example "123." . Previously I used the formatting code #,##0"." but now it causes an input of 123.45 to be received as 12,345, losing the decimal. Any ideas? Thanks in advance. -- Joel

Re: [BULK] Re: [libreoffice-users] calc: index column A with column B

James, There are 2 basic ways to accomplish this: Round the values at calculation time, so they’ll become real 0’s Change the formula to MINIFS(B:B;B:B;">=1”) Success, Rob > Op 29 jan. 2021, om 20:06 heeft James het volgende > geschreven: > > Another problem. > > Some of the numbers

Re: [libreoffice-users] calc: index column A with column B

Den fre 29 jan. 2021 kl 20:16 skrev James : > Another problem. > > Some of the numbers display as 0 but are calculated so have fractions like > > 0.000812344372353 > I want to find the last row that displays as non-zero. > One way to solve it is to round all involved cell values, if all the

Re: [libreoffice-users] calc: index column A with column B

Then use >0.001 or whatever value works instead of >0 On 29 Jan 2021 at 14:06, James wrote: Subject: Re: [libreoffice-users] calc: index column A with column B To: Rob Jasper Copies to: users@global.libreoffice.or

Re: [libreoffice-users] calc: index column A with column B

Another problem. Some of the numbers display as 0 but are calculated so have fractions like 0.000812344372353 I want to find the last row that displays as non-zero. On 2021-01-29 6:30 a.m., Rob Jasper wrote James, Since a MINIF function does not exist you can use MINIFS.

Re: [libreoffice-users] calc: index column A with column B

James, Since a MINIF function does not exist you can use MINIFS. Change MIN(B:B) to MINIFS(B:B;B:B;">0”) Success, Rob > Op 29 jan. 2021, om 03:59 heeft James het volgende > geschreven: > >>I want to find the row in column A that corresponds to the row of a >> >> value in column B. >>

Re: [libreoffice-users] calc: index column A with column B

Great, thanks. On 2021-01-24 5:59 p.m., Rob Jasper wrote: Is this what you mean: =INDIRECT("$A"(MIN(B:B);B:B;0)) Op 24 jan. 2021, om 23:14 heeft James > het volgende geschreven: I want to find the row in column A that corresponds to the row of a value in column

Re: [libreoffice-users] calc: index column A with column B

I think you meant to write this: =INDIRECT("$A"(MIN(B*1*:B*4*);B*1*:B*4*;0)) Chuck On Sun, Jan 24, 2021 at 3:22 PM Rob Jasper wrote: > Is this what you mean: > > =INDIRECT("$A"(MIN(B:B);B:B;0)) > > > > Op 24 jan. 2021, om 23:14 heeft James het volgende > geschreven: > > > > I want to find

Re: [libreoffice-users] calc: index column A with column B

Is this what you mean: =INDIRECT("$A"(MIN(B:B);B:B;0)) > Op 24 jan. 2021, om 23:14 heeft James het volgende > geschreven: > > I want to find the row in column A that corresponds to the row of a value in > column B. > > eg. > > rowAB > > 1 10 22 > > 2 20

[libreoffice-users] calc: index column A with column B

I want to find the row in column A that corresponds to the row of a value in column B. eg. row    A  B 1      10   22 2      20   15 3      30   3000 4      40   10 =some_function('A',minimum_function(B)); where minimum_function(B) returns 4 and

Re: [libreoffice-users] calc chart problems

At 19:18 18/01/2021 -0500, Marianne Keating wrote: I am using 4.4.7.2, under Windows 7, because it seems more than adequate for my purposes, and I am somewhat dismayed by the number of regressions noted for later versions in the comments here. It's probably unwise to use any out-of-date

Re: [libreoffice-users] calc chart problems

Greetings Marianne,Things have changed a lot since the version you are using, and it may be difficult to provide the information you are looking for. I did a bit of digging, and I managed to find this document: https://wiki.documentfoundation.org/images/b/bb/CG3403-ChartsAndGraphs.pdf which comes

[libreoffice-users] calc chart problems

Ahoy all: My apologies if this turns out to be a redundancy, but I originally submitted it some 4 hours ago and it hasn't shown up yet. Some 20 years ago, I frequently received questions such as those I pose below, and was able to easily answer them for others. By now, I seem to have aged

Re: [libreoffice-users] Calc calendar in xlsx file format - day numbers disappeared suddenly

Hi,It is a bit hard to guess what is going on without actually seeing the file. Can you e-mail it to me?Two things come to mind:- Calculations are in manual mode and the cells are not re-calculated. You can see the status in Data > Calculate (or try F9 to force recalculation)- Conditional

[libreoffice-users] Calc calendar in xlsx file format - day numbers disappeared suddenly

I have a calendar file in XLSX format that I've been using and tweaking for years, now. For the past two days, I've been updating it for 2021. Today, I thought I had it correct, but of course you always miss one thing or another. I copy the base file and update it from year to year. I reopened

Re: [libreoffice-users] Calc diagrams/figures

Informatique > > To: users@global.libreoffice.org > Subject: Re: [libreoffice-users] Calc diagrams/figures > > > hello, > > for these problems, i think that LO is not the best tools for scientific > diagram. > > Perhaps using a tool as GnuPlo

Re: [libreoffice-users] Calc diagrams/figures

On 16 Dec 2020 at 8:49, Informatique wrote: Date sent: Wed, 16 Dec 2020 08:49:01 +0100 From: Informatique To: users@global.libreoffice.org Subject:Re: [libreoffice-users] Calc diagrams/figures > hello, > for these probl

Re: [libreoffice-users] Calc diagrams/figures

hello, for these problems, i think that LO is not the best tools for scientific diagram. Perhaps using a tool as GnuPlot will be better. http://www.gnuplot.info/ François-Marie BILLARD On Mon, 14 Dec 2020 16:55:00 +0100 Thomas Welz wrote: > Hello together, > > first of all, I hope you can

[libreoffice-users] Calc diagrams/figures

Hello together, first of all, I hope you can understand, what I want to say. I'm not really familiar with all the terms regarding this topic. I'm not sure if this is the appropriate way for improvement suggestions. I hope so. Sometimes I have to generate figures, which I need for studying

Re: [libreoffice-users] [Calc] Convert GPS coords from DMS to decimals?

valent, or if the original data was in error. Macro was a pain to create. If values would also be fixed 2 digit numbers, it is also much simpler, since no need for find.. Interesting to play with... On 22 Nov 2020 at 12:43, Johnny Rosenberg wrote: From: Johnny R

  1   2   3   4   5   6   7   8   9   10   >