Excel: Working with named Range.NumberFormat in VBA: "General" vs. "Standard" -

-

A few questions about the range. Score format here - Hopefully anyone can answer them, because the web is hard to find, all the general conditions.

A small background: I'm trying to eliminate the "random" Error 1004 code: Number of category categories Unable to set property edit The message is when I try to set up, the error occurs. In a named format, the number format of the late-bound object, mainly working with "normal" or "standard". The object, the application is in 99% of the cases. Selection. Also, please, the most common reason for this error - protection on a sheet or workbook - does not apply here .

  1. From Excel 2003 to 2007, Microsoft has started a bug in VBA if I type in the instant window? Selection. Numeric and press Enter, I get "normal". If I'm running a macro with a breakpoint I'm some edines (not all, not approximate), then I usually get "standard" what is "standard"? Where does it come from? I want to choose a number format from a cell, and want to leave it on the other; In random moments, I can not implement "standard" like this, and the result is not like normal (in Excel 2003, it is never visible in the immediate window, and systematically fails to implement Even if I convert all instances of "standard" to "normal". I still sometimes MyObject.NumberFormat = " General ". I have read in some places that it is better to implement the underlying format of a designated format, that is, to apply something normal (as I think standard); Thank you in advance for your assistance.

    / P>

    I believe the "standard" is used in some languages ​​instead of "normal." You should compare your results to .NumberFormatLocal.

    For the solution part If you are trying to set the number format to "normal" and getting errors, then just set the NumberForamt for the empty string. The form format will make the normal / standard. 

      selection.NumberFormat = ""

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

memcached - Django cache performance -

-
We are now using Redis for in-memory cache for our Django application (we used the first memcatch The difference in performance is no big, and we're using Redis because the disc dump feature). The problem is that Django cache's performance in my view - terrible, we have a view with 102 cache hits (no miss), and it has 81 ms (only the cash part, which is with the DJBugBug toolbar Is measured). In my opinion - this is a very long time, I know, asking for a question for DB can be 10x more (or 100x) time, but that is also not good with cash performance of that fact. We are running radis (and the first memacatch) on different hosts, connected to the local network with other servers. Is there a way to maximize cache performance in Django? Instead of displaying problem cache, there is a possibility of the number of items to be received for each page 102 Cash calls mean long time lost due to network latency. With full control of the code, you may be able to fix it with m...
Read more