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? https://www.libreoffice.org/get-help/mailing-lists/ho
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 som
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 e-mail
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: users+unsubscr...@globa
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 i
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 th
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? http://ww
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 it
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 ch
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 c
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
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 br
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 ap
In article ,
Alex Thurgood 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
package contents? I am not finding anything obvio
In article <20131017140916.56c2d...@abydos.stargate.org.uk>,
Brad Rogers wrote:
> On Thu, 17 Oct 2013 08:07:34 -0400
> Robert Peirce wrote:
>
> Hello Robert,
>
> >However, if nothing is open a new one opens to full screen and that
> >resets ALL the other sp
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 prefere
In article ,
Robert Peirce 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 this but I have
> no idea what it is or where to lo
In article ,
Robert Peirce wrote:
> In article ,
> Robert Peirce 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.
> >
In article ,
Robert Peirce 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. There was a directory in Application
Suppo
In article <1361962498770-4040433.p...@n3.nabble.com>,
Tinkerer 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 I restored from an ear
In article ,
Robert Peirce 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 hanging.
This works for LibreOffice but then Saf
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 su
In article <50c3cd7d.2050...@gmail.com>,
Lincoln Ramsay 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 + O).
>
>
In article ,
Robert Peirce wrote:
> In article <4fdab66c.1040...@gmail.com>,
> Jay Lozier 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?
I found th
In article <4fdab66c.1040...@gmail.com>,
Jay Lozier 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
Problems? http://ww
In article <4fdaaa9f.7080...@gmail.com>,
Jay Lozier 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 the kind of syste
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 holdin
In article ,
Robert Peirce 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-US.dmg.torrent
> but it in't executable
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 doesn
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 inst
In article <4f05ed69.1070...@krackedpress.com>,
webmaster for Kracked Press Productions
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 processing, but if
> the
In article <4f0552fe.8070...@wetzel.pl>,
Mieszko Kaczmarczyk 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 document is OK.
Aha!! Tha
In article ,
Larry Gusaas 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 to.
LibreOffice = 3.4.4
Format->Page->Page=4x6, l
In article ,
Robert Peirce 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 that, the print
>
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 wit
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 smal
38 matches
Mail list logo