PC Pals Forum
Technical Help & Discussion => Windows PCs & Software: Help, News & Discussion => Topic started by: Tony on January 14, 2004, 16:21
-
At present, if I open different spreadsheets, they all open in the same window. Now as I have three monitors, it would be handy if I could open them in seperate windows. I have had a look in the help files, but I'm buggered if I find how to set it up like that.
I suspectit will be easy, but it just ain't obvious, well not to me.
Signed: Dumber for Dunstable ::)
-
i would have thought you'd know to tell people what program your using :wtf:
-
Hey watch it you young whipper snapper ;D
MS Office XP on W2K ::)
-
why did you pay for ms office when you could have downloaded openoffice (http://www.openoffice.org) for free? ??? anyway, i don't know how to do that because i'v never used the program
-
why did you pay for ms office when you could have downloaded openoffice (http://www.openoffice.org) for free? ???
you know Measter, making assumptions on your part don't make it so ::) ;)
anyway, i don't know how to do that because i'v never used the program
So how do you do it in OpenOffice? I reckon they must be similiar
-
January 1, 2004
OpenOffice Finds Sweet Spot with Governments
By Sean Michael Kerner
Following a trend by foreign administrations, the Israeli government this week suspended its acquisitions of new computer software from Microsoft (Quote, Chart).
Price issues and the U.S. company's refusal to sell individual programs from its standard software package are cited as the main reason behind the switch, according Associated Press reports. Instead, Israeli news outlet Arutz Sheva said Wednesday that the Israeli Ministry of Finance will begin distributing Openoffice.org to its users beginning this week. The Israeli government plans to begin distributing Openoffice.org software on CD-ROM to public access points across the country in 2004. The Hebrew version of Openoffice.org was translated by Sun Microsystems (Quote, Chart) and IBM (Quote, Chart) with the support and assistance of the Israeli Finance Ministry.
The Israel government did not respond to requests for comment.
"Israel is interesting because it has taken a stand on behalf of open source and open standards and said that this is the way that they want to go and Openoffice.org has been able to satisfy their needs," Louis Suarez-Potts, community manager for OpenOffice.org told internetnews.com.
The Open Office software suite (properly referred to as Openoffice.org or OOo) is one of the better-known applications of the open source movement. It provides an alternative to Microsoft's ubiquitous Office application with similar word processing, spreadsheet and presentation software. Development of OpenOffice.org is partially backed by Sun Microsystems. OpenOffice.org will run on both *nix and Window environments and is duel licensed under the LGPL (GNU Lesser General Public License) and SISSL (Sun Industry Standards Source License).
According to Suarez-Potts, Openoffice.org's license, which allows for open contributions, is one of the reasons that make the Israeli decision very promising.
"Even people that are not using it in the Hebrew form will benefit from whatever improvements or enhancement they make," he said.
Governments around the world appear to be taking an interest in Openoffice.org and open source software in general. The city of Austin, Texas recently adopted openoffice.org software and governments in Germany, France, Brazil and China to name of few have stated interest in going the open source route as well. In the U.K Scottish Public Libraries have made Openoffice.org software available for lending to the public.
"We have been working towards having as many governments both regional and federal adopt open source and open office in particular because we are the flagship of any desktop open source system. Suarez-Potts said. "We're now in some ways the most definite obvious example that a person is going to encounter of open source software."
The trend is even extending into more U.S. agencies, which have been some of Microsoft's best customers.
"A couple of departments in Massachusetts state agencies have said they want to go open source too," Yankee Group analyst Laura Didio told internetnews.com. "With government organizations they have to tender within the confines of approved vendor lists for RFP's and they usually have to go with the lowest price so its not surprising that if you're just talking price that open source is going to have a great deal of appeal."
Didio is quick to point out however that few organizations appear to look at the true total cost of ownership of open source solutions, specifically as it relates to indemnification (from the SCO Group lawsuit principally). She asserts that many governments need to have some sort of indemnification and that it's a large issue that needs to be recognized.
According to Didio, the price differential of open source solutions such as Openoffice.org is not the only reason why governments are making noise about open source. She believes that it's also about leverage and competition.
"I think that the competition that open source has brought to the table has been good because it has forced Microsoft to respond and give its customers better terms and conditions and that's healthy, Didio said. "It gives customers more leverage."
In the case of governments, open standards may potentially be viewed as a necessary form of democratic pluralism themselves.
"Should governments be using a format that is unique to a particular vendor to talk to its citizens? "Noted Linux Guru and author of the Open Source Definition Bruce Perens asks. "The government should not be saying you can only drive up to a government office in a particular brand of car. In the same sense the government should not be saying you can only talk to your government if you have Microsoft Windows software on your computer."
According to Openoffice.org's Suarez-Potts, it's not just a case of kicking Microsoft in the shins, it's more a question of making file formats that are freely available, more available to a country's citizens.
"We see that any number of governments in this coming year and probably the next two years are going to start using openoffice.org and open systems because we are better for the government itself and its better for the citizens of that country," he said.
-
well, you just click open, select your document, then click the open button on the dialog box. simple.
-
I'm pretty sure you can make it span multiple monitors, but I don't think Excel will allow you to display different sheets on different monitors, which is a shame.
Many many years ago, I used to use a Tandy 2000 computer (pre-IBM PC) which had dual displays. Using SuperCalc 3 software, you could update a spreadsheet on one monitor and see the graph update in realtime on the other monitor. High tech stuff in those days :o
-
Tony, probably not what your looking for, but I find it useful sometimes when I'm doing work at home, look Here (http://phoenix.phys.clemson.edu/tutorials/excel/index.html)
Hookstar
-
Hi Tony,
Well, I don't know if I well understood what you need. But anyway, I found something similar. If not what you nedd, you leave it.
It's an option in "Windows" itself not in "Office". Here it is:
Open "Control Pannel", take "Folders Options", and in "General" change the tick to the other one which is "Open every folder in a separated window", like the attached image:
Hope I could be in more help.
-
what he wants is nothing to do with the windows settings. what he wants is to have excel to open other spreadsheets an another window instead of the active one.
-
I think that the problem is that most programs only support one active doc/pic/file etc at a time Tony :(
So the only way I can think of to have 3 spreadsheets working independantly would be to install and run 3 seperate programs, one for each monitor.
Not having worked with multiple monitors, only multiple pcs, then I dont know how you would do that but its possibly worth looking into :)
-
Thanks one and all for your input. I have no prob opening Word docs or folders in seperate windows, just spreadsheets. I could have sworn that I could do that when I was running MS Office Pro 2000.
So Measter are you saying, you can open seperate spreadsheets in seperate windows in OpenOffice ? You use OpenOffice Adept, but you did not mention that you can, is that because you cannot ? :)
Anyway thanks once again.
-
yes, you can. i'm not sure if it's a defualt setting, but it works when i tried. you might have to mess around in the settings.
-
You use OpenOffice Adept, but you did not mention that you can, is that because you cannot ? :)
No, it's because I forgot. Sorry Tony.
Yes OpenOffice will open multiple sheets in multiple windows. I have no idea whether it will alll windows to be moved to separate monitors, but since this is an O/S function it should work nicely :)
-
and you won't have to retype your spreadsheets cause open office will open and save in the same format as excel. overall openoffice is a much better program.
-
Ignore the three monitor setup, if I can get docs to open in seperate winows on one monitor, they will transfer to any other monitor.
Right, in Openoffice, you can do just that, so I reckon MS Office XP Pro will also do it. That said, I may just change over to OpenOffice if I cannot find out how to do it in MS Office XP.
-
you should change anyway. 1 67mb(thats a guess) download and install and your ready to go
-
Measter I downloaded it this morning, and it looks fine, and does the seperate window thingy.
Just think, all that money I spent on MS Office XP Pro.....what a waste ;) ::)
Now that was good work on your part Measter, but think on, now that you have access to the "Danger Zone"............don't be spending to much time in there.........as it can addle your brain......there's worse things than going blind you know :-X
-
;D
-
Let us know what you think of Open Office after you've given it a test drive, Tony. I've just updated to MS Office 2003. I say updated, rather than upgraded, because it's basically the same as Office XP, with a new coat of paint.
-
buying office is a waste of money
-
I totally agree, Measter. ;)
-
I have Office 2003 on my laptop. Outlook 2003 is a vast improvement on older versions, but Word and Excel don't seem that different to me :-\
I've been using OpenOffice off and on for months now. There are some aspects of it which are different to MS Office, but not enough to justify the price of Office.
Lets face it 90% functionality and none of the cost. Which are you going to choose? ::)
-
Simon I reckon Adept's post sums it up nicely, and in any case, Word and Excel spreadsheets are all I use basically, oh and Frontpage as my html editor. And they are all well catered for in OF.
-
I actually found Outlook 2003 a little 'busy', but I can see it's merits for more of a 'work' environment, which, after all, is what it's designed for. I also mainly use Word and Excel.
-
I actually found Outlook 2003 a little 'busy'
I absolutely hated Outlook 2003 last week when I first got it, I thought it was garish, but having used it it is really growing on me.
Some of the new features really come into their own in a Windows 2003 server network. I'm not sure I'd use it at home - even if I could afford it :-\
-
Out of interest, is it possible to run both Open Office and Microshaft Office on the same PC, or do they conflict?
-
Dave I have'nt noticed any conflict.
OK because Open Office was loaded last, It has become default text, spreadsheet, and html web page maker. But all MS Office components can be used by going Start>Programs> to whatever MS component you want, or you could use desktop icons or the MS toolbar.
Mind you, with MS Office XP Pro at 248MB and OpenOffice at 144MB, it's a lot of space taken up to do virtualy the same job.