September 25, 2012

HP2311x resolution not accepted

Problem: There is notification "set resolution 1920x1080" however you can't select it in display settings screen resolution

Problem was old graphics card - it was onboard card. Shows messages as "Input signal out of range" and "change settings to 1920x1080". However, the only resolution that was possible for HP2311x monitor to show on this old video card was 1280x1024. Otherwise it was either black screen or stretched screen.
Resolution is to buy a new video card -
for example for AGP slot - Ati Radeon HD 3450
or PCIe - Asus GT4400.

September 18, 2012

Excel move/copy sheet error

Problem: In Excel 2003, only the first 255 characters in each cell are copied.

Excel has limitied number of characters it can move to another worksheet, it reports this error when moving it:
The sheet you are copying has cells that contain more than 255 characters.
only the first 255 characters in each cell are copied.
To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet.

User should have in mind to limit contents of cells or when moving to another worksheet,
it will be copied only via selecting the whole sheet and simple copy-paste to another worksheet.
However, format will not be as original.