Category: News
WARNING for users of Dropbox (Beta) integration with Microsoft 365/Word
Anyone concerned with the “last modified date” of their files should NOT use the Dropbox (Beta) integration sent out by Dropbox earlier in the week. Once the Beta is installed in Word, it will alter the dates of every file you open, even if you do nothing to the file. If the last modified date was, say, June 27, opening the file merely to look at, making NO changes, the last modified date will change to the date you open the file. The problem occurs in Mac and Windows.
This is a disaster for law offices, which count on the last modified dates in a number of ways.
Anyone concerned with the “last modified date” of their files should NOT use the Dropbox (Beta) integration sent out by Dropbox earlier in the week. Once the Beta is installed in Word, it will alter the dates of every file you open, even if you do nothing to the file. If the last modified date was, say, June 27, opening the file merely to look at, making NO changes, the last modified date will change to the date you open the file. The problem occurs in Mac and Windows. This is a disaster for law offices, which count on the last modified dates in a number of ways. Read More
When running the setup.exe file for MATLAB R2024A on a Windows system, the “Error code: -354” appears.
Unable to open the requested feature.Check your internet connection and proxy settings in MATLAB Web preferences and then try starting the feature again.
Detailed information:
Error code: -354
Error message: ERR_CONTENT_LENGTH_MISMATCHUnable to open the requested feature.Check your internet connection and proxy settings in MATLAB Web preferences and then try starting the feature again.
Detailed information:
Error code: -354
Error message: ERR_CONTENT_LENGTH_MISMATCH Unable to open the requested feature.Check your internet connection and proxy settings in MATLAB Web preferences and then try starting the feature again.
Detailed information:
Error code: -354
Error message: ERR_CONTENT_LENGTH_MISMATCH installation error MATLAB Answers — New Questions
How do I integrate my MATLAB Compiler SDK C or C++ shared library in Visual Studio?
I have used MATLAB Compiler SDK to compile a C/C++ library from MATLAB and I would like to integrate it into a C/C++ application in Visual Studio. How can I do this?I have used MATLAB Compiler SDK to compile a C/C++ library from MATLAB and I would like to integrate it into a C/C++ application in Visual Studio. How can I do this? I have used MATLAB Compiler SDK to compile a C/C++ library from MATLAB and I would like to integrate it into a C/C++ application in Visual Studio. How can I do this? visual, studio, compiler, sdk, dynamic, static, library MATLAB Answers — New Questions
Eliminate the long number appearing in symbolic calculations
I am doing some symbolic calculations and end up with very large numbers in the symbolic expression. For example, I get the variable "term" as the result of my calculation:
syms J1
term = J1*(6582018229284824168619876730229377341315370891042652124695852093/13164036458569648337239753460458804039861886925068638906788872192 – 4302204281461843i/81129638414606681695789005144064);
It contains these long numbers. When I use vpa(), I get the following:
vpa(term)
How can I eliminate these small numbers with imaginary parts using vpa() or any other function? They should be rounded to zero. (I don’t want to take only the real part using the real() function because these numbers can show up as real part too.)I am doing some symbolic calculations and end up with very large numbers in the symbolic expression. For example, I get the variable "term" as the result of my calculation:
syms J1
term = J1*(6582018229284824168619876730229377341315370891042652124695852093/13164036458569648337239753460458804039861886925068638906788872192 – 4302204281461843i/81129638414606681695789005144064);
It contains these long numbers. When I use vpa(), I get the following:
vpa(term)
How can I eliminate these small numbers with imaginary parts using vpa() or any other function? They should be rounded to zero. (I don’t want to take only the real part using the real() function because these numbers can show up as real part too.) I am doing some symbolic calculations and end up with very large numbers in the symbolic expression. For example, I get the variable "term" as the result of my calculation:
syms J1
term = J1*(6582018229284824168619876730229377341315370891042652124695852093/13164036458569648337239753460458804039861886925068638906788872192 – 4302204281461843i/81129638414606681695789005144064);
It contains these long numbers. When I use vpa(), I get the following:
vpa(term)
How can I eliminate these small numbers with imaginary parts using vpa() or any other function? They should be rounded to zero. (I don’t want to take only the real part using the real() function because these numbers can show up as real part too.) vpa, symbolic, round MATLAB Answers — New Questions
Scatteredinterpolant (linear) from symmetric data does not produce symmetric isolines
I utilised the scatteredinterpolant function to generate an interpolation from which I derived isolines. My data are situated on a non-equispaced grid of points that are symmetric with respect to the midline. In fact, I only have data on one side, so I placed data on the other side by copying the values from the original data set, exploiting the symmetry.
When I generate iso-lines using the NATURAL method, the isolines have a symmetric trend. If I use the simplest method, i.e. LINEAR, the iso-lines are not symmetric, which does not make sense.
Do you know what may cause this issue and how to sort it out?I utilised the scatteredinterpolant function to generate an interpolation from which I derived isolines. My data are situated on a non-equispaced grid of points that are symmetric with respect to the midline. In fact, I only have data on one side, so I placed data on the other side by copying the values from the original data set, exploiting the symmetry.
When I generate iso-lines using the NATURAL method, the isolines have a symmetric trend. If I use the simplest method, i.e. LINEAR, the iso-lines are not symmetric, which does not make sense.
Do you know what may cause this issue and how to sort it out? I utilised the scatteredinterpolant function to generate an interpolation from which I derived isolines. My data are situated on a non-equispaced grid of points that are symmetric with respect to the midline. In fact, I only have data on one side, so I placed data on the other side by copying the values from the original data set, exploiting the symmetry.
When I generate iso-lines using the NATURAL method, the isolines have a symmetric trend. If I use the simplest method, i.e. LINEAR, the iso-lines are not symmetric, which does not make sense.
Do you know what may cause this issue and how to sort it out? matlab, scatteredinterpolant, interpolation MATLAB Answers — New Questions
Outlook on IMAC Issue
have an odd issue, screenshot below: the user when they respond or create a new email to a user they get this redbox with an ! in it and the first letter of the username. after deleting it and retyping its not longer an issue.. was just curious if anyone else has experience this before?
have an odd issue, screenshot below: the user when they respond or create a new email to a user they get this redbox with an ! in it and the first letter of the username. after deleting it and retyping its not longer an issue.. was just curious if anyone else has experience this before? Read More
Microsoft edge windows 10
how do i keep signed in, when i want to comment on a news item, i always have to sign in? thank you.
how do i keep signed in, when i want to comment on a news item, i always have to sign in? thank you. Read More
365 pro plus (university) + privat acc copilot pro -> error code 44
Hello!
I use a business acc with 365 proplus (from my university FU Berlin) and I would like to add copilot pro. I subscribed for copilot pro with my privat e-mail. But now the desktop app doesn’t allow to add copilot functionality. I get the error code 44 when I try.
What can I do? I don’t want to buy a full private Office version 365 just to use copilot when I already have access through my university. But this account doesn’t let me add copilot to the plan. Is it impossible to combine two accounts to use word 365 with copilot?
Hello! I use a business acc with 365 proplus (from my university FU Berlin) and I would like to add copilot pro. I subscribed for copilot pro with my privat e-mail. But now the desktop app doesn’t allow to add copilot functionality. I get the error code 44 when I try. What can I do? I don’t want to buy a full private Office version 365 just to use copilot when I already have access through my university. But this account doesn’t let me add copilot to the plan. Is it impossible to combine two accounts to use word 365 with copilot? Read More
Conditional Formatting with dates and highlights
I am writing a workbook and need a conditional formula that highlights due dates the month before they are due in yellow and stays yellow until the due date. Then changes to a pink color if overdue. I have a cell showing the current date, is there a way to use that cell in the formula?
I am writing a workbook and need a conditional formula that highlights due dates the month before they are due in yellow and stays yellow until the due date. Then changes to a pink color if overdue. I have a cell showing the current date, is there a way to use that cell in the formula? Read More
How to revoke consent for a registered app programmatically?
Hello,
I’ve been struggling with this issue for days. Tried many different endpoints and mostly got back cryptic errors only. Overall, zero progress. So, I really hope that someone here can help me out.
I have a very simple application where users can sync their calendars and also receive new events directly into the calendar. I acquire “Calendars.ReadWrite, offline_access, User.Read” delegated permissions interactively.
When the users decide to stop using my application, they can “unlink” and I will drop all the events, hooks, etc. What I am trying to achieve is that my third-party app would also disappear from the list of apps presented here: https://account.live.com/consent/Manage. In other words, a complete cleanup, revoking any access permissions, dropping all tokens, etc.
It seems a very basic scenario. Google Calendar has a simple endpoint that can do exactly that: https://oauth2.googleapis.com/revoke?token=<TOKEN>. What am I missing? How can I do that? I am running out of ideas about what I can do with revokeSignInSessions and oAuth2PermissionGrant; it seems like I tried everything and nothing worked. It must be a common requirement, no?
Thanks for reading this post! Any help is appreciated.
Regards,
Hello, I’ve been struggling with this issue for days. Tried many different endpoints and mostly got back cryptic errors only. Overall, zero progress. So, I really hope that someone here can help me out. I have a very simple application where users can sync their calendars and also receive new events directly into the calendar. I acquire “Calendars.ReadWrite, offline_access, User.Read” delegated permissions interactively. When the users decide to stop using my application, they can “unlink” and I will drop all the events, hooks, etc. What I am trying to achieve is that my third-party app would also disappear from the list of apps presented here: https://account.live.com/consent/Manage. In other words, a complete cleanup, revoking any access permissions, dropping all tokens, etc. It seems a very basic scenario. Google Calendar has a simple endpoint that can do exactly that: https://oauth2.googleapis.com/revoke?token=<TOKEN>. What am I missing? How can I do that? I am running out of ideas about what I can do with revokeSignInSessions and oAuth2PermissionGrant; it seems like I tried everything and nothing worked. It must be a common requirement, no? Thanks for reading this post! Any help is appreciated.Regards, Read More
Printers lose connection to Universal Printer Server
We have 6 new Canon printers MF751dw that are directly connected to Universal Print service. If there is ever a network outage or disconnection anywhere the printers lose connectivity and do not reconnect to UP. They are connected to the network as I can access the printer configuration web page. We have to power cycle the printers to reconnect them to UP. I easily duplicate this problem by unplugging the ethernet from a printer then plugging it back in. The network connection is ok however, it does not reconnect to UP and they only way to reconnect it is to power cycle the printer. It happens on every printer that we have connected to UP. Is there a way to change this behavior?
We have 6 new Canon printers MF751dw that are directly connected to Universal Print service. If there is ever a network outage or disconnection anywhere the printers lose connectivity and do not reconnect to UP. They are connected to the network as I can access the printer configuration web page. We have to power cycle the printers to reconnect them to UP. I easily duplicate this problem by unplugging the ethernet from a printer then plugging it back in. The network connection is ok however, it does not reconnect to UP and they only way to reconnect it is to power cycle the printer. It happens on every printer that we have connected to UP. Is there a way to change this behavior? Read More
Word verschiebt meine Überschriften nach oben
Hey, ich habe das Problem dass meine Überschriften sich ab der zweiten Seite zu nah an die Kopfzeilen versetzen. Wenn ich eine Überschrift auf der ersten Seite mache, springt der Cursor wegen der Textart “Überschrift” immer ein kleines Stück nach unten damit die Überschrift dann nicht direkt an der Kopfzeilen hängt. Dies macht er jedoch nicht mehr ab der zweiten Seite und manuell kann ich da auch keinen Abstand ab der zweiten Seite einstellen.
Hey, ich habe das Problem dass meine Überschriften sich ab der zweiten Seite zu nah an die Kopfzeilen versetzen. Wenn ich eine Überschrift auf der ersten Seite mache, springt der Cursor wegen der Textart “Überschrift” immer ein kleines Stück nach unten damit die Überschrift dann nicht direkt an der Kopfzeilen hängt. Dies macht er jedoch nicht mehr ab der zweiten Seite und manuell kann ich da auch keinen Abstand ab der zweiten Seite einstellen. Read More
Cross sheet functionality and maintenance of the chronological order of a formula
Hi community,
I’m working on a formula that searches a range of cells and outputs it another range of cells where the criteria are based on matches on two dropdown menus which are dependent (Columns A and B)
Summarized the formula does the following:
1. Lookup: Excel searches for a selected item from a corresponding dropdown menu in column B.
2. Retrieving Previous Data: When a match is identified (two identical items), Excel should search the designated columns to retrieve the previously entered data for that item.
3. Order of Retrieval: If there are multiple entries for the same item, Excel will prioritize the nearest entry relative to a reference row (This means below the reference row, it should not search upwards). For example, if the reference row is 11, and there are entries in rows 16 and 21 for the same item, Excel should retrieve the data from row 16. (You can test this by either blanking dropdown cells in columns A and B, and it will switch to the output location)
My problem is that I need this type of functionality across different sub-sheets so that when it starts searching in let’s say week 1 (sheet 1) it will continue its search parameters in week 2 (sheet 2) and maintain the order of retrieval as mentioned in point 3 above. Essentially linking different sub-sheets together through one formula.
I attached a sample with annotations to explain how the formula functions and how I need it to work.
The solutions I can think of are;
1. Simplyfing the formula making it less stress intensive so that it would be possible to merge all sub-sheets into one big sheet
2. Creating a master sheet where one can perform lookups using the INDIRECT and MATCH functions
I’m not sure how to fully flesh out these ideas or of other solutions however.
Hi community,I’m working on a formula that searches a range of cells and outputs it another range of cells where the criteria are based on matches on two dropdown menus which are dependent (Columns A and B)Summarized the formula does the following:1. Lookup: Excel searches for a selected item from a corresponding dropdown menu in column B.2. Retrieving Previous Data: When a match is identified (two identical items), Excel should search the designated columns to retrieve the previously entered data for that item.3. Order of Retrieval: If there are multiple entries for the same item, Excel will prioritize the nearest entry relative to a reference row (This means below the reference row, it should not search upwards). For example, if the reference row is 11, and there are entries in rows 16 and 21 for the same item, Excel should retrieve the data from row 16. (You can test this by either blanking dropdown cells in columns A and B, and it will switch to the output location)=IF(B11=””,””,IFERROR(MAKEARRAY(5,3,LAMBDA(x,y,INDEX($G$1:$I$25,XLOOKUP(A11&B11,$A$5:$A$10&$B$5:$B$10,ROW($B$4:$B$9),,0,-1)+x,y))),””))My problem is that I need this type of functionality across different sub-sheets so that when it starts searching in let’s say week 1 (sheet 1) it will continue its search parameters in week 2 (sheet 2) and maintain the order of retrieval as mentioned in point 3 above. Essentially linking different sub-sheets together through one formula.I attached a sample with annotations to explain how the formula functions and how I need it to work.The solutions I can think of are;1. Simplyfing the formula making it less stress intensive so that it would be possible to merge all sub-sheets into one big sheet2. Creating a master sheet where one can perform lookups using the INDIRECT and MATCH functionsI’m not sure how to fully flesh out these ideas or of other solutions however. Read More
How to calculate the percentage of each color in this image ?
How to calculate the percentage of each color in this image ?How to calculate the percentage of each color in this image ? How to calculate the percentage of each color in this image ? image processing, image segmentation, bar chart percentages, color segmentation MATLAB Answers — New Questions
How do I deactivate MATLAB?
I need to deactivate MATLAB. How do I do this?I need to deactivate MATLAB. How do I do this? I need to deactivate MATLAB. How do I do this? MATLAB Answers — New Questions
Questions about the input X of pcolor and contourf.
I have two questions, the first one is:
In the documentation of pcolor
the input arguments X is described as follows:
x-coordinates, specified as a matrix the same size as C, or as a vector of length n, where [m,n] = size(C). The default value of X is the vector (1:n).
To create a rectangular grid of vertices, specify X as either of the following:
A vector containing values that are increasing or decreasing.
A matrix that is increasing or decreasing along one dimension and is constant along the other dimension. Set the dimension that varies to the opposite of the dimension that varies in matrix Y. You can use the meshgrid function to create the X and Y matrices.
To create a parametric grid, create a rectangular grid and pass it through a mathematical function.
But in its case of specifying Parametric Grid, X and Y don’t follow do not meet the above requirement, which is "A matrix that is increasing or decreasing along one dimension and is constant along the other dimension. Set the dimension that varies to the opposite of the dimension that varies in matrix Y."
I wonder if that means you can use X and Y coordinates for scatter points, for example:
X = [1 2 3; 2 3 4; 3 4 5]
Y = [1 1 1; 2 2 2; 3 3 3]
And the second one is:
In the documentation of contourf
x-coordinates, specified as a matrix the same size as Z, or as a vector with length n, where [m,n] = size(Z). The default value of X is the vector (1:n).
When X is a matrix, the values must be strictly increasing or decreasing along one dimension and remain constant along the other dimension. The dimension that varies must be the opposite of the dimension that varies in Y. You can use the meshgrid function to create X and Y matrices.
When X is a vector, the values must be strictly increasing or decreasing.
I wonder if that I can use X and Y coordinates for scatter points, for example:
X = [1 2 3; 2 3 4; 3 4 5]
Y = [1 1 1; 2 2 2; 3 3 3]I have two questions, the first one is:
In the documentation of pcolor
the input arguments X is described as follows:
x-coordinates, specified as a matrix the same size as C, or as a vector of length n, where [m,n] = size(C). The default value of X is the vector (1:n).
To create a rectangular grid of vertices, specify X as either of the following:
A vector containing values that are increasing or decreasing.
A matrix that is increasing or decreasing along one dimension and is constant along the other dimension. Set the dimension that varies to the opposite of the dimension that varies in matrix Y. You can use the meshgrid function to create the X and Y matrices.
To create a parametric grid, create a rectangular grid and pass it through a mathematical function.
But in its case of specifying Parametric Grid, X and Y don’t follow do not meet the above requirement, which is "A matrix that is increasing or decreasing along one dimension and is constant along the other dimension. Set the dimension that varies to the opposite of the dimension that varies in matrix Y."
I wonder if that means you can use X and Y coordinates for scatter points, for example:
X = [1 2 3; 2 3 4; 3 4 5]
Y = [1 1 1; 2 2 2; 3 3 3]
And the second one is:
In the documentation of contourf
x-coordinates, specified as a matrix the same size as Z, or as a vector with length n, where [m,n] = size(Z). The default value of X is the vector (1:n).
When X is a matrix, the values must be strictly increasing or decreasing along one dimension and remain constant along the other dimension. The dimension that varies must be the opposite of the dimension that varies in Y. You can use the meshgrid function to create X and Y matrices.
When X is a vector, the values must be strictly increasing or decreasing.
I wonder if that I can use X and Y coordinates for scatter points, for example:
X = [1 2 3; 2 3 4; 3 4 5]
Y = [1 1 1; 2 2 2; 3 3 3] I have two questions, the first one is:
In the documentation of pcolor
the input arguments X is described as follows:
x-coordinates, specified as a matrix the same size as C, or as a vector of length n, where [m,n] = size(C). The default value of X is the vector (1:n).
To create a rectangular grid of vertices, specify X as either of the following:
A vector containing values that are increasing or decreasing.
A matrix that is increasing or decreasing along one dimension and is constant along the other dimension. Set the dimension that varies to the opposite of the dimension that varies in matrix Y. You can use the meshgrid function to create the X and Y matrices.
To create a parametric grid, create a rectangular grid and pass it through a mathematical function.
But in its case of specifying Parametric Grid, X and Y don’t follow do not meet the above requirement, which is "A matrix that is increasing or decreasing along one dimension and is constant along the other dimension. Set the dimension that varies to the opposite of the dimension that varies in matrix Y."
I wonder if that means you can use X and Y coordinates for scatter points, for example:
X = [1 2 3; 2 3 4; 3 4 5]
Y = [1 1 1; 2 2 2; 3 3 3]
And the second one is:
In the documentation of contourf
x-coordinates, specified as a matrix the same size as Z, or as a vector with length n, where [m,n] = size(Z). The default value of X is the vector (1:n).
When X is a matrix, the values must be strictly increasing or decreasing along one dimension and remain constant along the other dimension. The dimension that varies must be the opposite of the dimension that varies in Y. You can use the meshgrid function to create X and Y matrices.
When X is a vector, the values must be strictly increasing or decreasing.
I wonder if that I can use X and Y coordinates for scatter points, for example:
X = [1 2 3; 2 3 4; 3 4 5]
Y = [1 1 1; 2 2 2; 3 3 3] pcolor, contour, countourf MATLAB Answers — New Questions
Can’t cancel/Edit My Meetings
I am having an issue with my outlook meetings not allowing me to edit or cancel. If I try to cancel I get Error 3003. If I attempt to edit I get an error saying I am not the host. These are meetings I have created myself and have not given anyone else host rights to. This occurs almost immediately after I create a meeting.
I am having an issue with my outlook meetings not allowing me to edit or cancel. If I try to cancel I get Error 3003. If I attempt to edit I get an error saying I am not the host. These are meetings I have created myself and have not given anyone else host rights to. This occurs almost immediately after I create a meeting. Read More
Using azure Search datasource in Azure AI completion API is creating many prompt tokens
Hi
I have written Azure Open AI implementation integrating with Azure cognitive search, as shown below.
{
“data_sources”: [
{
“type”: “AzureCognitiveSearch”,
“parameters”: {
“endpoint”: “AZURE_SEARCH_END_POINT”,
“key”: “AZURE_SEARCH_KEY”,
“index_name”: “INDEX_NAME”,
“scope”: {
“in_scope”: true,
“top_n_documents”: 1
}
“queryType”:”vectorSimpleHybrid”,
}
}
],
Then I make Azure Open API completion call using this Azure cognitive search service. I use mode GPT 3.5.
Everything is working fine as expected.
The challenge is the number of tokens it is generating is huge. For the simple prompt like “Who is Some XYZ”, it shows ‘4000+’ prompt tokens.
How do I avoid this. I am not adding any context to this. I tested taking out the above code and the prompt token count is around 5.
Can you suggest ways to solve this?
I tested adding filter to point to one chunkId, even then the prompt token count does not come down.
I was told to run a semantic search on to search index and then give the results as input chat completion API. But not sure how to implement this.
Can you suggest or point me the right direction.
REST API call would be preferred but even python code will help.
Thank you
HiI have written Azure Open AI implementation integrating with Azure cognitive search, as shown below. {
“data_sources”: [
{
“type”: “AzureCognitiveSearch”,
“parameters”: {
“endpoint”: “AZURE_SEARCH_END_POINT”,
“key”: “AZURE_SEARCH_KEY”,
“index_name”: “INDEX_NAME”,
“scope”: {
“in_scope”: true,
“top_n_documents”: 1
}
“queryType”:”vectorSimpleHybrid”,
}
}
], Then I make Azure Open API completion call using this Azure cognitive search service. I use mode GPT 3.5.Everything is working fine as expected.The challenge is the number of tokens it is generating is huge. For the simple prompt like “Who is Some XYZ”, it shows ‘4000+’ prompt tokens.How do I avoid this. I am not adding any context to this. I tested taking out the above code and the prompt token count is around 5.Can you suggest ways to solve this? I tested adding filter to point to one chunkId, even then the prompt token count does not come down.I was told to run a semantic search on to search index and then give the results as input chat completion API. But not sure how to implement this.Can you suggest or point me the right direction.REST API call would be preferred but even python code will help. Thank you Read More
How to include additional fields in filter range
In the attached sheet columns D-R have a filter applied.
For some reason applying a filter that includes columns A-C causes the Filter button to be ghosted/greyed.
Anyone know why this is happening?
Thanks
In the attached sheet columns D-R have a filter applied. For some reason applying a filter that includes columns A-C causes the Filter button to be ghosted/greyed. Anyone know why this is happening? Extend_filter_range.xlsx Thanks Read More
Should I install the most recent update?
My dad just warned me of the most recent windows 11 updated and he said not to update to it today as it bricked some laptops. Is this true? What have you heard about it?
My dad just warned me of the most recent windows 11 updated and he said not to update to it today as it bricked some laptops. Is this true? What have you heard about it? Read More