Re: [libreoffice-users] LibreOffice Calc issue

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

Re: [libreoffice-users] LibreOffice Calc issue

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

[libreoffice-users] LibreOffice Calc issue

Hi I really like LibreOffice and have had no problems until I tried to reopen a spreadsheet and I got this message: *Read Error.Format error discovered in the file in sub-document content.xml at 2,109276(row,col).* I have opened, edited and resaved this spreadsheet many times before and it's be

Re: [libreoffice-users] Libreoffice Calc Enhancement Request

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

Re: [libreoffice-users] Libreoffice Calc Enhancement Request

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

[libreoffice-users] Libreoffice Calc Enhancement Request

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 recommend it to other people as well. I use Libreoffice calc

RE: [libreoffice-users] Libreoffice Calc

> 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

RE: [libreoffice-users] Libreoffice Calc

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

Re: [libreoffice-users] Libreoffice Calc

> 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

[libreoffice-users] Libreoffice Calc

For some reason my questions are not getting posted. Hopefully the fourth attempt works. Software: LO, Version 7.3.7.2, Linux (Mint) Problem: I was asked about autocomplete for cells in Calc. My response was to use a list of cells in Validity. Unfortunately, only a vertical scroll bar is avail

Re: [libreoffice-users] Libreoffice Calc

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

[libreoffice-users] Libreoffice Calc

Hi,  where possible I would need your help. I have recently been using Libreoffice and in particular Calc. However, I have a small problem that I would like to solve. When the spreadsheet is clean, i.e. new, I can quickly locate which is the active cell where I am going to write but when the s

[libreoffice-users] Libreoffice calc problem

Folks: When I copy a cell to another cell that has a comment in it, the cell data is copied, but it retains the comment from original cell contents Didn't do that before. Just started doing this when I upgraded to libreoffice 7.6.6.3. Please help. tks, Dennis. -- This email has been c

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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 -

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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? >

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

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

[libreoffice-users] LibreOffice Calc - Date - increase number times...

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 the persons doing the reaction) B - No, formatted number g

[libreoffice-users] libreoffice calc advice

New to spreadsheets and LibreOffice and am wondering what is the best way to take data from certain cells on one spreadsheet and put them on a second spreadsheet in a report format.  I should say that spreadsheet 1 will be an invoice template and is used to create new invoices, while spreadsheet

[libreoffice-users] LibreOffice Calc vs MsOffice Excel

Hi, My Office 2007 is no longer supported, so they killed the help function. A good moment to take the plunge and switch to LibreOffice. I have that installed for years, but never really switched due to the multiple small differences in behaviour. Most obvious is the difference in absolute ce

[libreoffice-users] LibreOffice Calc vs MsOffice Excel

Hi, My Office 2007 is no longer supported, so they killed the help function. A good moment to take the plunge and switch to LibreOffice. I have that installed for years, but never really switched due to the multiple small differences in behaviour. Most obvious is the difference in absolute ce

Re: [libreoffice-users] LibreOffice Calc column shifting

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.

Re: [libreoffice-users] LibreOffice Calc column shifting

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

[libreoffice-users] LibreOffice Calc column shifting

Hi All, I am using LibreOffice version 5.4.6.2 (x64) on a Windows 7 computer.  I am getting column shifting, playing with the Option/LibreOffice/View parameters have not helped.  See the example attached. LibreOffice Calc column shift

Re: [libreoffice-users] LibreOffice Calc Insert Note Missing Function

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

[libreoffice-users] LibreOffice Calc Insert Note Missing Function

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 been moved? -- ***

Re: [libreoffice-users] LibreOffice Calc Question

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

[libreoffice-users] LibreOffice Calc Question

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 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsub

[libreoffice-users] LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

Anomaly discovered in *versions 4.2.8 and 4.4.6* - VLOOKUP function Good morning, . LibreOfficeCalc use on a package of administration that contains many features that interact with Pivot Tables A very used is VLOOKUP. The package works very well and there are no problems on the LO version 4.0.6

[libreoffice-users] LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

Anomaly discovered in *versions 4.2.8 and 4.4.6* - VLOOKUP function Good morning, . LibreOfficeCalc use on a package of administration that contains many features that interact with Pivot Tables A very used is VLOOKUP. The package works very well and there are no problems on the LO version 4.0.6

Re: [libreoffice-users] LibreOffice Calc

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

[libreoffice-users] LibreOffice Calc

Hello! Not found at what e-mail you can send your suggestions for improving LibreOffice, poet writing to You. If You do not forward my message to the right address. In LibreOffice Calc-AutoFilter is not possible to expand the window frame with a choice of filters (not visible if the long name) an

Re: [libreoffice-users] LibreOffice Calc fails to load spreadsheets after upgrade to Windows 8.1

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

[libreoffice-users] LibreOffice Calc fails to load spreadsheets after upgrade to Windows 8.1

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 but unresponsive. The Status

Re: [libreoffice-users] Libreoffice Calc cell copy very slow

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

Re: [libreoffice-users] Libreoffice Calc cell copy very slow

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

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 content (i.e. worse with larger sheets). steve On 2013-04-19 03:11, D. Baillard wrote: Selecting part of the c

[libreoffice-users] Libreoffice Calc cell copy very slow

Selecting part of the content in a cell and press Ctrl-C is very slow (eg. selecting part of a formula or just two words from a text). It takes about 5 seconds for the UI to give back control to the user. There is no slowness during pasting to another cell (or adding to the content of a cell) The

