I hope this is the right group.
After every LibreOffice update I have to fiddle with my calc rows to get
them to scroll right. Is there a way to prevent this?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
On 2/15/17 8:00 PM, Remy Gauthier wrote:
Hello,
Is there a way to identify the data you want? If so, you could use a
set of =SUMIF() or =SUMIFS() to add up the data that matches one or a
group of criteria. Otherwise, you may need to provide an example
(obviously scrubbed since it seems to be
I have data in a table by month. At the end of each year there is a
summary row separated by a blank line above and below. Frequently I
need to sum from, say, 03/16-02/17 so I have 10 rows with data I want,
three rows with data I don't want and two more rows with data I want.
My approach has
I have a date column with the format MM/. I just added the next
twelve months and it was formatted [M]M/, so I tried to reformat it.
The option SAYS MM/ but it still comes out [M]M/. Is this a
bug in the latest release or am I doing something wrong?
--
To unsubscribe
I use a Microsoft Wireless Mobile Mouse 3000 which seems to work fine on
everything but calc. When scrolling through a sheet it may completely
ignore input from the wheel or it may jump several lines. Does anybody
know anything about this?
--
To unsubscribe e-mail to:
My wife had some image mail attachments that were stored in aspx form.
I suspect they were holdovers from a much earlier computer that could
deal with them. A current Mac running 10.11.6 can't. Changing the
extension to pdf or trying to open them in Safari doesn't work either.
What does work
Most of my sheets are set up so they have an exact number of rows and
when you get to the bottom cell in a column the next row does not pop up.
Each new release of LibreOffice slightly changes that setup. Either
moving to the bottom cell in a column causes the next row to appear or
part of
I have two columns of data, A and B. Sometimes A.n>B.n, A.nA.n=B.n. I want to count these occurrences. The closest I could find
in help was countif(), but that doesn't really do what I need. Any ideas?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
I have all my spreadsheets set up the same way. They use about half the
vertical screen. Every time a new update comes along, the cell spacing
gets slightly changed. This means part of the next cell appears at the
bottom of the sheet or when I move to the bottom cell it spaces up one
when
I have some rate-of-change triangles I need to change. These show the
annual rate of change for different numbers of years and look like this:
2010X X X X X
2011X X X X
2012X X X
2013X X
2014X
Basically, I want to
On 1/4/15 10:43 AM, Gordon Burgess-Parker wrote:
Yes - add $ to the cell references in the formula - e.g., A2 becomes
$A$2. That means you can move the formula anywhere you want but it will
still reference A2...
I know that but that is what I am trying to avoid. I would have to
change it to
On 1/4/15 3:11 PM, Kaj Persson wrote:
You might have the answer in your own question, even I am not quite
ready in my thinking about this.
If you move the formula (e.g. via the sequence ctrl+X and ctrl+V at the
new position, well you can do it via the edit menu instead) the
references do not
I have all my existing sheets set up for about half a page. I can get
two on a single display if I need to do that, but mostly I want to see
the data I am about to enter. However, every once in a while I will
open one to full screen and save it or I will create a new one from the
top tier of
On 7/10/14, 2:33 AM, John R. Sowden wrote:
I have tried to standardize on freesans 10 point for most ss uses. I
just came on a file with very small type size, yet when I selected the
cell and the format - font, I got freesans 10 point. Not wanting to
diagnose myself as blind and/or crazy, I
Is it something I am doing or is each update slightly changing the
scaling on existing spreadsheets?
I have mine set up for roughly a half page and the bottom row should be
the bottom row. However, after the last couple of updates scrolling
down to the bottom row has caused the next row to
In article l48bop$k5o$3...@ger.gmane.org,
Alex Thurgood alex.thurg...@gmail.com wrote:
From what I recall, this is a hardcoded setting in either :
- one of the configuration files ;
- in the soffice bootstrap (rc) file.
How can I find/change these on a Mac? Are they in the library or the
I have most spreadsheets set to a standard size that takes about half a
screen. If I have one open and open a new one it is also half a screen.
However, if nothing is open a new one opens to full screen and that
resets ALL the other spreadsheets, which is a major pain. I have
checked
In article 20131017140916.56c2d...@abydos.stargate.org.uk,
Brad Rogers b...@fineby.me.uk wrote:
On Thu, 17 Oct 2013 08:07:34 -0400
Robert Peirce b...@peirce-family.com wrote:
Hello Robert,
However, if nothing is open a new one opens to full screen and that
resets ALL the other
In article 1361962498770-4040433.p...@n3.nabble.com,
Tinkerer j_taylo...@btinternet.com wrote:
BTW. I am running Mac 10.8.2 on an iMac and I have never experienced that
problem.
Me neither until yesterday. I have absolutely no idea what happened. I
thought maybe it was a system update but
In article bob-3216e6.12422727022...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
Me neither until yesterday. I have absolutely no idea what happened. I
thought maybe it was a system update but I restored from an earlier
backup without success.
I discovered what happened
In article bob-c1a022.12550827022...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
In article bob-3216e6.12422727022...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
Me neither until yesterday. I have absolutely no idea what happened. I
thought maybe
In article bob-9bd879.13352227022...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
Not quite. Eliminating the preferences file allowed me to fire up
LibreOffice once but then something causes it to hang. There is
something getting created on my computer that is causing
LibreOffice 3.6.4 and 3.6.5. I have been running LibreOffice for
several years with no problems. When I check for updates I am told
3.6.5 is the latest version for the Mac.
This program was working fine a couple of days ago. I think I may have
installed a Mac update since then but I'm not
In article bob-65097a.21472026022...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
I have not tried this but it might be possible to get LibreOffice
running and to minimize it when not needed, thereby avoiding exiting.
However, I really would like a solution to keep it from
In article 50c3cd7d.2050...@gmail.com,
Lincoln Ramsay a1291...@gmail.com wrote:
I couldn't find a bug report link on LibreOffice.org so I'm sending it here.
Steps to reproduce:
Navigate to a folder in the Finder that has more than 1 .odt file.
Select two .odt files.
Open them (Command +
In article 4fdab66c.1040...@gmail.com,
Jay Lozier jsloz...@gmail.com wrote:
Can you post some typical data on Nabble? I assume you do not need to
transform the data but plot the actual values.
What is Nabble?
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
In article bob-830a90.09121115062...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
In article 4fdab66c.1040...@gmail.com,
Jay Lozier jsloz...@gmail.com wrote:
Can you post some typical data on Nabble? I assume you do not need to
transform the data but plot the actual
If I use a small amount (3 pairs) of dummy information, the intercept,
slope and R^2 are exactly what I expect them to be. If I use something
on the order of 400 pairs it makes no sense at all. When I use Linest,
the results are reasonable.
I am evaluating stock trading systems against
In article 4fdaaa9f.7080...@gmail.com,
Jay Lozier jsloz...@gmail.com wrote:
What are your R^2 values? Near 1 indicates a high correlation between x
and y.
That's not the issue. One I get the slope and intercept right I'll
worry about R^2. It's less important to me right now.
Actually, in
I have tried to download this update several times but it always dies
before completion. I am using the same approach as I would use for any
other app, click on the download button and watch the download bar in
Safari. Any ideas? Is there an alternate download site?
--
For unsubscribe
I tried Safari again and then I tried Firefox. Neither was going
anywhere fast, so I selected the Download using BitTorrent option. It
downloaded a file named LibO_3.4.5_MacOS_x86_install_en-US.dmg.torrent
but it in't executable and I don't know what to do with it. The
activity monitor
In article bob-d2b5dd.17572628012...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
I tried Safari again and then I tried Firefox. Neither was going
anywhere fast, so I selected the Download using BitTorrent option. It
downloaded a file named LibO_3.4.5_MacOS_x86_install_en
In article 4f05ed69.1070...@krackedpress.com,
webmaster for Kracked Press Productions webmas...@krackedpress.com
wrote:
Then how do Mac people print their own photos on the 4x6 photo paper?
We can do that with Windows and Linux.
Mac computers were advertised as the best for graphic
In article je2qdg$scq$1...@dough.gmane.org,
Larry Gusaas larry.gus...@gmail.com wrote:
LibreOffice (and OOo) have serious printing problems on Macs when using sizes
other than the
standard letter and legal sizes.
I was just going to post a Where's the bug? message. I guess I don't
have
In article 4f0552fe.8070...@wetzel.pl,
Mieszko Kaczmarczyk mieszko.kaczmarc...@wetzel.co wrote:
Especially LO 3.4 series has got trouble with printout, as you mentioned
it other that legas sizes. I use LO on Linux and do printout even A4 in
landscape is horror. In old OO print the same
On most Mac apps, selecting print allows you to select a paper size on
the main print panel. In LibreOffice, as far as I have been able to
determine, you have to drill down into Paper Handling and then the only
way to change size is to select scale to fit. This results inm a
ridiculously
I have a 4x6 card I need to print. In other apps I just select 4x6. In
LibreOffice I need to go into Paper Handling, click scale to fit
paper size before I can select the 4x6 size. When I do that, the print
size is reduced to the point of being almost unreadable.
I want to select 4x6
In article bob-825ce2.18521203012...@news.gmane.org,
Robert Peirce b...@peirce-family.com wrote:
I have a 4x6 card I need to print. In other apps I just select 4x6. In
LibreOffice I need to go into Paper Handling, click scale to fit
paper size before I can select the 4x6 size. When I do
38 matches
Mail list logo