Re: Excel formula tool tip suggestion to match Microsoft's feature

2024-03-11 Thread David
Steve Greaves wrote: Hi, team. When building a formula in Excel, the tool tip does not go *BOLD,* as you type, unlike Microsoft's Excel. May I suggest that this could be developed in a newer version? Examples below: Microsoft's has the BOLD type to help... Developers don&#x

Excel formula tool tip suggestion to match Microsoft's feature

2024-03-10 Thread Steve Greaves
Hi, team. When building a formula in Excel, the tool tip does not go BOLD, as you type, unlike Microsoft's Excel. May I suggest that this could be developed in a newer version? Examples below: Microsoft's has the BOLD type to help...

Re: excel

2023-02-14 Thread Johnny Rosenberg
Den tis 14 feb. 2023 kl 07:04 skrev Richard Rik : > Do you offer a free excel with apache? No, I don't. Neither does Apache. So what do Apache offer? Free spreadsheet app – yes (called ”Calc”). Free Excel – no, only Microsoft can offer such a thing since it's their product, so a

Re: excel

2023-02-13 Thread David Robley
answers to your mail. As a courtesy I have sent a copy of my reply to you; please Do Not respond to me, but to the mailing list. to you On 14/02/2023 13:19, Richard Rik wrote: Do you offer a free excel with apache?  If so have a question or two.

excel

2023-02-13 Thread Richard Rik
Do you offer a free excel with apache?  If so have a question or two. thank you

Re: Opening an excel file that is password protected

2022-06-13 Thread Maurice Howe
avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Mon, Jun 13, 2022 at 5:03 PM John Jay wrote: > Is there a way to open an excel file that has been password protecte

Re: Opening an excel file that is password protected

2022-06-13 Thread Maurice Howe
avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Mon, Jun 13, 2022 at 5:03 PM John Jay wrote: > Is there a way to open an excel file that has been password protecte

Opening an excel file that is password protected

2022-06-13 Thread John Jay
Is there a way to open an excel file that has been password protected. I no longer have Excel so I can't remove the password that way. When I try to open the file in Spreadsheet it opens up a filter selection box. I have chosen several of the excel formats but nothing seems to work. T

OpenOffice vs Microsoft Excel and Word

2021-10-08 Thread ROBERT KNIGHT
Customer Service/Tech Support: I am currently using (on a Mac) Microsoft Excel and Word, for all of my data and records. Will OpenOffice allow me to migrate or transfer (accurately) data and info from Excel & Word to OpenOffice? Thanks, Bob 630-975-4212

Re: Excel equivalent

2021-05-03 Thread Girvin Herr
cells - when OpenOffice will offer to combine the contents and even helpfully interpose a blank character - and then immediately unmerge them. The combined text ends up in the first cell. Of course you can achieve the same result in Microsoft Excel, but not (I believe) in the same way or indeed any

Re: Excel equivalent

2021-05-03 Thread Brian Barker
At 14:41 03/05/2021 +0100, Robin Lord wrote: I don't agree open office calc is pretty much identical to excel, ... All spreadsheet programs are similar, of course: they simply have to be. Is that what you mean by "pretty much identical"? My point was not to suggest that OpenOf

Re: Excel equivalent

2021-05-03 Thread Robin Lord
I don't agree open office calc is pretty much identical to excel, before I retired the only major difference I found was the number of rows in excel was much bigger, and even that may have changed in the 10 years since, I never now need to have millions of rows in a spreadsheet. Even when

Re: Excel equivalent

2021-05-03 Thread Brian Barker
At 13:09 03/05/2021 +0100, Brian Barnard wrote: Subject: Excel equivalent It is a mistake to think that any software product is the equivalent of any other. OpenOffice's spreadsheet function ("Calc") is not offered as an equivalent of Microsoft Excel. It would be equall

Re: Excel equivalent

2021-05-03 Thread Joost Andrae
Hi Brian, a literal is a text. If you want to replace a number which is formatted as text by having a single quote as the first character then you can start the replace string with a single qoute ' to leave it as a literal. Alternatively you can format this number string as text (menu item f

Excel equivalent

2021-05-03 Thread Brian Barnard
In your spreadsheet handler I recently tried to edit a column of literals (all numeric) but your find and replace would not replace the characters that I entered with the new ones. In the same column were alphabetic literals and I could replace these with no problem. As a result of this I have ha