[libreoffice-users] LibreOffice Calc freezes when copy pasting data in spreadsheet

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, How many people experience this problem: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=50464 And of course what can we do about it? This problem is quite persistent in my experience on different systems and on IRC I saw more people co

[libreoffice-users] LibreOffice Calc: Update External Link Question

I have a series of spreadsheets with external links to other spreadsheets. The link will not update unless the spreadsheet the link references is open. Is that the expected/desired response of the developers? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Proble

Re: [libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?

Tom :) --- On Fri, 14/10/11, Vinod Nadiadwala wrote: From: Vinod Nadiadwala Subject: [libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ? To: "users" Date: Friday, 14 October, 2011, 17:49 Hi,     I am having Libre

Re: [libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?

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

[libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?

Hi, I am having Libreoffice 3.4 installed on windows, i would like to know about following Calc menu's CALC : : 1) Insert - Formatting Mark 2) Format - Control 3) Format - Form I have checked Calc documentation and calc online help but didn't found much information about the same, i am lea

RE: [libreoffice-users] LibreOffice CALC bug: changing view of spreadsheet not considered a "change".

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

Re: [libreoffice-users] LibreOffice CALC bug: changing view of spreadsheet not considered a "change".

possible to sort out soemthign simpler. Regards from Tom :) --- On Thu, 15/9/11, Hampson, Alex wrote: From: Hampson, Alex Subject: [libreoffice-users] LibreOffice CALC bug: changing view of spreadsheet not considered a "change". To: "users@global.libreoffice.org" Date: Thursday

Re: [libreoffice-users] LibreOffice CALC bug: changing view of spreadsheet not considered a "change".

alogue but it might be possible to sort out soemthign simpler. Regards from Tom :) --- On Thu, 15/9/11, Hampson, Alex wrote: From: Hampson, Alex Subject: [libreoffice-users] LibreOffice CALC bug: changing view of spreadsheet not considered a "change". To: "users@global.libreof

[libreoffice-users] LibreOffice CALC bug: changing view of spreadsheet not considered a "change".

LibreOffice (and it's predecessor OpenOffice) have a behaviour that is different to that of Microsoft Office: If you have a spreadsheet that you have made changes to and save you work (using SAVE) and then change your view by scrolling and/or changing the current cell, this is not considered by

Re: [libreoffice-users] LibreOffice Calc, serious problem/bug in formulas when adjusting cells used

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

[libreoffice-users] LibreOffice Calc, serious problem/bug in formulas when adjusting cells used

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 that formula. When I even notice inconstant behaviour, I have to

Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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

Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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) >

Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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

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) *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

Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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

Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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

Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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

[libreoffice-users] LibreOffice Calc: Format column titles in DataPilot

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 -- For unsubscribe instructions e-mail to: users+h...@global.lib

Re: [libreoffice-users] LibreOffice Calc - 3.4 Final version can not open (hyper)links anymore

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

RE: [libreoffice-users] LibreOffice Calc - 3.4 Final version can not open (hyper)links anymore

users@global.libreoffice.org Subject: [libreoffice-users] LibreOffice Calc - 3.4 Final version can not open (hyper)links anymore 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 prob

Re: [libreoffice-users] LibreOffice Calc - 3.4 Final version can not open (hyper)links anymore

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

[libreoffice-users] LibreOffice Calc - 3.4 Final version can not open (hyper)links anymore

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 not working anymore. I can click on them, but FireFox does not

Re: [libreoffice-users] LibreOffice Calc - Filter text

> > > ________ > 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

Fw: [libreoffice-users] LibreOffice Calc - Filter text

k and regards from Tom :) - Forwarded Message From: Tom Davies To: users@libreoffice.org Sent: Sat, 14 May, 2011 6:48:29 Subject: Re: [libreoffice-users] LibreOffice Calc - Filter text Hi :) Which Operating System are you using; Windows, Ubuntu, another linux distro, Bsd or Mac? For th

Re: [libreoffice-users] LibreOffice Calc - Filter text

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'

Re: [libreoffice-users] LibreOffice Calc - Filter text

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

Re: [libreoffice-users] LibreOffice Calc - Filter text

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

Re: [libreoffice-users] LibreOffice Calc - Filter text

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

Re: [libreoffice-users] LibreOffice Calc - Filter text

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

Re: [libreoffice-users] LibreOffice Calc - Filter text

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: >

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: > > > 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

Re: [libreoffice-users] LibreOffice Calc - Filter text

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

Re: [libreoffice-users] LibreOffice Calc - Filter text

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

[libreoffice-users] LibreOffice Calc - Filter text

>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 LibreOffice Calc. Thanks in advance. -- View this message

[libreoffice-users] LibreOffice Calc - poor VBA support!!

Some of my calc sheets witch work fine with OpenOffice 3.2.1 - DONT'T work with LibreOffice 3.3.0. I' think the have older oder other VBA - API's included as Openoffice. But I will keep hold of LibreOffice - so I hope for a early update! with regards 4logon. -- View this message in context: htt

Re: [libreoffice-users] libreoffice calc can't do simply calculation

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

Re: [libreoffice-users] libreoffice calc can't do simply calculation

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

Re: [libreoffice-users] libreoffice calc can't do simply calculation

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

[libreoffice-users] libreoffice calc can't do simply calculation

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? -- best, henry cui -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/use