Hello,
I have problem with my HyperV server, he minute after start was stopping with critical error.
Where in the system i can find more information about this error?
I'm stuck using word 2007 at the office. It has options for retaining formatting, pasting as plain text, and pasting text to match the destination's formatting. That last option is the one I want, but word is blatantly ignoring it.
I copy some text from a PDF, paste into word, and it retains the PDF's formatting... even though I went into options -- advanced -- changed all the dropdowns to "Match Destination Formatting". It also ignores "text only" option... It retains the exact mix of bold, italic, normal text & fonts.
I can work around it by pasting to a plain text file, then pasting into word. Or I can do paste special -- unformatted text. But this is so irritating... I just want to ctrl+V and not hassle with it every single time. Is there a better fix?
i'm looking to become really really good at understanding my machine. this includes hardware, software, firmware, the internet, creating my own network, troubleshooting problems, etc. I have an aerospace engineering degree so i'm technically inclined, but i want to really delve deeper in becoming a techno guru.
what literature should i start reading? books, textbooks, journals, articles, papers, etc. anything would help, thanks!
I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is different. I have one hundred such rows. I am successfully using Conditional formatting (e.g. cells containing data less than limiting value in first five columns are made red) for 1st row. But how to copy this conditional formatting so that it is applicable for entire hundred rows with respective limiting values.
I tried with format painter. But it retains the same source cell (here limiting value) for the purpose of conditional formatting in second and subsequent rows. So, now I am required to use conditional formatting for each row separately s
Hello:
I have a custom toolbar associated with some VBA macros in Word 2003. I want this toolbar to alway be visible, independent of the doc or template open.
Is there any way of doing it?
Thanks in advance.
Hey there,
I'm finding it difficult to get MS reporting working to what I'd like to show.
What I'm trying to do is:
a) In my database store a URL file (HTTP external file), that is a .jpeg. I'd like to use that URL to call the image on the report sheet. I have tried to use 'Control source' on the data panel, but with no success. Any way I can get Dynamic Images to show up on each database.
Also, I have a couple of Relational Databases.
One Defines Values:
For Example:
DefinePets('petID','Name of Pet')
The other one links the Main DB with the 'DefinePets' database.
Eg:
connect('petID','mainID','extraFeild')
I'd like my report to Go into the "connect" Table, where the the currently viewed Record Value = mainID, then find petID and return Name of Pet.
There is a many to many link between definePets and the main Table. (Therefore connect is joining them up)
Or is that too much to ask from a simple package like Access?
Thanks.
Hi all
In Word 2007 I have a Page which had to be changed to vertical mode. Now when I look at the page it's vertical but the header/footer are still horizontal is there a way to change them to the existing alignment?
How do I change the font used by numbers, or numerics, in a Word 2007 document?
For the rest of the document, they would be using another font for the letters and such, but I would like the numbers to be in a different font altogether.
If this is possible, how do I set it?
Folks/Mates,
I need some advise and assistance regarding the testing of Hyper-V.
Here is my h/ware configuration:
1) Intel i5 processor (i5-750)
2) Intel M/B DP55WB
3) 6 GB DDR3 RAM
OS = Server 2008 R2 Standart (evaluation copy).
I installed 2008 r2 on my machine and added hyper-v role to it. I created 2 VMs and installed OS. But after finishing the OS installation the VMs are not booting up.
After finishing the OS installation, the VM reboots automatically (normal behaviour) and shows "preparing your system for first time" after that it reboots and didn't come online.
Few things to notice, when I am running "securable" on my server 2008 R2 OS it shows that processor is not supporting h/ware virtulization, but (since my desktop is dual boot) when I am running "securable" on my windows 7 OS, it shows that process "does" supports hardware virtulization. VT option is already enabled in BIOS.
Any help and suggestions are highly appreciated :)
Thanks in advance.
Pradeep Rawat
I'm using Java to read a form that is in an Excel spreadsheet that the user fills in with information about geometric shape. Ex:
Shape :_________
Color :_________
Area: _________
Perimeter:________
So far the code I have can I can read what I want in the form and print out the values of Shape, Color, Area, Perimeter.
public class RangeSetter {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
FileInputStream file = new FileInputStream(new File("test2.xls"));
//C:\Users\Yo\Documents
// Setup code
String cname = "Shape";
HSSFWorkbook wb = new HSSFWorkbook(file); // retrieve workbook
// Retrieve the named range
// Will be something like "$C$10,$D$12:$D$14";
int namedCellIdx = wb.getNameIndex(cname);
Name aNamedCell = wb.getNameAt(namedCellIdx);
// Retrieve the cell at the named range and test its contents
// Will get back one AreaReference for C10, and
// another for D12 to D14
AreaReference[] arefs = AreaReference.generateContiguous(aNamedCell.getRefersToFormula());
for (int i=0; i<arefs.length; i++) {
// Only get the corners of the Area
// (use arefs[i].getAllReferencedCells() to get all cells)
CellReference[] crefs = arefs[i].getAllReferencedCells();
for (int j=0; j<crefs.length; j++) {
// Check it turns into real stuff
Sheet s = wb.getSheet(crefs[j].getSheetName());
Row r = s.getRow(crefs[j].getRow());
Cell c = r.getCell(crefs[j].getCol());
if (c!= null ){
switch(c.getCellType()){
case Cell.CELL_TYPE_STRING:
System.out.println(c.getStringCellValue());
}
}
}
}
What I want to do is to create a method that gets the that information and another that sets it.
So far I can only print to the console
I have auto recovery on my Excel program and I save my work several times a day. Tonight, I turned on the computer and it had shut down down for some apparent reason. When I pulled up my Excel program it only showed one auto recovery file form 8am this morning even though I worked/added onto my Excel sheet for several hours this afternoon.
Is there any way to recover my work I did this afternoon?
A colleague of mine organizes her data using MSAccess. she outputs the table and pastes it into an excel file (same headings/ columns,,,,). The excel sheet then does some calcs and outputs a summary sheet.
Is there a way to automate this process?
I need to write a macro to manage ranking and calendar for curling turnament.
The event will follow the Shenkel system
first match determined by general draw
after that every team has played one match is possible to determine the first ranking
second match determined by the rule: 1st vs. 2nd - 3rd vs. 4th - 5th vs. 6th and so on
after that every team has played two matches is possible to determine the second ranking
and so on until the end (3 to 5 matches normally).
Another rule is that from the second match is not possible to play against a team that I played before!
I was thinking to use MS-excel but also Calc (both LibreOffice/OpenOffice) should be fine. Thanks in advanced
I'm wondering if anyone knows of a plug-in for MS Word which can handle key-presses of surrounding keys when typing at speed (rather like iPhone or Android autocorrect)?
My use case is in transcribing interviews where I need to type quickly (even with the playback at half speed) - but I don't do this often enough to become a proficient touch typist. I will also be paying close attention to the text produced in subsequent analysis so I have a reasonable expectation that I'll catch any "hilarious" autocorrect errors.
Any pointers to plug-ins which work at either a system level or within MS Word would be great. Even in an open source word processor at a pinch, though I'd miss the MS Word environment and my macros.
Thanks.
I have a licensed instance of 2003 server standard edition on a physical server. can i also then run a third party virtual instance of the same server on the physical machine... i.e a vmware server with a cloned copy of the server for testing.
or do i need another license for the virtual copy as well?
Hi all!
I'm using MS Word 2007
Is it possible to replace the newline character (I mean \n) with some other character?
What about vice-versa? (replacing a character with newline)
Hi Team,
While preparing a Word 2007 document, I made a mistake. (Not to say I don't have any other copy of the document)
While formatting (as a try) I applied the style "Apply Style to Body to match selection". This caused the document to go totally in a wronfg format - having numbers even in tables.
Have you ever faced this? Could you please tell how to correct it?
Thanks
Lijo
Good Day to Everyone!!
Just wanna ask if there is a setting in MS Access 2007 to ignore all error messages, when i ran my application in MS Access 07 there are annoying messages that pop-ups. All I want is to ignore all those message without changing my code.. Thanks
I want to create a hyperlink to the location of my Word document. The document is on an web server so its path is like http://myserver.com/folder/worddocument.docx.
I can use the field code "FILENAME" and the field code "HYPERLINK", but I can't figure out how to use them together.
File name:
{ FILENAME \* Lower \p \* MERGERFORMAT }
Hyperlink:
{ HYPERLINK "http://myserver.com/folder/worddocument.docx" }
I am trying to cleanup a text and for some reason every line duplicated 3 times am i able to get ride of duplicates with regex or tricks or do you know a software which could do that , text file is like this
Party Started 10:17 (89/1/2)
Party Started 10:17 (89/1/2)
Party Started 10:17 (89/1/2)
Jessica At Dinner 17:54 (89/1/2)
Jessica At Dinner 17:54 (89/1/2)
Jessica At Dinner 17:54 (89/1/2)
How can i clean it up , and get ride of duplicated lines , it's about 69,587 lines
In Excel 2003, when you created a XY chart using time as an axis, you could set the scaling of these axes by typing in the date. In Excel 2007, you have to use the decimal version of the time (eg. How many days since some arbitrary earlier date). I was wondering if there was a way to avoid having to make such a calculation?
A developer posted on a blog that this issue would be fixed in a future release, but all versions of Excel 2007 I have tried have not resolved this issue. The relevant quote:
Those of you familiar with this technique of converting time to a decimal may recall that Excel 2003 allowed you to enter a date and time like “1/1/07 11:00 AM” directly in the axis option min/max fields and Excel would calculate the appropriate decimal representation. This currently does not work in Excel 2007 but will be fixed in a subsequent release.
When I copy some drawing in Illustrator, it stores it in clipboard in 3 formats: bitmap, device independent bitmap and enhanced meta-file.
If drawing contains text, then meta-file version has no anti-aliasing.
Below are examples in MS Word
OneNote has no "Paste Special" so it always paste in EMF. Is it possible either to tell OneNote to paste not in EMF, or tell Illustrator to use anti-aliasing while storing picture with letters?
Am currently using Outlook 2013.
Several times, when a mail is forwarded to me, i only see the First/Last name of the person in the forwarded mail, not the email id. Is there a way to make Outlook always display the email id.
I get these mails from people, who are also using Outlook but different versions.
One solution which we have to resort to, is to attach the mail, rather than forward, that way it retains the email address, but this is cumbersome, and I cannot ask everyone to do this.
This is similar to this question, but the answer selected does not work for me.
I have a range of long dates from Sep 2014 till Dec 2018, and for each month I have an amount. I want to sum up the data of each year in one cell.
Example:
2014 : sum of all amounts that are in 2014
2015 : sum of all amounts that are in year 2015
Sep2014 oct2014 Nov2014 Dec2014 Jan2015 Feb2015 ...
100 200 250 150 20 50
I know that 2014 = 100+200+250+150 = 700, but I need a formula to search for all cells that include that year and sum up the numbers.
What is default sorting for excel 2010 pivot table and charts I have a "Year month Week" column in my data sheet which I am using as row label, excel pivot table renders it arbitrarily
like in data sheet I have data in the following order
2010 October Week 1
2010 September Week 1
2010 September Week 2
2010 September Week 3
2010 September Week 4
but when I use this in pivot table it generates row labels as
2010 October Week 1
2010 September Week 3
2010 September Week 2
2010 September Week 4
2010 September Week 1
I want pivot table to show row labels exactly in the same order as it is in data sheet