Re: Open Office Excel

2020-08-26 Thread Shari Lynn Smith
27;t make a difference. > > > > Shari > > > > On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote: > > > >> Hi, > >> > >> One of my Open Office Excel files is not opening. My other files are > >> opening fine. It is a very big file with a list of

Re: Open Office Excel

2020-08-26 Thread Andrew Pitonyak
lso shouldn't make a difference. >> >> Shari >> >> On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote: >> >>> Hi, >>> >>> One of my Open Office Excel files is not opening. My other files are >>> opening fine. It is a very big f

Re: Open Office Excel

2020-08-25 Thread mermaidlady
ocuments file extension? I'm How large is the file? If you cannot do it, I might be able to convert it to an ods (calc) file for you. That said, excel may be able to write an ods file directly. It is better, of course, if you do it yourself. If AOO cannot do it, I might try LO (LibreOffic

Re: Open Office Excel

2020-08-25 Thread mermaidlady
ny error message? The size shouldn't effect it's ability unless you have hundreds of sheets. Emails also shouldn't make a difference. Shari On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote: Hi, One of my Open Office Excel files is not opening. My other files are opening fine. It

Re: Open Office Excel

2020-08-25 Thread Andrew Pitonyak
What is the documents file extension? I'm How large is the file? If you cannot do it, I might be able to convert it to an ods (calc) file for you. That said, excel may be able to write an ods file directly. It is better, of course, if you do it yourself. If AOO cannot do it, I might t

Re: Open Office Excel

2020-08-25 Thread Web Shari
Are you receiving any error message? The size shouldn't effect it's ability unless you have hundreds of sheets. Emails also shouldn't make a difference. Shari On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote: Hi, One of my Open Office Excel files is not opening. My other fi

Re: Open Office Excel

2020-08-23 Thread mermaidlady
make an account and log on. Sent from my iPhone On Aug 23, 2020, at 12:12 PM, mermaidl...@gwi.net wrote: Hi, One of my Open Office Excel files is not opening. My other files are opening fine. It is a very big file with a list of emails. I wonder if the links are too heavy or complex? Not tha

Re: Open Office Excel

2020-08-23 Thread Steven Ahlers
Joelle, Do you mean an OpenOffice Calc file? If you do mean a M$ Excel file you will need to go to a Microsoft help site. Assuming it is a Calc file there are some pieces of information that would help us help you. 1) Do you get an error message when you try to open the file you’re having

Open Office Excel

2020-08-23 Thread mermaidlady
Hi, One of my Open Office Excel files is not opening. My other files are opening fine. It is a very big file with a list of emails. I wonder if the links are too heavy or complex? Not that I really know what I am talking about. Is there anything I can do to retrieve my data? All best, Joelle

Re: Calc: How to graph polynomial trend line like Excel?

2020-04-14 Thread Regina Henschel
Hi Mike, helices schrieb am 13-Apr-20 um 18:51: How can we create more complex trend lines in Calc, like the Polynomial line in Excel? Polynomial regression type is not implemented. You need to calculate it outside the chart and then add it as data series. You might want to use an

Re: Calc: How to graph polynomial trend line like Excel?

2020-04-14 Thread Peter Kovacs
Mike, I checked to day Excel 2016 and the main difference is that OpenOffice does not have a + Symbol. Okay, maybe when you have the Graph selected, then you need to double click, to be able to manipulate the Graph itself. And then you can select the line you want to add the trend line

Re: Calc: How to graph polynomial trend line like Excel?

2020-04-13 Thread Peter Kovacs
13.04.20 um 18:51 schrieb helices: How can we create more complex trend lines in Calc, like the Polynomial line in Excel? ~ Mike - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail

Calc: How to graph polynomial trend line like Excel?

2020-04-13 Thread helices
How can we create more complex trend lines in Calc, like the Polynomial line in Excel? ~ Mike

Re: Sharing Excel

2020-01-23 Thread Peter Kovacs
times... Please take me off this mailing!! On Fri, Jan 17, 2020, 3:28 PM Sarah Staddon wrote: Hello My son lives away and we are trying to share an excel spreadsheet to work together on a diary fitness and dieting. Can you please tell me how to do this? Many thanks Sarah Staddon

Re: Sharing Excel

