Forum Widgets
Latest Discussions
Le séparateur de milliers ne fonctionne pas dans Excel sur Mac
Dans les anciens fichiers Excel sur Mac, le séparateur de milliers ne fonctionne pas quand le format est "Feuille de calcul open XML strict (.xlsx)" alors qu'il fonctionne très bien avec le format "Classeur Excel (xlsx)". Mais dans "Enregistrer sous..." il n'est pas possible de changer de format. Merci de votre assistance !
Footer image cropping
Hi I'm experiencing issues when adding png images into footers. When I add the images into the footer, the bottom and right of each image is cropped when printed, no matter the size of the image. The print preview of the images looks correct. There is an additional oddity to this as follows - if I add a copy of one of the images into a cell in the main boy of the doc, then print the doc, all of the images print correctly. Any advice would be great.Advanced Formula Editor: converting functions Names into a module
I've written a group of complicated functions using the AFE in Excel Labs. They are stored in the Name Manager. I now realize it would have been better to write these using the Modules editor. Is there a way to export Lambdas from the list of Functions in the Names tab of the AFE, into a Module (not a vba module, a Module within AFE).
Script changing dates to text
I"m trying to make a script to transform a column with dates to text. Normally i would just use the TEXT function but the issue is that the new text values need to replace the old date values. The dates are now in three columns with the number notation date and it needs to be a text with the form "dd/mm/yyyy". Since i need to do this for at least 50 files i tought about using a script to make a new column & use the text funcion to get the new values for all three columns Change the date notation on the new values to text copy the new text values to the old column Delete the new column. The issue i meet is at the second stap that the values are in a table and are not all the same length. At the moment i have this for first step in a script function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Insert at range E:E on selectedSheet, move existing cells right selectedSheet.getRange("E:E").insert(ExcelScript.InsertShiftDirection.right); // Set range E2 on selectedSheet selectedSheet.getRange("E2").setFormula("=TEXT([@Geboortedatum],\"dd/mm/jjjj\")"); // Insert at range Q:Q on selectedSheet, move existing cells right selectedSheet.getRange("Q:Q").insert(ExcelScript.InsertShiftDirection.right); // Set range Q2 on selectedSheet selectedSheet.getRange("Q2").setFormula("=TEXT([@[Datum Resultaat]],\"dd/mm/jjjj\")"); // Set range S2 on selectedSheet selectedSheet.getRange("S2").setFormula("=TEXT([@Startdatum],\"dd/mm/jjjj\")"); } And as second step function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Set format for range E:E on selectedSheet selectedSheet.getRange("E:E").setNumberFormatLocal("@"); // Set format for range Q:Q on selectedSheet selectedSheet.getRange("Q:Q").setNumberFormatLocal("@"); // Set format for range S:S on selectedSheet selectedSheet.getRange("S:S").setNumberFormatLocal("@"); } But i'm stuck at the third step. If there is an easier method that would be fine toFootball Pool Sheet Using Logical Formula
I run a local football pool and I developed a great spreadsheet, but I want to add another wrinkle to it I type in a W or L based on the result of the score to each teams spread I copy and paste all the scores based on rotation so its easier to sort I want to have the formula automatically insert a "W" or "L" based on the difference in score and spread after i paste all the scores If you think I need to add or do something else to make it easier, please let me know I WOULD LOVE TO KNOW HOW TO LINK LIVE TIME SCORES WITH A WEBSITE, BUT ONE STEP AT A TIME LOL THANK YOU!!!!!
Autosave makes Excel unresponsive every 2 mins
I have a XLSB file about 1MB in size. It is stored in OneDrive. AutoSave is ON. If I work with it (change data, apply filters, change tabs) - everything is fast. But as soon as I stop (sometimes I have to think about my next move). After about 5 seconds of inactivity - I see the blue circle spinning, Saving... words in the Excel title bar. Excel is frozen for the next 5 seconds. I get it. It is syncing my recent changes to the cloud. But hey... I am trying to work here... It is very disturbing to see the application frozen. And it is happening often. Like pretty much every time I stop making changes to Excel file. If I turn off AutoSave - then no issue. But I like AutoSave. If I could control how often it syncs it to the cloud. I've tried changing Excel Options in the Save section. Like Save AutoRecover Information every XX minutes. It does not seemed to effect how often the AutoSave is triggered. Any advice is very much appreciated.
