I finally looked at it.
I think it had an error in the xml in content.xml.
I changed that and it parsed in the google chrome parser but when I
zipped everything up it wouldn't open in libreoffice with a different error.
You can rename the .ods file to .zip and then unzip it.
The content is in co
The mailing list strips off attachments.
Upload it to a file sharing site.
What OS,version of libreoffice?
--
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://wik
Hi Curtis,
LibreOffice has named ranges, data ranges and scenarios. It is likely,
that LibreOffice has already a suitable feature. To be able to help you
finding a tool, you need to describe in more details what do you want to do.
Kind regards,
Regina
Curtis Tarazi schrieb am 15.06.2024 um 1
Den lör 15 juni 2024 kl 16:36 skrev Curtis Tarazi :
> Hello Libreoffice,
>
> This email is not meant to complain, I am a user of your suite, and I love
> all the applications you can use, and that they are all free. I see all the
> effort that all the creators put in, and I love libre office. I re
> Virgil
>
>
> From: ady adylo811...@gmail.com
>
> Sent: Thursday, May 30, 2024 7:00:02 PM
> To: users@global.libreoffice.org users@global.libreoffice.org
>
> Subject: Re: [libreoffice-users] Libreoffice Calc
>
> > For some reason my questions are not getting po
I have found several of your emails in my junk email folder. I find that over
half of all emails from the LO list go to my junk folder.
Virgil
From: ady
Sent: Thursday, May 30, 2024 7:00:02 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users
> For some reason my questions are not getting posted. Hopefully the fourth
> attempt works.
There are at least 2 emails from you in the public users mailing list;
see the mailing list public archives. I am replying to one of them.
> Software: LO, Version 7.3.7.2, Linux (Mint)
>
> I thought tha
I guess it depends on your theme, but at least for me, the active cell is
the one that is surrounded by a fat blue frame. I'm not sure how it could
be any clearer than that. Also the column and row headers have a blue
background instead of grey.
Kind regards
Johnny Rosenberg
Den ons 8 maj 2024
David,
A follow up to my first reply. I wanted to investigate a bit more to see if
I could produce a macro that actually incremented values in column B based
on the corresponding cell in column D being changed.
This works for me incrementing the value in col B by +1 when the value in
column D on
Generally, The following should work, but spelling or spacing differences
won't be ignored. any difference in the name will be treated as a new
reviewer.
IF(A1=A2,B1+1,1)
On Tue, Dec 10, 2019 at 10:51 PM zed wrote:
> Hi!
>
> Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
>
> I have a spre
Hi David,
As I understand it you have values in column B and dates in column D. When
a new date is entered in a cell in column D or an existing date is changed
you want the cell on the corresponding row in column B to increase by 1.
e.g. B1 = 5, D1 = May 5, 2019
change D1 and B1 becomes 6.
- or -
Den tors 12 dec. 2019 kl 05:38 skrev zed :
> Brian Barker wrote:
>
> > At 17:49 11/12/2019 +1300, David Noname wrote:
> > > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted
> > > number general ...
> > >
> > > Is there a formula that I can enter in Column B which will increas
At 17:35 12/12/2019 +1300, David Noname wrote:
Thank you for your prompt reply, Brian. It is much appreciated
No probs!
Perhaps I didn't explain myself clearly enough. In simple terms, I
want to know whether there is any way that when I enter a new date
in Column D it will automatically inc
Johnny Rosenberg wrote:
> Den ons 11 dec. 2019 kl 05:51 skrev zed :
>
> > Hi!
> >
> > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
> >
> > I have a spreadsheeet in Calc which records data of reactions to a
> > particular performer. It is in the form: It has Columns A - G.
> >
> > A - Nam
Brian Barker wrote:
> At 17:49 11/12/2019 +1300, David Noname wrote:
> > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted
> > number general ...
> >
> > Is there a formula that I can enter in Column B which will increase
> > incrementally increase the figure by 1, please?
>
Den ons 11 dec. 2019 kl 05:51 skrev zed :
> Hi!
>
> Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
>
> I have a spreadsheeet in Calc which records data of reactions to a
> particular performer. It is in the form: It has Columns A - G.
>
> A - Name, fformatted as Text (records thre name of th
At 17:49 11/12/2019 +1300, David Noname wrote:
I have a spreadsheet in Calc ...
It has Columns ...
B - No, formatted number general ...
Is there a formula that I can enter in Column B which will increase
incrementally increase the figure by 1, please?
I think you are saying that you want valu
Hi again!
I have increased all the LibreoOffice memory parameters as shown below.
Unfortunately the screen continues to break up.
The breakup even occurs with a small simple single page spreadsheet. I
have found upon screen breakup if I do a S (save) the screen
resets till the next failure.
Hi Vytas and all:
It would be happened because the spreadsheet need more memory.
You can increase it following these steps:
1) Menu-Tools-Options-LibreOffice-Memory: Here you can
increase memory to some options.
I hope this help,
Regards,
Jorge Rodríguez
El 04/04/20
Le 10/10/2017 à 00:48, Joe Conner a écrit :
Ubuntu 17.04 64bit LibreOffice Version: 5.4.2.2
Now I have discovered that I cannot any more insert a note to a Calc
cell. Formerly I could access this with a right click context menu
INSERT NOTE but the feature is no longer present. To where has it
Please ask the question, and hopefully someone on the mailing list can
help you.
steve
On 19/09/17 19:42, Огнян Медаров wrote:
Hello,
As I didn't found an answer in Help Menu and FAQ, I have a question about
Calc
abilities. Am I on the right place?
Best regards,
Ognian
--
To uns
Hi :)
The normal route is to use the "bug report" approach and then use one of
the drop-downs (or the subject-line) to mark it as a "feature request".
Sometimes things do turn out to be "Easy hacks" AND attract attention from
a dev but often it takes quite a while before things do make it into mai
2013/11/2 Alan242
> After upgrading Windows 8 Pro 64-bit to Windows 8.1, Calc will open with a
> blank spreadsheet but will freeze (Not Responding) when doing a Load
> Document. The spreadsheet grid turns into a gray pane, probably system
> theme. The Menu bar (File, Edit, etc.) is at the top b
no problem.
Daniel
*De: *"Steve Edmonds"
*À: *"D. Baillard"
*Cc: *users@global.libreoffice.org
*Envoyé: *Jeudi 18 Avril 2013 19:51:40
*Objet: *Re: [libreoffice-users] Libreoffice Calc cell copy very slow
H
rg
Envoyé: Jeudi 18 Avril 2013 19:51:40
Objet: Re: [libreoffice-users] Libreoffice Calc cell copy very slow
Hi.
Near instantaneous (no noticeable lag) on my 3.6 on opensuse.
Is this occurring with cells with text and cells with formulae.
Does this happen with a sheet with only one cell with
Hi.
Near instantaneous (no noticeable lag) on my 3.6 on opensuse.
Is this occurring with cells with text and cells with formulae.
Does this happen with a sheet with only one cell with content (i.e.
worse with larger sheets).
steve
On 2013-04-19 03:11, D. Baillard wrote:
Selecting part of the c
Hi :)
Have you tried the documentation at
http://wiki.documentfoundation.org/Documentation#LibreOffice_Calc_Guide
or
http://www.libreoffice.org/get-help/documentation/
Both locations have the same documentation although the wiki sometimes gets
updated a couple of days earlier.
Regards from
Tom
Try to enter some text into the cell and while typing
chose the option from menu. While you do not edit some text
the options stay disabled (greyed)
Dne 14.10.2011 18:49, Vinod Nadiadwala napsal(a):
Hi,
I am having Libreoffice 3.4 installed on windows, i would like to
know about following
Subject: Re: [libreoffice-users] LibreOffice CALC bug: changing view of
spreadsheet not considered a "change".
You can also enable the option in Tools-Options, LibreOffice-General 'Allow to
save document even when the document is not modified'
This will prevent the Save b
You can also enable the option in Tools-Options, LibreOffice-General
'Allow to save document even when the document is not modified'
This will prevent the Save button on the toolbar being greyed
out, so you can click Save whenever you want.
cheers,
Chris
---
Hi :)
You could write it up as a wish-list item or feature request
http://wiki.documentfoundation.org/BugReport
Calc is not meant to be an exact copy of Excel but it helps to have a lot of
functionality the same.
s
is a bit of a clumsy key-combination to get at the "Save As .. " dialogue but
Hi,
On Fri, 2011-08-19 at 00:38 -0700, 10o wrote:
> In Ubuntu 11.04 I am using serveral spreadsheets that come from OpenOffice,
> which came with previous versions of Ubuntu. I recently noticed that formula
> cells are not always automatically adjusted according to changes in cells
> used in tha
On 8/10/2011 11:36 AM, Cor Nouws wrote:
JOE Conner wrote (10-08-11 20:15)
On 8/10/2011 1:06 AM, Cor Nouws wrote:
JOE Conner wrote (09-08-11 23:04)
*One thing I noticed right away - there is a serious bug when changing
orientations, in that it is difficult to keep the text within the
cell.
A
m
Tom :)
From: JOE Conner
To: users@global.libreoffice.org
Sent: Wed, 10 August, 2011 19:15:59
Subject: Re: [libreoffice-users] LibreOffice Calc: Format column titles in
DataPilot
On 8/10/2011 1:06 AM, Cor Nouws wrote:
> Hi Joe,
>
> JOE Conner wrote (09-08-11 23:04)
>
JOE Conner wrote (10-08-11 20:15)
On 8/10/2011 1:06 AM, Cor Nouws wrote:
JOE Conner wrote (09-08-11 23:04)
*One thing I noticed right away - there is a serious bug when changing
orientations, in that it is difficult to keep the text within the cell.
As I was rotating the text it would often bo
On 8/10/2011 1:06 AM, Cor Nouws wrote:
Hi Joe,
JOE Conner wrote (09-08-11 23:04)
*One thing I noticed right away - there is a serious bug when changing
orientations, in that it is difficult to keep the text within the cell.
As I was rotating the text it would often bounce into the adjoining
ce
Hi Joe,
JOE Conner wrote (09-08-11 23:04)
*One thing I noticed right away - there is a serious bug when changing
orientations, in that it is difficult to keep the text within the cell.
As I was rotating the text it would often bounce into the adjoining
cell. It seems that the text alignment fea
Hi
I suggest you this:
1) Make the pilot data
2) If you format cell orientation (cell of pilot selected), you can
chage the orientation (Vertical in grade that you want, except the first
column). If you want to change the titles of headers, select the cell
and use F2 to do it.
3) If you w
On 8/9/2011 9:13 AM, Giovanni Romero Pérez wrote:
Hello, everybody!
I used DataPilot in LibreOffice Calc, but I would like to format the column
headers. More specifically, I want to change the text orientation or these
headers.
Thank you for your help.
GIOVANNI ROMERO PÉREZ
*It seems to me th
go back to the 3.3.x branch as it is the stable
branch and 3.4.x is testing/development branch.
Regards from
Tom :)
From: planas
To: users@global.libreoffice.org
Sent: Thu, 30 June, 2011 23:24:26
Subject: Re: [libreoffice-users] LibreOffice Calc - 3.4 Final v
I tried this with LibreOffice Calc 3.4.0 (actually 3.4.0rc2) in Windows Vista
(in a Virtual PC VM on Windows 7) and links, even e-mail addresses, worked
fine. So this doesn't appear to be a general problem.
My spreadsheet had e-mail addresses typed directly into cells and recognized as
links.
On Thu, 2011-06-30 at 03:09 -0700, beta990 wrote:
> Dear LibreOffice,
>
> I have downloaded the new 3.4 Final version of the new LibreOffice.
> I'm using Ubuntu 11.04 (64-bit), everything runs, have the PPA in the
> repositories.
>
> The only problem I have is that hyperlinks on a Calc sheet are
>
>
> ____________
> From: phantom 1969
> To: users@libreoffice.org
> Sent: Sat, 14 May, 2011 0:58:26
> Subject: Re: [libreoffice-users] LibreOffice Calc - Filter text
>
> Thanks for everyone's help, but I am not trying to figure out how to sav
even without opening a
program such as a spreadsheet program.
Good luck and regards from
Tom :)
From: phantom 1969
To: users@libreoffice.org
Sent: Sat, 14 May, 2011 0:58:26
Subject: Re: [libreoffice-users] LibreOffice Calc - Filter text
Thanks for everyone'
Thank you Jean, but I figured it out. Data - Filter - Standard Filter -
Field name = "" - Condition = "Contains" - Value = "word or phrase to
filter" + OK. Then you can save the results.
On May 13, 2011 9:15 PM, "Jean Weber" wrote:
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.or
On 14/05/2011, at 9:58, phantom 1969 wrote:
> Thanks for everyone's help, but I am not trying to figure out how to save a
> document as .csv, but trying to figure out how to filter a .csv document by
> a word or phrase, and extract that data from within one document and save it
> to another. Simi
At 21:06 12/05/2011 -0700, Nobody Noname wrote:
From a .csv spreadsheet document, how would I filter text and save
the filtered items to another .csv spreadsheet document. I usually
use CSVed 2.1.4 to perform such tasks, but I would like to figure
out how to accomplish this from within LibreOff
Thanks for everyone's help, but I am not trying to figure out how to save a
document as .csv, but trying to figure out how to filter a .csv document by
a word or phrase, and extract that data from within one document and save it
to another. Similar to using "Find & Replace" to search for a word or
From: planas
To: users@libreoffice.org
Sent: Fri, 13 May, 2011 23:13:51
Subject: Re: [libreoffice-users] LibreOffice Calc - Filter text
Jean
On Sat, 2011-05-14 at 07:01 +1000, Jean Weber wrote:
> On 14/05/2011, at 2:07, jslozier wrote:
>
Jean
On Sat, 2011-05-14 at 07:01 +1000, Jean Weber wrote:
> On 14/05/2011, at 2:07, jslozier wrote:
>
> > Hi,
> >
> > On Thu, 2011-05-12 at 21:06 -0700, phantom1969 wrote:
> >
> >>> From a .csv spreadsheet document, how would I filter text and save the
> >> filtered items to another .csv spre
On 14/05/2011, at 2:07, jslozier wrote:
> Hi,
>
> On Thu, 2011-05-12 at 21:06 -0700, phantom1969 wrote:
>
>>> From a .csv spreadsheet document, how would I filter text and save the
>> filtered items to another .csv spreadsheet document. I usually use CSVed
>> 2.1.4 to perform such tasks, but I
Hi,
On Thu, 2011-05-12 at 21:06 -0700, phantom1969 wrote:
> >From a .csv spreadsheet document, how would I filter text and save the
> filtered items to another .csv spreadsheet document. I usually use CSVed
> 2.1.4 to perform such tasks, but I would like to figure out how to
> accomplish this fro
it's OK for me.thanks a lot:)
2011/1/19 Andy Brown
> On Tue Jan 18 2011 20:34:32 GMT-0800 (PST) henry cui wrote:
>
>> I input simply formulation such as "=1+2" into cell,and it only show with
>> "=1+2" which was not what I expected "3",
>> why this,anyone would like help me?
>>
>>
> Check Tool
On Tue Jan 18 2011 20:34:32 GMT-0800 (PST) henry cui wrote:
I input simply formulation such as "=1+2" into cell,and it only show with
"=1+2" which was not what I expected "3",
why this,anyone would like help me?
Check Tools-> Options-> LibreOffice Calc-> View . On the right hand
side under
henry cui wrote:
> I input simply formulation such as "=1+2" into cell,and it only show with
> "=1+2" which was not what I expected "3", why this,anyone would like help
> me?
>
I've just done this and it returns "3", as expected. The correct answer is
shown whether one just hits the Enter key
55 matches
Mail list logo