2020-01-23 Thread Mord.Sith Jenn
I have unsubscribe 25 damn times... Please take me off this mailing!! On Fri, Jan 17, 2020, 3:28 PM Sarah Staddon wrote: > Hello > My son lives away and we are trying to share an excel spreadsheet to work > together on a diary fitness and dieting. > Can you please tell me how to do

Re: Sharing Excel

2020-01-18 Thread Mark Wolf
n because you wrote "share a file" which I'm thinking >> means you both want to work with the same file so you can see each other's >> progress. >> >> If that's not your goal then Wade's suggestion is certainly the simpler >> option. >>

Re: Sharing Excel

2020-01-18 Thread Sarah Staddon
nt to work with the same file so you can see each other's > progress. > > If that's not your goal then Wade's suggestion is certainly the simpler > option. > >> On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon >> wrote: >> >> Hello >> My son

Re: Sharing Excel

2020-01-17 Thread Steven Ahlers
e simpler > option. > >> On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon >> wrote: >> >> Hello >> My son lives away and we are trying to share an excel spreadsheet to work >> together on a diary fitness and dieting. >> Can you p

Re: Sharing Excel

2020-01-17 Thread Alan B
#x27;s progress. If that's not your goal then Wade's suggestion is certainly the simpler option. On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon wrote: > Hello > My son lives away and we are trying to share an excel spreadsheet to work > together on a diary fitness and dieting.

Re: Sharing Excel

2020-01-17 Thread Wade Smart
Sarah, just have him email it to you and you will open it. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Jan 17, 2020 at 3:28 PM Sarah Staddon wrote: > > Hello > My son lives away and we are trying to share an excel spreadshee

Sharing Excel

2020-01-17 Thread Sarah Staddon
Hello My son lives away and we are trying to share an excel spreadsheet to work together on a diary fitness and dieting. Can you please tell me how to do this? Many thanks Sarah Staddon

Opening Excel with images on Open Office 4.1.6

2019-08-28 Thread Renata Souto Neves
Hi there, I’m a user of Open Office 4.1.6 and I’m having problems opening xls files with inserted images. When I open any type of Excel file with Open Office on Windows, I see the images like this: https://prnt.sc/oyn5fl <https://prnt.sc/oyn5fl> And in the original file the images ar

Re: Issue with the excel sheet

2019-05-24 Thread Brian Barker
ill require learning in order to use it fully. >For the last 2/3 years I find some issues while using the spreadsheet [excel >sheet] to file my I T returns. I don't know what an "IT return" is: is this Indian for an income tax return? >The IT return form consist of  4

Issue with the excel sheet

