Is it possible to generate non-technical schema validation errors?
With the 1.0 Framework, I've worked out using the XmlValidatingReader. Since
I'm using the validation errors as feedback to the end user, I'm hoping to
get away from techy messages such as "The
'http://tempuri.org/XMLFile1.xsd:MaxDependents' element has an invalid value
according to its data type. An error occurred at
and go with a user friendly message of "Max Dependents must be between 0 and
10". I've scoured the newsgroups, MSDN and docs for creating custom
valid...What is 'Align Text to Base Line Guide'?
Trying to make sure all lines have the same amount of space between them I
selected paragraph from the format menu and under the line adjustments there
is a box 'align text to base line guides' Ok I did that, now there are lines
at the margines of my newsletter. What are these? Also selecting this pushed
my text down from the top edge of the text box. What is this?
The baseline guide measurements are in the Arrange, Layout Guides, Baseline tab.
There is help in the Help menu.
"Go_Girl3647" <GoGirl3647@discussions.microsoft.com...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...Top heavy fractions
I need a way of preventing Excel (2002 on Windows XP) from changing top
heavy fractions (as in 6/4) to "normal" fractions (as in 1 1/2).
We have three columns of fractions which need to be entered as "top heavy"
and then a fourth column which is a calculation of the first three.
As we have to perform a calculation on the fourth column we can not format
the other columns as text (to prevent the changing from "6/4" to "1 1/2").
Any other suggestions would be appreciated.
This might help a little:
Format the columns to ###/### FROM FORMAT->SPECIAL...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...set value of a group of activex control points
Have a spreadsheet that has some 20+ activex control points (option buttons).
Is there a way to group all these controls together & set their initial
values the same? Trying to setup a "reset" type of operation that would clear
all control points. I can do them individually via properties, but it's too
...right aligned menus?
is there any way to use menus from resources in right justified order? we
have a customer that might like a non-English menu.
Open the .rc file in a Text Editor and Add MFT_RIGHTJUSTIFY to the menu
"Donald Sorenson" <email@example.com> wrote in message
> is there any way to use menus from resources in right justified order? we
> have a customer that might like a non-English menu.
but I didn't find the right place in the script file...
I tried to OR (|) it with the first M...Storing distinct values in an array
in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...
i would like to store all distinct values in an array
any ideas on how i could do that ...
eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showt...Validation Problem #2
I have a schema file PDDSch.xsd which validates the PDD.xml file. the
rootnodes are as shown below
<PDD xmlns="http://tempuri.org/PDDSch.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-Instance" >
attributeFormDefault="quali...Populate cell with a value if another cell has a certain value
All, good morning. i have a issue, i need to populate cell E4 with a value
CX/025966 when cell F4 has a text Bond Street.
Is there a simple way of doin this?
If my comments have helped please hit Yes.
> All, good morning. i have a issue, i need to populate cell E4 with a value
> CX/025966 when cell F4 has a text Bond Street.
> Is there a simple way of doin this?
=IF(F4="Bond Street","CX/02...Deletion settings in Mailbox Store Properties
Our company would like to enforce a policy to permanently delete items
30 days or older from each mailboxes Deleted items folder.
The mailboxes all reside on the Exchange 2003 server.
Under Mailbox Store Properties, Deletion settings, the Keep deleted items
for (days) is set to 30, yet the items are not being deleted.
My thoughts are that it is because we do not have the Mailbox Manager
Is that correct?
I am a little hesitant to run it because I am worried about what else it
I only see one recipient policy and that is for email addresses.
...Show zero values
When a formula returns a zero value, the zero value is not being
I have reviewed the following:
- conditional formatting
- zero values are checked (Tools/Options/View)
- stepped through my VB code (it inserts formulae based on a Worksheet
- locked and hidden values unchecked with and without protection (this
should have no effect when the sheet is unprotected)
Are there any other circumstances that result in a zero value not being
displayed? Are there any other reasons for this occurrence?
Check also normal cell formatting! there are formats that hide ...CButton::GetButtonStyle()
is it possible that the function GetButtonStyle() returns one single style
where can i get information when to use a mask and when to use the plain
how about other controls/windows?
actually i am a little bit confused about this...
"Philipp Huber" <firstname.lastname@example.org> wrote in message
> is it possible that the function GetButtonStyle() returns one single style
I'm not sure what you're asking, but GetButtonStyle returns the LOBYTE of
the GetWindowLong/GW...Comparing values #2
I have two sheets in a workbook. The first column in each sheet has part
I would like to compare worksheet1 column a to worksheet 2 column a and
identify duplicate values. I have not been able to make this work.
Chip Pearson has lots of ways to work with duplicates/uniques at:
> I have two sheets in a workbook. The first column in each sheet has part
> I would like to compare worksheet1 column a to worksheet 2 column a and
> identify duplicate values. I have not been able to make...Chart templates treates value axis as a category axis
I saved a Chart Template [Line Plot Type] that uses a horizontal value axis,
but when I try to use it in a new workbook, the data is plotted with a
horizontal category axis?
In a line chart, the horizontal (X) axis IS a category axis. Only an XY
chart has a value horizontal axis.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"FHW at EAD" <FHW at EAD@discussions.microsoft.com> wrote in message
>I saved a Chart Template [Line Plot Type]...Assign a value to a cell
I'll apreciate your help with this
in A1 i have a value in days that is used to make several calculations
but I need it to change if a specific condition is given something lik
If b1<a1 then a1=b1
where b1 is a value calculated somewhere else.
Thank you for your help.
Message posted from http://www.ExcelForum.com
try the following formula in A1:
> I'll apreciate your help with this
> in A1 i have a value in days that is used to make several
> calculations, but I need it to change if a specific condition is
> giv...Cntl Key move/select to change in value
Just another convenience key sequence to make my life easier. Sure, maybe I
could do it with a macro. But, it seems like a nice little obvious addition
to regular functionality. Cntl-Alt down arrow moves you down to where the
value changes. Cntl-alt-shift selects to change. Up, down, right, left of
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the s...IF statement with FALSE value being text AND cell reference? #3
Once again, figured it out on my own. Oh, and thanks for the repl
Needed to use the ROUND function:
=IF(D9>1,D9*D8,"<" & ROUND((D9*D10),2)
jcob2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560
View this thread: http://www.excelforum.com/showthread.php?threadid=27157
...Check for Values
I have 2 tables, requirements and stock on hand. In the requirement
table, I have a part number, qty and due date and a related record in
the stock on hand table using part number showing current stock. My
question is can I use a query (and how!) to tell me
a) I have enough stock to fulfil the requirements and
b) If not at what date will I not be able to fulfil the requirements
and by how many?
Have been working on this for a while, and cant work it out
You are there, we are not ... the following may not fit your situation ...
If you have a [Par...Changing the Text alignment of editbox at runtime
I am having a problem using editbox control
At runtime I can not change the text alignment of the editbox
I have searched all the methods and even all the messages but can't
find any solution
The problem is I Have To use an editbox control in my dialogbox and
I want to set the alignment of text left/Right & Center according to
3. PARAFORMAT structure
may be one of them will work
Best of luck
You would change the style using SetWindowLong() using GWL_STYLE and the
style you want ES_CENTER, ES_LEFT, or ES_RIG...Save only values of one sheet
If I save a workbook as .CSV, Excel only saves the values of the
current sheet in a *.CSV-file.
Can I do EXACTLY the same - saving only values of the current sheet -
in an *.XLS file (and of course in an XLS-format!).
Eventually, formatting elements (like background and font colors) may
also be saved.
Thanks for any help.
Just copy the sheet to a new workbook (right-click on the sheet tab, select
Move or Copy from the menu, select (new book) from the To book dropdown, and
check the Create a copy option, then OK), and save that new workbook.
(remove nothere from the...links+hold old value
i want to link 2 cells A + B cell A is a calculation (D+E) copy + paste
works for that.
But i want to change values D+E reguarly,and at the same time create new
cells for the new answers(i sill need the old answers)
not really sure what you're trying to achieve. Could you give a specific
> i want to link 2 cells A + B cell A is a calculation (D+E) copy +
> paste works for that.
> But i want to change values D+E reguarly,and at the same time create
> new cells for the new answers(i sill need the old...pasting values #2
I am working on a template which evaluates all the markets in which we do
business in. I have information on the some of the markets but not all of
them so i have filtered by NonBlanks so display all of the valid information.
I now have found new information on the countries that have NonBlank and
would like to paste them to my sheet as they are in the same order of my
filtered template. However, when I paste the information it disregards the
filter and pastes it on the sheet containing all the data. Naturally, the
information is not pasted in the right cells. I have gotten arou...