Re: [libreoffice-users] Recovered File Issues - Blank Document

2023-05-05 Thread Chuck Spalding
I suspect the reason that Options is not in the Tools menu is because the original poster is using a Mac. The Mac version of LibreOffice has its options in Preferences in the "LibreOffice" menu. Chuck (LibreOffice 7.4.6.2, Mac OS 10.13.6) On Fri, May 5, 2023 at 8:27 AM Peter Hillier-Brook

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

2021-05-10 Thread Chuck Spalding
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: index column A with column B

2021-01-24 Thread Chuck Spalding
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