2019-05-24 Thread prabir chakrabarti
Dear Sir I have been using " openoffice "  for a few years now & find it very useful for most my works. It is true though that I still need to explore  it thoroughly to use all features correctly. For the last 2/3 years I find some issues while using the spreadsheet [excel she

Re: TOO MANY CRASHES, I GIVE UP AFTER MANY YEARS OF SATIFACTION I'M GOING BACK TO EXCEL

2018-11-07 Thread Wade Smart
Why cant this list block non-registered users? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Wed, Nov 7, 2018 at 2:51 PM pat mcnamara wrote: > > > > Sent from Mail for Windows 10 > --

Re: TOO MANY CRASHES, I GIVE UP AFTER MANY YEARS OF SATIFACTION I'M GOING BACK TO EXCEL

2018-11-07 Thread Howard Blum
It's likely a Windows issue and not an OO issue. On Wed, Nov 7, 2018 at 12:51 PM pat mcnamara < outlook_d120253acf079...@outlook.com> wrote: > > > Sent from Mail for > Windows 10 > > -- Howard Blum Pro Mobile Notary PO Box 834 Novato, CA 94948 415

TOO MANY CRASHES, I GIVE UP AFTER MANY YEARS OF SATIFACTION I'M GOING BACK TO EXCEL

2018-11-07 Thread pat mcnamara
Sent from Mail for Windows 10

Re: Excel

2018-08-10 Thread David Belina
Excel for an iPad requires a subscription to Microsoft Office 360. On August 10, 2018 at 9:45:12 AM, Matthias Seidel (matthias.sei...@hamburg.de) wrote: Am 10.08.2018 um 15:52 schrieb Andrew Pitonyak: > > > > > My assumption is that you are not really asking how t

Re: Excel

2018-08-10 Thread Matthias Seidel
Am 10.08.2018 um 15:52 schrieb Andrew Pitonyak: > > > > > My assumption is that you are not really asking how to install Excel, > since that is a Microsoft product and this is a mailing list for > OpenOffice products... I assume, therefore, that you desire to install > Ap

Re: Excel

2018-08-10 Thread Andrew Pitonyak
My assumption is that you are not really asking how to install Excel, since that is a Microsoft product and this is a mailing list for OpenOffice products... I assume, therefore, that you desire to install Apache OpenOffice and that you desire to use Calc. The only answer as of now

Re: Excel

2018-08-10 Thread David Robley
This mail list is for support for Apache OpenOffice. A quick web search suggests there is a version of Excel for IPad; perhaps look on the App Store. On 10/08/18 11:22, Michael Lass wrote: Sent from my iPad Please help me get Excel hooked up to my I pad or is this possible? Thank you

Excel

2018-08-10 Thread Michael Lass
Sent from my iPad Please help me get Excel hooked up to my I pad or is this possible? Thank you very much ! - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h

Re: adding up columns in excel

2018-04-03 Thread LTS Tools, Inc
Inc wrote: > Hello, > > I am trying to download an excel spread sheet from ebay. Every time I do, the > column with prices has an apostrophe before the number so I cannot add up the > columns. My older version didn't do this. Please help! If you download a Excel file that the

Re: adding up columns in excel

2018-04-02 Thread Brian Barker
At 10:04 02/04/2018 -0400, Carol Noname wrote: adding up columns in excel If you are adding up columns in Microsoft Excel, you may need to look elsewhere for help. Perhaps you mean in an OpenOffice spreadsheet? I am trying to download an excel spread sheet from ebay. Every time I do, the

Re: adding up columns in excel

2018-04-02 Thread Martin Groenescheij
On 03/04/18 12:04 AM, LTS Tools, Inc wrote: Hello, I am trying to download an excel spread sheet from ebay. Every time I do, the column with prices has an apostrophe before the number so I cannot add up the columns. My older version didn't do this. Please help! If you download a

adding up columns in excel

2018-04-02 Thread LTS Tools, Inc
Hello,   I am trying to download an excel spread sheet from ebay. Every time I do, the column with prices has an apostrophe before the number so I cannot add up the columns. My older version didn't do this. Please help!   Thank you, Carol LTS Tools, Inc 40 Conway St South Deerfield, Ma 0137

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-09-09 Thread Johnny Rosenberg
be for you. > > On 7/1/17, Johnny Rosenberg wrote: > > 2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora : > > > >> Hi there, > >> > >> I am a new user to OpenOffice and was wondering if when I write lets say > >> a > >> spreadsheet with macr

Re: Help OpenOffice is Taking Half an Hour to Load Excel Files?????????

2017-09-08 Thread zahra a
os that were originally written in Excel to open onto OpenOffice. > However, it is taking about half an hour to load just one file, so I am > wondering why it is taking so long as well as how I can fix it. > > > Thanks > > Emma Parola > -- we have not sent you but as a mercy to

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-09-08 Thread zahra a
>> >> I am a new user to OpenOffice and was wondering if when I write lets say >> a >> spreadsheet with macros on it and sent to someone who would have to open >> that file in Excel cause they don't use OpenOffice, would the macros >> still >> work

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-06-30 Thread Johnny Rosenberg
2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora : > Hi there, > > I am a new user to OpenOffice and was wondering if when I write lets say a > spreadsheet with macros on it and sent to someone who would have to open > that file in Excel cause they don't use OpenOffice, would the ma

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-06-29 Thread Rory O'Farrell
On Thu, 29 Jun 2017 19:55:55 + QCIT3 MMisonora wrote: > Hi there, > > I am a new user to OpenOffice and was wondering if when I write lets say a > spreadsheet with macros on it and sent to someone who would have to open that > file in Excel cause they don't use O

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-06-29 Thread Andrew Pitonyak
On 2017-06-29 15:55, QCIT3 MMisonora wrote: Hi there, I am a new user to OpenOffice and was wondering if when I write lets say a spreadsheet with macros on it and sent to someone who would have to open that file in Excel cause they don't use OpenOffice, would the macros still work or wou

Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-06-29 Thread QCIT3 MMisonora
Hi there, I am a new user to OpenOffice and was wondering if when I write lets say a spreadsheet with macros on it and sent to someone who would have to open that file in Excel cause they don't use OpenOffice, would the macros still work or would it not work like when one opens an Excel

Help OpenOffice is Taking Half an Hour to Load Excel Files?????????

2017-06-29 Thread QCIT3 MMisonora
Hi there, I am a new user to OpenOffice and am trying to get some files with VBA macros that were originally written in Excel to open onto OpenOffice. However, it is taking about half an hour to load just one file, so I am wondering why it is taking so long as well as how I can fix it

Re: Downloading EXCEL files into Open Office

2016-07-12 Thread Johnny Rosenberg
2016-07-11 22:08 GMT+02:00 Mark Wallendjack : > When download EXCEL files, they don't recognize my Open Office spreadsheet > program. Spreadsheet files don't recognise anything, they are just files. Apache OpenOffice however, recognise certain file types, Excel files are among

Re: Downloading EXCEL files into Open Office

2016-07-11 Thread Rory O'Farrell
On Mon, 11 Jul 2016 20:08:44 + Mark Wallendjack wrote: > When download EXCEL files, they don't recognize my Open Office spreadsheet > program. Is there a way to do that? I certainly don't want to buy Microsoft > Office for the privilege! > > > Tha

Downloading EXCEL files into Open Office

2016-07-11 Thread Mark Wallendjack
When download EXCEL files, they don't recognize my Open Office spreadsheet program. Is there a way to do that? I certainly don't want to buy Microsoft Office for the privilege! Thanks - a new Open office user. Mark

Excel to open office problem

2016-03-18 Thread Adrian Ban
Hello I have a problem where I have a file in excel on the PC and I'm opening in open office on mac. On the PC excel there are drop down menus for certain blocks, but when I open it in OpenOffice spreadsheet on mac, there are no drop down menus. What do I do to get that to work? Than

Re: Macro compatibility to Excel

2015-10-08 Thread Johnny Rosenberg
2015-10-08 11:50 GMT+02:00 Adam AUTUORI : > Hello. I want to code an ods macro into OpenOffice to make my work easier > at my bakery. > > Is the OpenOffice Basic dialect would be compatible to Excel to assure > portability to any calc application ? Thanks a lot Well, I thin

Re: Macro compatibility to Excel

2015-10-08 Thread Rory O'Farrell
dam AUTUORI wrote: > > > Hello. I want to code an ods macro into OpenOffice to make my work easier > > at my bakery. > > > > Is the OpenOffice Basic dialect would be compatible to Excel to assure > > portability to any calc application ? Thanks a lot &g

Re: Macro compatibility to Excel

2015-10-08 Thread Rory O'Farrell
On Thu, 8 Oct 2015 09:50:18 + Adam AUTUORI wrote: > Hello. I want to code an ods macro into OpenOffice to make my work easier at > my bakery. > > Is the OpenOffice Basic dialect would be compatible to Excel to assure > portability to any calc application ? Thanks a lot !!

Macro compatibility to Excel

2015-10-08 Thread Adam AUTUORI
Hello. I want to code an ods macro into OpenOffice to make my work easier at my bakery. Is the OpenOffice Basic dialect would be compatible to Excel to assure portability to any calc application ? Thanks a lot

Excel problem

2015-05-29 Thread ALINGA 2
Hello, I found a mistake. See file in the attachment. BR Algis Susikniso open office Excel.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For addi

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Manuel Andres Ramirez
El 19/02/15 a las 11:18, Brian Barker escribió: At 10:53 19/02/2015 -0500, Manuel Andres Ramirez wrote: Searching a little deep. I Found that you can use [:cntrl:] in search box, to erase all non printable characters. Doesn't matter if the pattern change. Maybe this is the easy way to solution

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Brian Barker
At 10:53 19/02/2015 -0500, Manuel Andres Ramirez wrote: Searching a little deep. I Found that you can use [:cntrl:] in search box, to erase all non printable characters. Doesn't matter if the pattern change. Maybe this is the easy way to solution Uwe's problem. Nice idea. This removes the line

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Manuel Andres Ramirez
El 19/02/15 a las 05:28, Uwe Brauer escribió: deletes that value to are trying to recover, it suggests that you want > the value in C2 to be a CLEANed version of the value in C2 - > which is a CLEANed version of what is in C2! The formula refers back > to itself repeatedly, and the ca

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Brian Barker
At 11:28 19/02/2015 +0100, Uwe Brauer wrote: By the way, when I perform this operations for one cell say C2 and then want to enhance it to the whole column, it seems that I can only do it by dragging the boundary of the cells with the mouse. Is this correct? No. Dragging the fill handle (not

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Uwe Brauer
> "Brian" == Brian Barker writes: > At 18:29 18/02/2015 +0100, Uwe Brauer wrote: >> I run for example clean(C2) and it returns Err:522. C is the column with the problems > That means that your formula is circular. I'm guessing that you have > tried putting =CLEAN(C2) into C2 its

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Manuel Andres Ramirez
El 18/02/15 a las 12:56, Brian Barker escribió: At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 10:06, Brian Barker escribió: At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 06:00, Uwe Brauer escribió: I periodically receive excel files

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Brian Barker
At 18:29 18/02/2015 +0100, Uwe Brauer wrote: I run for example clean(C2) and it returns Err:522. C is the column with the problems That means that your formula is circular. I'm guessing that you have tried putting =CLEAN(C2) into C2 itself. Apart from the fact that this deletes that value to

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Brian Barker
At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 10:06, Brian Barker escribió: At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 06:00, Uwe Brauer escribió: I periodically receive excel files (generated by Office 2010 I think, but saved in the

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Uwe Brauer
>> "Manuel" == Manuel Andres Ramirez writes: > El 17/02/15 a las 10:06, Brian Barker escribió: >> At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: >> El 17/02/15 a las 06:00, Uwe Brauer escribió: >>>> I periodically receive excel file

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Manuel Andres Ramirez
El 17/02/15 a las 10:06, Brian Barker escribió: At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 06:00, Uwe Brauer escribió: I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Andrew Pitonyak
t; >El 17/02/15 a las 06:00, Uwe Brauer escribió: > >>I periodically receive excel files (generated > >>by Office 2010 I think, but saved in the old > >>binary format). Some of these columns cause me > >>problems, since they seem to contain spaces and

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Brian Barker
At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: El 17/02/15 a las 06:00, Uwe Brauer escribió: I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Manuel Andres Ramirez
El 17/02/15 a las 06:00, Uwe Brauer escribió: Hello I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even newlines. I could correct that manually, but since

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Brian Barker
At 12:00 17/02/2015 +0100, Uwe Brauer wrote: I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even newlines. I could correct that manually, but since the

problem with import of excel file, cells contain new lines

2015-02-17 Thread Uwe Brauer
Hello I periodically receive excel files (generated by Office 2010 I think, but saved in the old binary format). Some of these columns cause me problems, since they seem to contain spaces and even newlines. I could correct that manually, but since the file contains hundred of lines this is

Re: How to open Microsoft Excel files.

2015-02-03 Thread Martin Groenescheij
r go to File --> New --> Spreadsheet -Original Message- From: Dave Barton To: users Cc: JEAN LEGAULT Sent: Tue, Feb 3, 2015 1:28 pm Subject: Re: How to open Microsoft Excel files. Original Message From: JEAN L

Re: How to open Microsoft Excel files.

2015-02-03 Thread JEAN LEGAULT
-- From: Dave Barton To: users Cc: JEAN LEGAULT Sent: Tue, Feb 3, 2015 1:28 pm Subject: Re: How to open Microsoft Excel files. Original Message From: JEAN LEGAULT To: users@openoffice.apache.org Date: Tue, 3 Feb 2015 16:29:

Re: How to open Microsoft Excel files.

2015-02-03 Thread Dave Barton
nd create documents. > Thanks for your help > > Jean Legault Jean, It is not good practice to cram the entire contents of an email into the subject line. To create new spreadsheets (what you describe as "Excel documents") simply start the Calc program, enter whatever data and formul

"OpenOffice 4.1.1" could not use Compute( calculate) Functions( excel document(試算表))(Oct Ke(葛鴻安))

2014-11-28 Thread octke
Dear All, I have installed "OpenOffice 4.1.1", but the All of the Compute( calculate) Functions( excel document(試算表)) could not use(and please refer the attachment), and could you help me for solution, thanks! Best Regards! 葛鴻安(Oct Ke) Cellular Phone No.: 0922876173 ( Taiwan) 台灣

"OpenOffice 4.1.1" could not use Compute( calculate) Functions( excel document(試算表))(Oct Ke(葛鴻安))

2014-11-28 Thread octke
Dear All, I have installed "OpenOffice 4.1.1", but the All of the Compute( calculate) Functions( excel document(試算表)) could not use(and please refer the attachment), and could you help me for solution, thanks! Best Regards! 葛鴻安(Oct Ke) Cellular Phone No.: 0922876173 ( Taiwan) 台灣

Re: Excel

2014-11-23 Thread mt
Hello Ingrid, On 21/11/14 at 8:10 PM, ing...@superiortrvl.com (Ingrid Ream) wrote: Good afternoon, I have the most current version of openoffice.org 4.1 and can not open an excel document. Is there something additional that I need to do so I can open the document? or does this version not

Excel

2014-11-21 Thread Ingrid Ream
Good afternoon, I have the most current version of openoffice.org 4.1 and can not open an excel document. Is there something additional that I need to do so I can open the document? or does this version not support opening the docs in excel? I am using windows 8.1 if that makes a difference

Re: Scrolling within excel spreadsheets.

2014-06-11 Thread 許哲崇
Just fun: If shifting from socialism to capitalism mean something to you, pay good attention. 2014-06-11 2:31 GMT+08:00 johnny smith : > On Tue, 10 Jun 2014 17:54:06 -, Simon Harrison < > simonharrison...@gmail.com> wrote: > > For some reason since the last update when scrolling left or ri

Re: Scrolling within excel spreadsheets.

2014-06-10 Thread johnny smith
On Tue, 10 Jun 2014 17:54:06 -, Simon Harrison wrote: For some reason since the last update when scrolling left or right within spread sheet pages the screen only ever moves to the right. Not sure if this is a bug in the program or a glitch in my mouse. it is a bug. more information h

Scrolling within excel spreadsheets.

2014-06-10 Thread Simon Harrison
Hello, For some reason since the last update when scrolling left or right within spread sheet pages the screen only ever moves to the right. Not sure if this is a bug in the program or a glitch in my mouse. I'm running a Mac with OSX 10.7.5 and a mighty mouse. Simon Follow me on Facebook and

Re: need help with excel file

2014-04-29 Thread Julian Thomas
On 28 Apr 2014, at 00:16, Brian Barker wrote: > I'm reasonably sure that you cannot do this: OpenOffice sees background > colour as formatting information and not data - so you cannot use it in > processes. I agree. Fortunately excel has the capability to sort on this and I

Re: need help with excel file

2014-04-28 Thread johnny smith
On Mon, 28 Apr 2014 03:20:36 -, Julian Thomas wrote: I have an excel file (names and addresses) where the previous user(s) have marked the processed row items by coloring the entries yellow. Is there an easy way to select these rows to delete them and get a file with only entries

Re: need help with excel file

2014-04-28 Thread d a n i e l h u c h e r o t
t; I have an excel file (names and addresses) where the previous user(s) >> have marked the processed row items by coloring the entries yellow. Is >> there an easy way to select these rows to delete them and get a file >> with only entries needing processing? > > I'm r

Re: need help with excel file

2014-04-27 Thread Brian Barker
At 23:20 27/04/2014 -0400, Julian Thomas wrote: I have an excel file (names and addresses) where the previous user(s) have marked the processed row items by coloring the entries yellow. Is there an easy way to select these rows to delete them and get a file with only entries needing processing

need help with excel file

2014-04-27 Thread Julian Thomas
I have an excel file (names and addresses) where the previous user(s) have marked the processed row items by coloring the entries yellow. Is there an easy way to select these rows to delete them and get a file with only entries needing processing? Conversely, if I save in excel as CSV, is

Re: Open Office Org & Excel Question

2014-04-06 Thread Julian Thomas
On 6 Apr 2014, at 00:38, Martin Groenescheij wrote: >> In Open Office Org you have a program that looks like and indeed does >> exactly the same thing as Excel. >> So would I be able to do the tasks in the Excel Intermediate and Advanced >> books on the Open Office

Re: Open Office Org & Excel Question

2014-04-05 Thread Martin Groenescheij
On 6-4-2014 13:03, Richard Rouse wrote: Hello, My friend is in the process of doing an Microsoft Excel Intermediate & Advanced course. I have had a look at his work books and have decided I would like to have a go at the course as well. However, I do not have Microsoft Office, I have

  1   2   >